Your cart is empty now.
Do you still prefer to use Google Sheets Planners or Microsoft Excel Templates to organise your business and personal lives? I am that old-fashion girl that still sticks to spreadsheet for managing my daily lives. As a visual person, I love to have images in my spreadsheets, for easy reference, and of course, to make it less boring.
If you are here after purchasing Google Sheets template from my shop, thank you and I appreciate you for allowing me to continue sharing more free educational content like this ❤️
In this article, I'll share with you 3 different methods to insert an image in Google Sheets, from easy to the more advanced ones!
The fastest and simplest way to add an image to Google Sheets is to copy and paste.
Steps to insert an image to the spreadsheets are as below:
To make adding image in Google Sheets even faster, you can use shortcut keys to copy-and-paste the photo (if applicable)
|Copy||Ctrl + C||Command + C|
|Paste||Ctrl + V||Command + V|
By default, when you paste the image, the image would appear on top of the spreadsheets grid. In Google Sheets, it's known as placing the image "over the cell", which means the image is not fixed to any cell.
If you wish to move the image to be inside a specific cell, you can click the three vertical dots at the top right corner, and select “Put Image in Selected Cell”. Lastly, select a cell to insert the image.
If you wish to fixed the uploaded image from your local computer, you can use the second method:
Want to make your image looks more professional and align with your company branding? you can use Canva to edit your photo before uploading it to Google Sheets. Get your 14 days FREE access to Canva Pro now. This is an affiliate link, Danalyser will get small commission if you decided to subscribe to Canva service. You'll get lifetime free account access after signing up.
If your image file has a url link and you'll want the same image to repeat across many places within the same spreadsheet or even in multiple spreadsheets, it's best to use function as it's easily flexible, replicable and can save you tons of time manually uploading the photos.
To add an image to Google Sheets using formula:
You may image in the format of .png, .jpg, or .gif to Google Sheets. However, the size of the image is limited to 50 MB, which I think is quite sufficient.
In case you are inserting any photo that is not taken or created by you, it's important to check out Google Sheets image usage guidelines.
It's not possible to add a video to Google Sheets. However, if your video is short enough, you may try converting the video to GIF. There are some free video converter available on the internet. Personally, I have tried using Online Converter.com and giphy.com to convert my video file from .mp4 to .gif.
If you need to download the converted gif file, Converter.com is a better option. If you need to host the gif on your blog or share to someone, Giphy is definitely the go-to tool, you can even trim your video file before converting to gif.
If you find this article helpful, share it with your friends or connections that would love to learn about this amazing function.