docs / articles / Excel Inventory List with Photos

Excel Inventory List with Photos

Sara Jul 09, 2026 2026-07-09 04:40:45

Streamlining inventory management is a breeze with Excel, and adding photos to your lists can significantly enhance organization and visibility. Imagine having a visual catalog of your stock right at your fingertips. This guide will walk you through creating an Excel inventory list with photos, making your inventory management more efficient and engaging.

Top 7 Excel Inventory Management Tips and Free Template
Top 7 Excel Inventory Management Tips and Free Template

Before we dive in, ensure you're using Excel 2010 or later, as the Insert Picture feature we'll use is available from this version onwards. Let's get started!

FREE Printable Inventory List Templates
FREE Printable Inventory List Templates

Setting Up Your Inventory List

First, create a new Excel workbook and name it "Inventory List". In the first sheet, name it "Inventory". Here, you'll list all your items with their respective details and photos.

An inventory list with a highlighting Template In Excel (Download.Xlsx)
An inventory list with a highlighting Template In Excel (Download.Xlsx)

Create the following columns: 'Item Name', 'Item ID', 'Quantity', 'Price', and 'Photo'. The 'Photo' column is where we'll insert the images.

Adding Photos to Your Inventory List

Free Household Inventory List Template In Google Sheets
Free Household Inventory List Template In Google Sheets

To add a photo to an item, select the cell where you want to insert the image (in the 'Photo' column). Then, click on the 'Insert' tab in the Excel ribbon. In the 'Illustrations' group, click on 'Pictures'.

Navigate to the location of your image file, select it, and click 'Insert'. The image will now appear in your Excel cell. You can resize it by dragging the corners or sides of the image box.

Linking Photos for Easy Updates

36+ Printable Inventory List Templates | ExcelSHE » ExcelSHE
36+ Printable Inventory List Templates | ExcelSHE » ExcelSHE

By default, Excel embeds the image into the workbook. However, if you want to link the image instead, follow these steps: After inserting the image, right-click on it and select 'Format Picture'. In the 'Format Picture' pane, under 'Properties', click on the dropdown arrow next to 'Picture', and select 'Link'.

Now, whenever you update the image file, Excel will automatically reflect the changes in your workbook. This is particularly useful when you have a large number of images or if the images are frequently updated.

Organizing Your Inventory List

How to Create an Inventory List in Excel (with Pictures)
How to Create an Inventory List in Excel (with Pictures)

With your inventory list set up and photos inserted, it's time to organize your data for easy navigation and analysis.

Sort your items by 'Item Name' or 'Item ID' for quick access. To do this, click on the column header, then click on 'Sort & Filter' in the 'Home' tab. Select your preferred sorting method and click 'OK'.

My favorite art inventory system
My favorite art inventory system
Stock In Out and Balance Template in Excel | Inventory Management Template
Stock In Out and Balance Template in Excel | Inventory Management Template
Free Office Supply Inventory List In Google Sheets
Free Office Supply Inventory List In Google Sheets
Home Inventory List Template
Home Inventory List Template
How to Inventory Your Photos
How to Inventory Your Photos
Grocery Inventory Templates | 7+ Free Printable Xlsx, PDF & Docs Formats, Samples, Examples
Grocery Inventory Templates | 7+ Free Printable Xlsx, PDF & Docs Formats, Samples, Examples
Personal Inventory Log Template for Excel
Personal Inventory Log Template for Excel
the inventory list is shown in this screenshote, which shows how many items are sold
the inventory list is shown in this screenshote, which shows how many items are sold
Inventory List Templates - Excel Word Template
Inventory List Templates - Excel Word Template
Inventory Sheet Template | Template Business
Inventory Sheet Template | Template Business
Sample Excel Inventory | Templates at allbusinesstemplates.com
Sample Excel Inventory | Templates at allbusinesstemplates.com
Google Sheets Inventory Templates Boost Efficiency in 2025, Wardrobe Inventory Spreadsheet
Google Sheets Inventory Templates Boost Efficiency in 2025, Wardrobe Inventory Spreadsheet
Free Printable Inventory List Sheet Template [PDF] - Printables Hub
Free Printable Inventory List Sheet Template [PDF] - Printables Hub
Ready to use Excel Inventory Management Template [User form + Stock Sheet]
Ready to use Excel Inventory Management Template [User form + Stock Sheet]
Create and Track a Basic Inventory List in Excel - Excel Inventory List Template
Create and Track a Basic Inventory List in Excel - Excel Inventory List Template
the inventory tracker spreadsheet for excel spreadsheet and google sheets
the inventory tracker spreadsheet for excel spreadsheet and google sheets
Small Business Inventory Spreadsheet Template
Small Business Inventory Spreadsheet Template
Sample Excel Inventory Spreadsheets Spreadsheets offered us the possible to input, adapt, and...
Sample Excel Inventory Spreadsheets Spreadsheets offered us the possible to input, adapt, and...
M.R.O. Goods Inventory List Template - Excel Word Template
M.R.O. Goods Inventory List Template - Excel Word Template
Home Inventory List Template
Home Inventory List Template

Filtering Your Inventory List

Excel's filter feature allows you to display only the items that meet specific criteria. This is particularly useful when you want to find items based on quantity, price, or any other column data.

To add filters, click on the 'Sort & Filter' button in the 'Home' tab, then select 'Filter'. Small triangles will appear at the top of each column. Clicking on these triangles will allow you to filter the data based on various conditions.

Creating an Inventory Summary

For a quick overview of your inventory, create a summary sheet. In a new sheet, list the total quantity and total value of each item category. You can use the 'SUMIF' function in Excel to calculate these totals automatically.

For example, if you have a column for 'Category', you can use the formula `=SUMIF(Inventory!B:B, A2, Inventory!C:C)` to calculate the total quantity of items in a specific category (replace 'A2' with the category name and 'Inventory!B:B' and 'Inventory!C:C' with the appropriate columns).

With your inventory list set up and organized, you're now ready to manage your stock efficiently. Regularly update your list, and don't forget to take advantage of Excel's built-in tools for analysis and reporting. Happy inventory management!