The Attachment data type allows you to attach images, documents, and other files within cells. Attached files are displayed as clickable thumbnails and can be previewed or downloaded by workbook users.
With Spreadsheet.com, your Attachments can live in cells. Drag and drop documents and images into cells or import from Google Drive, OneDrive, Box, Dropbox, or other links. You can use Attachment data types to store applicant resumes in a workbook of candidates, possible menus for your new restaurant, or creative storyboards for a new commercial your team is developing.
How to Add an Attachment to a Cell
To add an attachment, first change the cell or column data type to Attachment. Then you can either drag and drop into the desired cell. Or browse local and cloud services (like Dropbox, Google Drive, OneDrive, or other links) for your file.
Once you have uploaded the attachment, you can preview the attachment by clicking on the thumbnail and expanding. Or download any attachments already in the cells. All Spreadsheet.com users with Editor, Collaborator, Manager, or Owner permissions can add attachments, but the size of each attachment is limited to 5 MB.
Pasting attachments from the clipboard
If you have an image in your clipboard (i.e., you right-clicked on an image and clicked "Copy"), you can select an attachment cell and press CTRL+V to paste the image into the cell. It will be uploaded as an attachment, just as if you used the dialog (but faster).
Pasting attachments is useful if you are, for instance, using Spreadsheet.com to track bugs in your software. You often take screen captures of issues and paste them in as you find them. With Spreadsheet.com, you can quickly add a row for a bug and paste the screenshot from your clipboard into an attachment cell.
Supported File Types
Spreadsheet.com supports the following file types in Attachment cells:
- Spreadsheets: xls, xlsx, ods, ots
- Document: doc, docx, odt, ott, pdf
- Presentation: ppt, pptx, odp, otp, odg
- Graphics: bmp, gif, jpg, jpeg, png, svg
Each of these four categories of file types can be previewed by clicking the thumbnail of the file, but each uses a different previewer to preview.
- Spreadsheet files are rendered as a workbook with clickable worksheet tabs.
- Presentation files are rendered in a presentation view with animations intact.
- Documents are rendered in an easy to use document viewer with search and various view options.
- And images are shown in a higher resolution than the thumbnails (though not as high as the original file).
Like other data types, Attachment data types can be have Strict enabled. Selecting the Strict checkbox for Attachment cells will restrict users to only attaching files (as opposed to text, users, numbers, etc.) Also, columns that have Strict enabled cannot have cells of different data types.
Allow Multiple Attachments & Thumbnail Size
You can choose to limit each cell to one attachment or many.
Also, adjusting the thumbnail size changes your row heights and the height and width of attachment thumbnails in the row. Changing row height is especially useful for large image files, as Large or Extra large thumbnail sizes can be more easily viewed without expanding the cell.
For even more insight into what you can do with Spreadsheet.com, unique attachment data types (including deleting, reordering, and more) see our articles on Attachment Columns and Cells.