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.
- Click the cell where the picture should go.
- "On the Insert tab select Illustrations."
- "Select Pictures, then Place in Cell."
- Choose where the picture comes from: This Device, Stock Images or Online Pictures.
- 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.
