And an image to a spreadsheet

Embed an Image into a Spreadsheet

You can insert an image onto a Google Sheets spreadsheet by using the Insert menu, but what if you want the image in a cell instead? This is a little trickier.

Image URL

The first thing you need is an image URL. This means it needs to be uploaded to the Internet somewhere, and that is NOT Google Drive. The link from Google Drive is NOT an image link, it is a file link. If the image is uploaded to a website you can right click and choose “Copy Image Address.”
Copy Image Address

Google Sites

Not sure how to get your picture on the Internet? Try adding it to a Google Site and publish the site. From the published site, right click on the image and choose “Copy Image Address.”
Copy image address from the Google Site page

=IMAGE()

In the spreadsheet use the formula =IMAGE(“URL”). Notice the URL is in quotations.

Example: =IMAGE(“https://render.bitstrips.com/v2/cpanel/460288e6-d9a7-4c1a-82a1-2a6f5526f5c6-ea26ef0c-2550-4b7e-96a3-9a0153566a8d-v1.png?transparent=1&palette=1”)

Width and Height

Changing the width of the column and the height of the cell changes the size of the image.
insert an image and adjust the cell size

For more information and options visit the Google Sheets help page.




Digiprove sealCopyright secured by Digiprove © 2018

January 3rd Brea, CA

Go Slow Live Workshop

Participate in person or online.

Click Here for details.