Adding Images in Attachment Cells

The Attachment data type is one of Spreadsheet.com's unique features, allowing users to add images directly in cells of their worksheets.

Use attachments to share design documents and draft UI images in your team's mobile app project plan, include employee photos in an employee database, or attach product images in an inventory tracking workbook.

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 the image, or import an image from Google Drive, Box, Dropbox, or OneDrive. 

Dragging and Dropping an Image

Dragging and dropping images is one of the easiest and quickest ways to add images to cells. Navigate to an image on your computer, click and drag it to the browser window with your workbook open, and drop it into a cell.

Drag-and-Drop.gif

Pasting Images from the Clipboard

You can also copy and paste one image at a time into an attachment cell. Begin by copying the image from your device or online service. Open the Add attachment dialog by clicking the paper clip icon in your attachment cell.

AddAttachment-Button.jpg

With the dialog open, press Ctrl+V or your corresponding paste keyboard shortcut to paste in the copied image.

Uploading Images

You can upload images directly from your device via the Add attachment dialog as well. From the dialog, select "My Device" on the right hand side of the import options list, or click the "browse" link.

MyDevice-Locate.jpg

Both options will open your computer's file explorer, from where you can locate and select the desired image or images to upload into your attachment cell.

Importing Images

Spreadsheet.com also supports image imports from hosting services like Dropbox and Google Drive. From the Add attachment dialog, click on the icon of the corresponding service from where you want to import an image.

ServiceImportOptions.jpg

If this is your first time connecting the service to Spreadsheet.com, follow the instructions to connect your account to the corresponding service (Google Drive, Box, OneDrive, or Dropbox) and allow Spreadsheet.com access.

For more information on connecting your third-party accounts with Spreadsheet.com, see our series of articles on Attachment Columns and Cells.

Once the service is connected to Spreadsheet.com, navigate to the location of the images you wish to import, select the images for import, and import them. You can import one or more images into a cell and will have a chance to preview the images to check they were imported.

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. Or read on through the rest of our series on Images to learn more about working with images in your workbooks.