1. Go to settings
To insert images in cells to to the settings tab and select the Image in cell option. Enter one at a time the width and height of your cells.
2. Sharing with access permissions rules
If you want to share the sheet with other set the appropriate permissions.
You can share some files with one type of access and others with a different type of access.
The access setting must be set before you insert/add files to your Sheets. The default setting is PRIVATE.
The options from the most secure to the less secure:
PRIVATE – Only people explicitly granted permission can access the files inserted with FileDrop.
DOMAIN WITH LINK – People in your domain who have the link can access. Not for users with @gmail.com.
DOMAIN – People in your domain (email@example.com) can access. Not for users with @gmail.com.
ANYONE WITH LINK – Anyone who has the link can access. For any type of Google emails or Workspace accounts.
ANYONE – Anyone can access. For any type of Google emails or Workspace accounts.
3. Use the drag and drop interface or select
Go back to the upload tab and drag and drop your images. The image will upload in your Drive folder and it will display in the Sheet cell.
- Free users can add up to 4 images at once.
- Paid users can add up to 25 images based on your plan.
4. Bulk image insert
To insert images in bulk please use the Drive tab with the insert all button or select only the images you want.
An alternative is our dedicated Image Kit sidebar.