The Attachment data type is one of Spreadsheet.com's unique features, allowing users to add files directly in cells of their worksheets. In particular, images can be added and viewed directly in the Sheet and Kanban views of a worksheet.
Add images, for instance, to share design documents and draft UI images in your team's mobile app project plan or store screenshots of software bugs in your team's bug tracker.
Before an image can be uploaded to a cell, that cell or column must be set to the Attachment data type. Once a cell is set to the Attachment data type, you can either drag and drop the image, paste the image, browse your computer to upload, or import a file from Google Drive, Box, Dropbox, OneDrive, or other links. Adding images functions the same as adding other attachments, except that images can be easily displayed and enlarged in your views.
To Drag and Drop an Image
Dragging and dropping an image is one of the easiest methods to add files to cells. Simply navigate to where the image lives on your computer, drag it to where your workbook is open in a browser, and drop the image into the cell.
Pasting Images from the Clipboard
Image files can also be copied from your device or online and pasted directly into Spreadsheet.com. First, copy the image you would like to add to a cell (please copy only one image at a time, or use the upload feature to add multiple images at once). You can do this by pressing CTRL+C on an image file or by taking a screenshot of your screen or a portion of it.
Next you can select the target cell and press CTRL+V to paste the image from your clipboard into the cell. This will upload the image into the cell and show you a thumbnail in the cell once the upload is complete.
Alternatively you can open the add an attachment menu in the desired cell by clicking on the attachment icon in that cell as shown here:
With the add attachment window open (example below), simply press CTRL+V or your corresponding paste keyboard shortcut to paste in the copied image.
In the animation below, we locate the cell to paste a JPG image into, go to our desktop to copy the image using keyboard shortcuts, paste the image back in our add attachment window again with keyboard shortcuts, and upload it into Spreadsheet.com
You can also use the add attachment feature in Spreadsheet.com to browse your device for the desired image.
To browse and upload an image, first, open the add an attachment menu in the desired cell by clicking on the attachment icon in that cell.
With the add attachment window open (example below), click the browse link or the My Device icon.
Clicking one of these options will open up a file explorer on your computer. From this window, you can navigate to the desired image or images and upload the image(s) into your cell.
You can also import Images from file hosting services like Dropbox and Google Drive. To import an image, first, open the add attachment menu in the desired cell.
With the add attachment window open (example below), select the icon of the corresponding service you would like to add your image from.
If this is your first time connecting the service to Spreadsheet.com, then follow the instructions to connect to the corresponding service (Google Drive, Box, OneDrive, or Dropbox) and allow Spreadsheet.com access.
Once the service is connected to Spreadsheet.com, navigate to the location of the image files you wish to import, select the image(s) for import, and import them. You can import one or more image files into a cell and will have a chance to preview the files to check they were imported correctly.
In the animation below, we connect our dropbox account and choose two files for import. One is an image and the other a document, but you can follow the same steps to import multiple images.
Attachments are a great way to bring other relevant data and documents into Spreadsheet.com. You might also be interested in the Related Rows data type, which allows you to connect data across workbooks. Check out our attachment articles to learn more about attachments, including how to view, rename, or remove attachments. Or our articles on Images to learn more about adding images to your worksheets.