Uploading Files to Spreadsheet.com

One of the great things about Google Sheets is that, when it comes to uploading images, you have the option to either upload images over cells (like you would with a text box), where they can be moved and resized freely, or upload the images inside the cells. However, you can upload files to a spreadsheet including images, PDFs, and Word docs to Spreadsheet.com and then some.

Not only can you upload images inside the cells, but you can also upload other file types such as PDFs, DOCX et cetera – a feature that is non-existent in both Google Sheets and Excel.

Uploading an Image over Cells in a Spreadsheet

Fist, to upload an image over a cell(s) in Spreadsheet.com, go to Insert > Image and select the desired image from the respective source:

Insert menu with Image selected
Go to Insert > Image

It’s worth noting that Spreadsheet.com gives you the option to upload your image from various sources. Beyond uploading from your device, you can also upload from Google Drive, Box, OneDrive, or Dropbox:

 

Types of file upload to choose from for the spreadsheet
Various upload sources are available

 

 

Uploading an Image inside a Spreadsheet Cell

To upload the image inside a cell, you have to first set the data type of the column to “attachment”. To do this simply click on the respective column header, click on the dropdown on the far right of the column header, click on “Edit data type…” and select “attachment”:

 

Edit data type selected on right-click menu
Go to the column header and click on “Edit data type…”

 

Updating the column to the Attachment data type
Set the type to “Attachment”

 

Notice that in the above pop-up, you have the option to make the cells of the column small, medium or large in order to comfortably accommodate the file types to be attached. There’s also the option to set the data type as strict which would prevent the entry of any other data type in the column save for the specified one.

Once the column data type is set as “attachment”, images can be added inside any cell in that column. To do this, simply click on the cell to add an image to, click on the “attach” icon:

 

Paperclip icon showing how to upload file to spreadsheet

Uploading other file types to your spreadsheet

As mentioned before, Spreadsheet.com edges out both Google Sheets and Excel considering the fact that you can upload files such as PDFs. But how do we upload other file types? Quite simply:

  • Set the column data type to “attachment” (as explained above)
  • Upload the desired file and it’s going to appear inside the cell. 

A PDF file stored inside a cell would look like this:

Spreadsheet cell showing that you have uploaded your file to the spreadsheet

Upon clicking the PDF, the document should open.

Note: Notably, you cannot add attachments to your primary column. You’d first have to de-select the primary column setting before you can add attachments to any cell in that column. Conversely, you cannot set a column to be a primary column if the specified data type is not “Standard”. You can read more about primary columns here.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>