How to insert GIF images in Google Sheets

Projects created in Google Sheets are not always used exclusively for business purposes. Sometimes it is necessary to create some kind of presentation so that the document is not only functional, but also beautiful. Of course, you can use different design styles and insert simple images, but a small looped animation in the form of a gif can also give the right note. As part of this article, I do want to discuss the topic of inserting GIFs in Google Sheets.

Search for a suitable animation

Here I want to show how you can quickly find the relevant files through the search engine and copy the link for insertion into Google Sheets without downloading the animation to your computer.

  1. I will use the proprietary search engine, but you can choose any other. Request your topic, go to the pictures and click on the button “Tools”to open the filter panel. Select as type GIF and wait for the results to download.Using image search filters to insert a gif in Google Sheets

  2. You can now see that each image option has an icon next to it GIFwhich means file format.Getting to know the formats for inserting gifs in Google Sheets

  3. Select the appropriate animation, click on it with the right mouse button and select an item from the context menu “Copy URL images”.Copy link to insert gif in Google Sheets

  4. If you want, you can download the GIF directly to the computer, the principle of importing into the project will be almost identical.Uploading a file to insert a gif in Google Sheets

The community is now in Telegram

Subscribe and stay up to date with the latest IT news

Sign up

Inserting a GIF into a Google Sheet

The preparation is complete and you have a link or GIF in your hands. It remains only to insert it into the table, adjust the position and size. For this, a standard web service function is used, and the whole process looks like this:

  1. Open the required document, call up the menu “Insert”in it, put the cursor on “Image” and select an option “Insert image on top of cells”. Note that the function “Insert image into cell” is not appropriate in this case as the animation will not play.Choosing the right tool for inserting gifs in Google Sheets

  2. If you copied the link to the gif in the example above, go to the tab “Paste URL”paste the link in the corresponding field and click the button “Insert Image”.Insert a link to insert a gif in Google Sheets

  3. Wait a few seconds, after which the gif should appear in the table and play an infinite number of times. You can select it with the left mouse button, resize it or move it to any other place.Waiting for content to load to insert gif in Google Sheets

If it is not about inserting a link, but about selecting a file with animation that is stored on the computer, the principle of action practically does not change.

  1. Select the same paste option from the menu.Go to file selection for inserting a gif in Google Sheets

  2. On the tab “Add” press “Review” or drag and drop the file into the highlighted area.A button to select a file for inserting a gif in Google Sheets

  3. If you press the button, a window will open “Guide”in which you need to find the GIF, and then confirm the discovery.Selecting a file to insert a gif in Google Sheets

  4. Adjust the size and position of the animation, as well as check the correctness of its reproduction.Uploading a file to insert a gif in Google Sheets

Finally, I will note that sometimes a more beautiful effect of using GIFs can be achieved by importing an animation with a transparent background. In this case, only a small area of ​​the table will be covered, and other cells will be visible. You can write something in them or even use different formulas.

Inserting a gif with a transparent background in Google Sheets

Now you know that adding animations to Google Sheets is easy. Use the provided instructions to improve the appearance of the project and prepare it for demonstration to other users. If you are interested in other basic functions used in this web service, I suggest you read the article: Google Sheets for dummies: tools and service capabilities.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2023 - Theme by WPEnjoy · Powered by WordPress