By default Google Sheets lacks the ability to store files directly within spreadsheet cells. However, the FileDrop add-on offers a convenient solution to this limitation.
With FileDrop’s simple drag-and-drop interface, saving files in Google Sheets becomes a breeze. The files are automatically saved to your Google Drive, and a link to the file is inserted in the chosen cell.
Files can be inserted as links, multiple links can be inserted in a cell, or if it’s an image it can inserted as image.
How to save files in Google Sheets step by step:
Step 1 – Install FileDrop
Install the FileDrop add-on from the Google WorkSpace Marketplace.
Step 2 – Start FileDrop
Initiate FileDrop Add-on: Click Extension Menu > FileDrop > Start. If ‘Start’ isn’t visible, simply refresh the page.
Step 3 – Add your file
Choose the Google Sheet cell for your file, click or drag-and-drop into FileDrop’s upload area. The file auto-uploads to Google Drive, and the cell displays the linked file name.
Add files to Google Sheets Video
Please view the video tutorial below to see how easy it is to use FileDrop to save files in Google Sheets cells.
Conclusion
In conclusion, while Google Sheets lacks a built-in feature to save files directly within its cells, the FileDrop add-on provides an efficient solution to overcome this limitation.
By utilizing FileDrop’s user-friendly drag-and-drop interface, you can effortlessly save files to your Google Drive, automatically linking them to the selected cell in your spreadsheet.
Just follow these simple steps:
- Install FileDrop from the Google WorkSpace Marketplace.
- Initiate FileDrop by clicking on the Extension Menu, then FileDrop, and finally Start. Refresh the page if needed.
- Select the desired Google Sheet cell, and either click or drag-and-drop your file into FileDrop’s upload area.
The seamless integration of FileDrop with Google Sheets empowers users to store and organize their files efficiently, enhancing their overall productivity.
Frequently asked questions
What types of files are supported for upload in Google Sheets?
Google Sheets allows the upload of any file type supported by Google Drive, including PDFs, images, zips, videos, and more.
Where are the uploaded files stored?
By default, uploaded files are stored in the FileDrop folder, which is created during the add-on installation. However, you have the option to select a different folder for storage if desired.
