Inventory Spreadsheet With Pictures: Template Guide

Yes. You can make an inventory spreadsheet with pictures in Excel by creating a table for item details and adding a photo column. A practical template includes an item ID, description, quantity, reorder point, location, photo, and last-counted date; Excel for Microsoft 365 can place pictures in cells in supported versions, or keep them as objects positioned over the sheet.

What the template should contain

Start with one row per distinct item or product variant. Give each row a unique identifier, such as a stock code or barcode number, so similar-looking products do not get confused. A compact set of useful columns is:

Item ID: A unique code used on labels, receipts, or product records.
Item name and category: A plain-language description and a category such as tools, office supplies, or clothing.
Quantity on hand: The number physically available at the time of the count.
Reorder point: The quantity at which someone should review whether to restock.
Unit cost: Optional, useful for an approximate stock-value calculation.
Storage location: A shelf, room, bin, or other place someone can find the item.
Photo: A clear image that helps distinguish the item from similar stock.
Last counted: The date the quantity was checked, not necessarily the date it was entered.

For example, a row might describe item T-104, a cordless drill, with a quantity of 3, a reorder point of 4, and location Aisle 2, Bin B. Its photo can show the model and distinguishing features. The photo supports identification, but the item ID and written description remain important because images can be hidden, resized, or difficult to compare.

Choose how pictures will appear

There are two useful approaches. In current Microsoft 365 builds that support it, use the option to place a picture in a cell. In Excel for Windows, look under Insert > Pictures > Place in Cell, then choose a source such as a picture on the device. The image belongs to the cell, so sorting and resizing rows is generally easier to manage. The exact options can vary with the update channel and account, so check the Pictures menu if you do not see Place in Cell.

The traditional method inserts a picture over the worksheet grid. In Windows, use Insert > Pictures > This Device, select the file, then resize and position the image over the photo column. This works in more versions, but the picture is an object on top of the cells rather than cell content. If rows are sorted or adjusted, confirm that the image stays with the correct item. Picture-format options can control how an object moves and sizes with cells, though labels and available choices vary by version.

On a Mac, the picture-in-cell feature and menu names depend on the installed Excel version. The standard insertion route is typically Insert > Pictures > Picture from File. If the in-cell option is absent, use the over-cell method and check image alignment after sorting. Excel for the web also has a different interface and may not offer every desktop picture control.

Build the spreadsheet in Excel

Open a blank workbook and enter the column headings in row 1. Keep headings short and specific, such as Item ID, Quantity, and Location.
Enter a few sample records and decide what counts as one item. If two versions have different sizes, colors, or stock codes, they may need separate rows.
Select the headings and data, then choose Insert > Table. Confirm that the table has headers. On Windows, Ctrl+T also opens the Create Table dialog; on Mac, use the Insert menu if the shortcut differs in your setup.
Use the table’s header filters to find categories, locations, or low quantities. Give the table a clear name from the Table Design tab if you expect to refer to it later.
Widen the photo column and increase row height enough to show a useful thumbnail. Add images using the in-cell or over-cell method, and keep each picture aligned with its record.
Save the workbook in a shared, backed-up location if multiple people need it. Before entering a large inventory, test the layout with several rows and check that sorting does not separate pictures from records.

A table is helpful because it keeps the header row available while scrolling and extends formatting and formulas as rows are added. It does not guarantee accurate counts: users still need an agreed process for recording receipts, removals, returns, and adjustments.

Keep descriptions and counts consistent

Choose simple rules before several people start editing. For instance, decide whether quantity means sellable units only or includes damaged stock, and record damaged or reserved items in separate columns if that distinction matters. Use one unit of measure consistently: do not enter a box in one row and individual pieces in another without making the pack size clear.

Use the same naming style for locations, such as Aisle 2 / Bin B, rather than mixing A2B, Bin B, and aisle two. Excel’s filters work best when equivalent values are spelled consistently. A category column can also be more useful than trying to encode every detail in a long item name. If the inventory is small, avoid adding fields that nobody will maintain; stale or misleading data can be worse than a simpler sheet.

Add simple stock calculations

A formula can flag records that need review. Suppose Quantity is in column D, Reorder point is in column E, and Status is in column I, with the first item on row 2. In I2, enter =IF(D2<=E2,"REORDER","OK"). If D2 contains 3 and E2 contains 4, the result is REORDER. If the quantity is 5 and the reorder point is 4, the result is OK. In an Excel table, the formula usually fills down the column as rows are added.

