10

There's an image in a Google Sheets that I would like to insert into a Google Doc.

How can I transfer the image from the sheet to the document?

I can right-click on the image and select "Copy", but that does not seem to actually copy the image to my clipboard. If I try to then paste into the Google Docs, it just pastes the text that was previously in the clipboard.

I also don't see any obvious way of exporting the image from the Sheets, nor do I see a way to import it as an URL.

8 Answers 8

1

You can either use keyboard shortcuts (Ctrl + C and Ctrl + V) or the web clipboard menu to copy and paste in Google Docs.

The Web clipboard menu appears in the toolbar of your doc.

1
  • 7
    Please don't answer if you don't know or if you have not try. This won't work May 16, 2018 at 10:29
5

Try dragging the image to the navigation bar of your browser, it will open the image url and you'll be able to save it to your system and load it to Google Docs.

2
  • 1
    This works for me. Jul 29, 2019 at 4:53
  • This no longer works
    – Joel Davis
    Apr 6 at 8:22
3

I have just found a simple way (It worked today May 17, 2022):

  1. Shift key + Right click on the image

It opens a menu.

  1. Choose "Copy image"

  2. Paste it normally (Right click on the destination app and click on "Paste", or do Ctrl + V) in any application you wish, like Paint, word or others...

I hope you find this helpful, I was also pissed about this limitation from Google sheets for a while, because I was using the "export" way downloading/exporting the whole html and finding the image in the created folder... (File -> Download -> click on "Web Page .html") which I also leave here just in case it is helpful for anyone.

1
  • Works as expected !
    – Tim
    May 23 at 7:55
2

There is a way to do this as of Apr 2021.

Right-click the image cell and select "Put image over cells". Once the image becomes larger, you can shift-right click the image and now you will get the "Save image as..." option.

After saving the image to a file, scroll to the top-right of the image and you will see three dots stacked on top of one another (may be hard to see on a dark background). Make sure the image cell is selected, and then click the top-right of the image (where the three dots are) and you will get a menu with an option that says "Put image in selected cell". Alternatively, you can use the Undo function (ctrl-Z) to undo this. Note that if you accidentally have the wrong cell selected, it will move the image to a different cell. Using the "undo" function is a bit more foolproof, but either way should work.

1

I think you have to click on the image and then use Ctrl + C to copy the image and then in your Google Doc use Ctrl + V to paste the image.

3
  • I tried it, it doesn't work. Doing Ctl+C (well, Command+C on Mac) does not copy it to clipboard for me, at least not in Chromium. Feb 23, 2011 at 4:23
  • @lorin - Hmm strange, works fine for me using Windows & Chrome. How did you insert the image? Using the menu item? Feb 23, 2011 at 7:31
  • I didn't insert the image, it was inserted by someone I'm collaborating with on the document. Feb 23, 2011 at 18:55
1

Well that's not simple as it seems to be. Dragging the image to the URL doesn't work any more. So the only way is to open the browser developer tools (ctrl+j or ctrl+k) and locate the element to extract it's URL. Then you can insert it using the URL you found out.

2
  • Worked for me as of Oct 2021
    – AjCodez
    Oct 26, 2021 at 22:49
  • Seems to be the best solution as of 2022
    – Joel Davis
    Apr 6 at 8:27
1

There is another way to copy image from Google Sheets:

  1. Paste the image in sheet
  2. Go to FileDownloadExcel
  3. Open the Excel sheet and you'll be able to copy the image that you had pasted in Sheets
1

Go to FileDownload asMicrosoft Excel (.xlsx).

From this Excel file you can copy the images to other documents.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.