Skip to content

Inventory List With Pictures: Excel and Google Sheets

How to make an inventory list with pictures: a picture in each row's cell in Excel or Google Sheets, when a photo helps and when it doesn't, a free file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A picture earns its place on an inventory list when two rows are hard to tell apart in words: two glazes, two shades of yarn, six sizes of the same bracket. Both big spreadsheet programs can now put a picture inside a cell, so it stays with its row when you sort or filter. In Excel for Microsoft 365 or Excel 2024 it's Insert, Illustrations, Pictures, Place in Cell. In Google Sheets it's the IMAGE function, which shows a picture from a web address. The older way, a picture floating over the grid, breaks the first time someone sorts the sheet. Below are the steps for each program, how to keep the file workable, a list for a made-up pottery studio, and the file to add your own pictures to.

The short version

  • Put the picture in the cell, not over it, so it sorts with the row.
  • Excel: Insert, Illustrations, Pictures, Place in Cell.
  • Google Sheets: =IMAGE("web address").
  • Add a Picture column at the left and make the rows taller.
  • Use small pictures. A sheet with 200 full-size photos is slow to open.
  • A picture doesn't replace a specific name and a code.
  • TaroStack counts stock on a phone, by item and place. More below.

In Excel

Microsoft's instructions for placing a picture in a cell apply to Excel for Microsoft 365 and Excel 2024.

  1. Click the cell where the picture should go.
  2. "On the Insert tab select Illustrations."
  3. "Select Pictures, then Place in Cell."
  4. Choose where the picture comes from: This Device, Stock Images or Online Pictures.
  5. Select the picture and select Insert.

Three more things from the same page:

  • Several at once. Select several pictures and they're inserted "starting from the active cell and down the column", one a cell, overwriting what was there. So photograph your items in the order of the sheet.
  • From the clipboard. Right-click a cell and choose Paste Picture in Cell. Plain Ctrl+V pastes the picture over the cells.
  • File types. JPG, PNG, BMP, ICO, WEBP, TIF and non-animated GIF.

A picture already floating over the sheet can be converted: select it and choose Place in Cell on the Picture Format tab. The page covers Excel for Microsoft 365 and Excel 2024. In a version without Place in Cell, a picture floats over the grid and won't sort with the rows.

In Google Sheets

Google Sheets uses a function. From Google's help page for IMAGE, which "inserts an image into a cell":

=IMAGE(url, [mode], [height], [width])

Mode What it does
1 (the default) Resizes the picture to fit inside the cell, keeping its proportions
2 Stretches or squeezes it to fill the cell
3 Leaves it at its original size, which may crop it
4 A custom size, with height and width in pixels

Two limits on that page matter for an inventory list. The picture has to be at a web address, and "you can only use URLs that aren't hosted at drive.google.com". And SVG files aren't supported. So the pictures need to live somewhere on the web that gives each one its own address, such as your own shop's product pages.

A neat arrangement is to keep the address in one column and show the picture in the next: put the address in B2 and =IMAGE(B2) in A2. Then the picture changes when the address does.

Laying out the sheet

Picture Item Unit On hand Reorder at Unit cost Value Status
(photo) Mug, speckled blue, 12 oz each 18 12 $6.25 $112.50 OK
(photo) Mug, speckled white, 12 oz each 7 12 $6.25 $43.75 REORDER
(photo) Bowl, cereal, speckled blue each 14 10 $7.10 $99.40 OK
(photo) Planter, small, matte black each 9 8 $5.40 $48.60 OK
(photo) Planter, medium, matte black each 4 6 $8.80 $35.20 REORDER
(photo) Spoon rest, assorted glazes each 30 20 $2.10 $63.00 OK

Six rows, $402.45 at cost, two to reorder.

  • Picture first. The eye finds the row by the picture, then reads across.
  • Tall rows. Make the rows tall enough to see the picture. In Sheets, mode 1 fits it to whatever size the cell is.
  • Small files. Resize photos before you insert them. A phone photo is far larger than a cell needs.
  • Same angle, plain background. The point is to tell rows apart at a glance.
  • Keep the name specific. "Mug, speckled blue, 12 oz" still has to work for someone reading the list aloud or searching it. A code helps as well: see how to create SKU numbers.

Building the rest of the sheet, with its formulas, is in how to create an inventory spreadsheet in Excel and inventory spreadsheet in Google Sheets.

Get the file

Download the inventory list. Four sheets: inventory with value and REORDER, a lots sheet, a count sheet and a read-me with the steps for adding a picture column. The file ships without pictures: add your own. It's an ordinary Excel file with no macros, and it opens in Google Sheets, LibreOffice and Numbers.

Where this stops working

Pictures make a sheet heavier and no more current. With two hundred photographed rows the file takes a while to open on a phone, and the On hand column is still whatever someone last typed. The helper can now see which mug is which. Whether there are seven of them or none is a different problem.

How TaroStack does it

TaroStack keeps the count current, which is the part a picture can't do.

Each item has its own name, code and stock, by place.

Barcodes: the phone's camera or a scanner finds the item when counting, receiving and picking, so nobody picks by reading a description.

Counting works on a phone with no signal. A count shows what each difference is worth.

One picking list for an order, by item and place.

A reorder list in days of cover.

The job Sheet with pictures In TaroStack
Tell two similar items apart The photo Scan its barcode
Know how many there are The last number typed Kept current
Pick an order Read down the list One picking list
Know what to make next Rows in red The reorder list

TaroStack isn't a picture catalog: keep product photos with your shop. Stock, counts, picking and reordering are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do I add pictures to an inventory list in Excel?

In Excel for Microsoft 365 or Excel 2024, click a cell, then on the Insert tab choose Illustrations, Pictures, Place in Cell, and pick the picture. It stays in the cell when you sort.

How do I put a picture in a cell in Google Sheets?

Use the IMAGE function with the picture's web address, for example =IMAGE(B2) with the address in B2. Google's help page says addresses hosted at drive.google.com can't be used.

Should an inventory list have pictures?

When items are hard to tell apart in words, yes. Keep the pictures small, and keep a specific name and a code for each row as well.

Sources

  1. Microsoft Support: Insert a picture with the Place in Cell feature in Excel (Excel for Microsoft 365, Excel 2024) · read November 21, 2026
  2. Google Docs Editors Help: IMAGE function · read November 21, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.