Clicky

files to google drive upload

How To Add or Attach Files in Bulk to Google Sheets Cells

Adding files manually to spreadsheet cells in Google Sheets is a painful task. Clicking manually on more than 3–4 files is going to take a lot of time. Introducing FileDrop, a simple add-on for Google Sheets that makes file management a breeze.

No matter if we talk about inserting images, PDF’s, audio files, or any other type of file, you can easily add 1000 files at once with a click of a button.

There are two ways to add files in bulk with FileDrop, via the drag and drop upload area or via our 1 click automations.

Option 1 – Drag and drop files in Sheets using FileDrop

Step 1 – Install FileDrop & Upgrade

You can install FileDrop from the Google Workspace Marketplace or from the Google Sheets Extension Menu > Add-on > Get Add-ons.

See also  The Best Way To Mass Upload Images In Google Sheets

Upgrade to any of our paid plans if you want to add more than 100 files and more than 4 files at once. Our paid plans allow for unlimited files and up to 25 files at once.

Step 2 – Open FileDrop

filedrop extension menu

Step 3 – Click to select or Drag and Drop files

Just click anywhere on the upload area or drag and drop your files. Once the files are uploadead they will be displayed in your Google Sheets cells.

Can I Drag and Drop Files Google Sheets 2

Keep in mind that the files will be added in random order depending on the size, not on the selection you made. 

Drag and Drop files using the FileDrop upload area video tutorial

Option 2 – Use 1 click automation for bulk file insertion

Step 1 – Add your files to a Google Drive folder

Before starting, please add all the files you want to insert in your Google Sheet to a Google Drive folder.

Step 2 – Install FileDrop & Upgrade

You can install FileDrop from the Google Workspace Marketplace or from the Google Sheets Extension Menu > Add-on > Get Add-ons.

See also  How to Use Date and Time Functions in Google Sheets

Upgrade to any of our paid plans.

Step 3 – Open FileDrop

filedrop extension menu

Step 4 – Select the Drive tab

Select the Drive tab and navigate to the folder you want by clicking through the folders.

Add files from Google Drive

Step 5 – Insert All Files

Once there, click on the Insert all files button and wait a few seconds. The files will be inserted in your Google Sheets cells.

list files in google folder in sheets

 

Attach files to Google Sheets cells in bulk video tutorial

Please view the video below on how to attach files to Google Sheets cells in bulk.

Import images in Bulk

We also have the Image Kit sidebar which allows you to import images in bulk.

Conclusion

Just install the add-on, upgrade to the Pro version, and drag and drop your files in the upload area or use the Insert All Files button. Your files are uploaded and automatically added to the selected cells or column.

As you can see adding files to your Google Sheets is easy with the FileDrop add-on.

Here is how you can do batch OCR PDF files with Google Sheets and Drive.

🎉 Save $50 with the Pro Yearly Plan
This is default text for notification bar