Answer the question
In order to leave comments, you need to log in
How to insert images into a Google Sheets cell via links from Google Disk or Dropbox?
Good afternoon. I insert an image into a Google Sheets cell using the formula
=IMAGE(" https://drive.google.com/file/d/0ByfYwOrLDHhwVGdWS... ")
Where I refer to an image that is on Google Disk of the same account where the table is located . However, the image in the cell does not appear.
I also try to insert an image from the link from Dropbox
=IMAGE(" https://www.dropbox.com/s/xobzhjb54o0whmj/XanotP5H... ")
the image does not appear.
However, the first image from the Google search results is quite successfully inserted and displayed in the table cell
=IMAGE(" i.space.com/images/i/000/005/972/original/sun-phot... ")
Answer the question
In order to leave comments, you need to log in
fixed to http without s at the end. Nothing has changed.
Found a solution!
For Dropbox, the link to the file needs to be converted as follows.
Link provided by Dropbox itself - https://www.dropbox.com/s/xobzhjb54o0whmj/XanotP5H...
Converted link to Dropbox that allows you to insert an image into a table cell - https:/ /dl.dropboxusercontent.com/s/qkw1p6w7dnczv5...
As you can see, you need to replace https://www.dropbox.com with https://dl.dropboxusercontent.com
in the link from Dropbox links to the file www.magentawave.com/2013/09/get-direct-link-on-fil...
I am ready to listen to all the pros and cons of such a solution in the form of link modification.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question