This is a reminder rule, not an automatic purchasing decision. A reorder point should reflect the organization’s own usage and replenishment timing; the spreadsheet cannot know whether a delivery is already on its way unless that information is recorded.

To calculate an approximate value for each row, assume quantity is in D2, unit cost is in F2, and the value column is K. Enter =D2*F2 in K2. With 3 units at a unit cost of 12, the result is 36. This is a simple extension-cost calculation, not a complete accounting valuation, and it depends on having current quantities and costs.

Prepare photos that are useful

Use images that help identify the exact item, not decorative pictures. A front view may be enough for a distinctive box, while a close-up of a model number or label can help with visually similar equipment. Use consistent lighting and framing so thumbnails are easy to scan. Crop unnecessary background when it obscures the object, and avoid making images so small that labels cannot be read.

Choose descriptive filenames before insertion, for example T-104-drill.jpg, if you also keep a separate image folder. This can make it easier to reconnect a photo if the workbook is rebuilt. Avoid relying on a temporary download folder or a personal desktop as the only copy. Depending on how an image is inserted, Excel may store the image in the workbook or retain a link to a file; linked files can go missing when the workbook is moved. Check the result on another device or after moving a copy to the intended shared folder.

Common problems and how to prevent them

Photos drift away from items: This is more likely with pictures over cells. Prefer pictures in cells where available, or test sorting and row changes before relying on object placement.
The workbook becomes large: High-resolution photos can increase file size and make opening or sharing slower. Use reasonably sized images rather than inserting camera originals when small thumbnails are sufficient.
Different items look alike: Include an item ID and written model or variant details. Do not treat a photo as a substitute for a unique code.
Counts stop being trustworthy: Record who counted and when, or add a notes column for adjustments. A number without a date may be out of date even if the sheet looks complete.
Sorting causes mistakes: Sort the Excel table using its header filters, not a single column outside the table. A partial sort can mismatch quantities, photos, and descriptions.

Conditional formatting can make a status column easier to scan. Select the status cells and use Home > Conditional Formatting to create a rule for values such as REORDER. Review the rule after copying or expanding the table so it covers the intended rows.

Sharing, access, and maintenance

Store the workbook where the people responsible for stock can access the current version, and avoid keeping multiple unofficial copies that are edited independently. If several users update quantities, agree who records transactions and how often a physical count is reconciled with the sheet. Excel co-authoring can support shared editing when the file is stored in a compatible OneDrive or SharePoint location, but permissions and organizational settings matter.

Inventory photos may reveal more than the product, such as room layouts, serial numbers, customer labels, or security arrangements. Photograph only what is needed, crop or exclude sensitive details, and share the workbook only with appropriate users. Back up the file and periodically test that the backup opens. For a controlled stock process, retain dated copies or use an approved record system rather than silently overwriting important history.

When a spreadsheet is no longer enough

A picture-based workbook works well for a modest inventory with a limited number of editors and straightforward counting needs. It is less suitable when the business needs barcode scanning, transaction history, multiple warehouses, permissions by role, purchase-order workflows, or dependable simultaneous updates at scale. Those needs may call for inventory software or a database designed to track changes and locations.

Another option is to store image files in a shared folder and keep their filenames or links in the spreadsheet. That can keep the workbook lighter, but folder permissions and link maintenance become part of the process. A paper checklist may be simpler for a one-time count, while a spreadsheet is more useful when people need to sort, filter, and update records over time.

Frequently Asked Questions

Can I put a picture inside an Excel cell?
Yes, in supported Microsoft 365 versions, use Insert > Pictures > Place in Cell. If that option is not available, insert the picture over the worksheet and position it within the cell area, then verify its alignment when rows or columns change.

Will pictures stay with items when I sort the inventory?
Pictures placed in cells are designed to behave as cell content. With pictures floating over the grid, behavior depends on their placement and settings, so test the sort on a copy first and confirm every image still matches its item.

How many photos should each inventory item have?
Usually one clear identification photo is enough for a simple list. Add another view only when it answers a practical question, such as distinguishing a model, showing a condition issue, or documenting a label that cannot be read in the main image.

Can I use image links instead of embedding pictures?
Yes. You can keep images in a shared folder and record a path or link in the row. This can reduce workbook size, but links may break if files are moved or users lack permission to the folder.

Does an inventory spreadsheet automatically update stock levels?
No. Formulas can calculate totals or flag reorder points from the values entered, but they do not know when stock is received, sold, used, or damaged unless someone records those changes or connects the workbook to another system.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.