The East Way To Mass Upload Images In Google Sheets

The Best Way To Mass Upload Images In Google Sheets

If you need to easily mass upload images to Google Sheets you can do that with FileDrop.

In this tutorial I’m going to show you how you can add images in bulk to your Google Sheets. This can be done by adding the images as links directly from Google Drive or inserting them as images in cells.

Step 1

What we need for uploading images to Google Sheets  is the FileDrop Google Sheets add-on. If you don’t have it, please install it. With this add-on, you can add images in bulk and do a bit more than that.

Once the add-on is installed I click the Extensions menu – FileDrop – Start: now what I want to do is add images to a column. At the moment the addon does the insertion into columns.

Step 2

Go to Settings tab and click the option that you need. I have 3 options, and I am going to select the Don’t Add image option if I want to add images as links.

inserting images in google sheets

If I want to insert the images into cells I am going to select that option.

Step 3

Add as links

Now I’m going to go to the Upload tab and choose my files. I already have a list of product photos. I’m going to select a few and upload them.

See also  How to Save Files in Google Sheets

The images are now uploaded directly to Google Drive and the names will appear in my Sheet in the column I’ve selected from the selected cell down.

The names of the files are linked directly to Google Drive files, I can copy them and use them somewhere else. Also, if I don’t want an image I can go over an image preview I can
either delete by clicking the icon or copy directly using the copy icon.

If I delete it, it will disappear as well from my Google Sheets as well and it will be deleted from Google Drive.

Insert in cells

So that is the first option, the name of the images inserted in the cells. Now if I go back to Settings and I select the Image to Sell option, I go back to my upload area.

I click on the upload area so I can choose more files, the images are uploading again and the images are inserted into the cells automatically. Also, I can just drag and drop images to the upload area.

Here you can also set the cell size and adjust the width and height of the image to fit your needs.

images to cells sheets


Other things you can do with DropFile is you can see the history of your uploaded files so you can add them again if you want and you can even upload the images that are already saved in your Google Drive with the Drive tab.

See also  Generate Formulas and Rewrite Data in Google Sheets With ChatGPT AI

Insert over cells

You can add the images over cells in your spreadsheet. The image can be moved around over different cells area by left click and hold and also resized.

Other options

Add only the selected images

Using the Drive tab navigate to the folder where your files are and just click and select the files you want to add to your spreadsheet by holding the Shift button.

insert multiple files in FileDrop with shift key

List all images from the folder

The other option you have is to list all the images you have in the folder in the current Sheet. You can do that by navigating in the Drive tab to the folder where you have your images and clicking the insert all files button.

list files in google folder in sheets


View a quick tutorial on how to add the images in bulk in Google Sheets.

The Easy Way To Automatically Mass Upload Images In Google Sheets

That was it, that is the easiest way to add images in bulk to your Google Sheets. I hope this helps you and you use File Drop.

Back To School Promo - Ending Soon
This is default text for notification bar