fbpx

New: Easily Add Images in Google Sheets (Including Receipts)

It's now much easier to add your images to Google Sheets on desktop and mobile via a new Insert menu item.

On both desktop and mobile, Google has made it much easier to add images inside cells in Google Sheets.

Previously, the only option for putting images in a Google Spreadsheet was using the IMAGE function. However, that method was a bit clumsy and only worked with publicly hosted image files.

In addition to the IMAGE function, you can now insert any image, like those saved on your desktop or mobile device, into a cell with a new option found inside the Insert menu.

iVdPGp qRfuDkkrzXNYzYhWgJMm8WdvKuNkgn3cMhy 53615aewHwO ziYiPfqgtlcWNTYM5BRlVeXerj4KmxVfacEnP8AZKAm qfwGu65WPJFNOU8CSAevRUT1C8RsUtEXbDYuK

How it works

  • On Desktop:
    • Via the menu bar at the top of a Sheet: Insert > Image > Image in cell
    • Select image from Drive or upload one.
  • On Mobile:
    • Tap once on a cell to select
    • Tap again to bring up menu: Insert > Tap the “+” at the top of the screen > Image > Image in cell
    • Select an image from the options presented to you.
Kr7Dajc83g8FssS0m7uTXY9PB F0Csktq5TEi2CU0F6SOd0txt7k0E9Gv78rDg3NyQg1erURxhB X4h2t8 ADfKhR5MiOoIBDrLO9lpcWbSlzm B3KTFJt65lY 6rDG0dvO 9C5n

Ideas for how to use it

Many Tiller customers have asked for an easier way to use images with their spreadsheets, especially for receipts. (Previously we shared tips for using Google Keep and Sheets together.)

Other ideas:

  • Adding photos to help identify and track purchases.
  • Using food photos in a mean or food intake tracker.
  • Adding product images to inventory lists.
  • Using image icons instead of emoji in Google Sheets to add visual context to categories.
Google Keep in Google Sheets

Details

According to the Google Blog:

  • You can have multiple cells containing an image in a Sheet, but note that only one image per cell is possible at the moment.
  • Images inside cells will be associated with a row and move along with the data—so, if you move rows, filter or sort them, the images will move with the content in the row, unlike previously when images would sit on top of the grid.
  • Using the formatting and alignment tools, you can pin the image to a specific corner of the cell or set the alignment how you’d like. By default, images will align to the bottom left corner of the cell.
  • This feature will be ON by default

Helpful links

Tiller Money

Tiller Money

Your financial life in a spreadsheet, automatically updated each day.

Leave a Reply

Start Your Free Trial

Keep a clear, confident view of all your money in one place, with flexible templates, powerful privacy, and top-rated support

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023