Google-sheets – Is it possible to paste local images in Google Spreadsheet

databasegoogle sheets

I am wondering if this is possible in Google Sheets.

I am trying to create a visual database of products in the form of a shared spreadsheet. The images cannot be online for privacy and trade secret reasons.

So far I have been using Apple Numbers which allows this through drag and drop or copy paste functions.

This is more or less what it should look like:

enter image description here

I haven't found recent or clear explanations about this when I searched.

Best Answer

The term used on the Google Docs Editors Help Center are "insert" and "add".

From Insert or delete images or videos:

Add an image

  1. Open a document, spreadsheet, or presentation in Google Docs, Sheets, or Slides.
  2. Click Insert and then Image.
  3. Select from the following options:
    • Upload: Choose an image from your computer and click Open.
    • Take a snapshot: Use your webcam and click Take a snapshot.
    • By URL: Paste the URL of an image from the web and click Select.
    • Your albums: Choose an image from one of your photos albums stored on the web and click Select.
    • Google Drive: Choose an image stored in Google Drive and click Select.
    • Search: Choose an image from the stock photography archive, or the Google and Life archives, and click Select.
  4. Your image will be added to your file.