docs / articles / Create Inventory List in Excel: Step-by-Step Guide

Create Inventory List in Excel: Step-by-Step Guide

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

Streamlining your inventory management process starts with creating an efficient inventory list. Excel, with its robust features and widespread use, is an excellent tool for this task. This guide will walk you through creating a comprehensive inventory list in Excel, ensuring you maintain accurate records and optimize your inventory management.

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

Before diving into the steps, ensure you have the latest version of Excel installed on your computer. This guide uses Excel 2016 and 365 as references, but the process is similar in other versions.

FREE Printable Inventory List Templates
FREE Printable Inventory List Templates

Setting Up Your Inventory List

Begin by opening a new or existing workbook in Excel. For a clean start, click on "File" > "New" > "Blank workbook."

Download Inventory Value Stock Excel Spreadsheet Sample
Download Inventory Value Stock Excel Spreadsheet Sample

Name your worksheet "Inventory" or a relevant title that suits your business. To rename, click on the sheet tab at the bottom and type in the new name.

Defining Your Inventory List Columns

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

Create headers for your inventory list in Row 1. Essential columns include:

  • Item ID/Code: A unique identifier for each item.
  • Item Name: The full name or description of the item.
  • Quantity on Hand: The current stock level.
  • Reorder Point: The minimum quantity before a restock is needed.
  • Unit Price: The cost of one item.
  • Supplier: The vendor or manufacturer of the item.

You can add more columns based on your business needs, such as "Category," "Location," or "Last Purchased Date."

Stock In Out and Balance Template in Excel | Inventory Management Template
Stock In Out and Balance Template in Excel | Inventory Management Template

Formatting Your Inventory List

Apply consistent formatting to your inventory list for easy reading and organization:

  1. Freeze the top row for headers by clicking on the row below the headers (Row 2), then go to "View" > "Freeze Panes" > "Freeze Top Row."
  2. Adjust column widths by hovering over the line between two column headers, then dragging it to the desired width.
  3. Apply auto-filter to easily sort and filter your data. Click on any cell in your data range, then go to "Data" > "Filter" (the icon looks like a funnel).
My simple and easy method for tracking product inventory using Excel spreadsheets
My simple and easy method for tracking product inventory using Excel spreadsheets

Your inventory list should now be well-structured and easy to navigate.

Populating Your Inventory List

Free Household Inventory List Template In Google Sheets
Free Household Inventory List Template In Google Sheets
36+ Printable Inventory List Templates | ExcelSHE » ExcelSHE
36+ Printable Inventory List Templates | ExcelSHE » ExcelSHE
Simple Inventory Checklist
Simple Inventory Checklist
Inventory List Templates | 20+ Free Printable Xlsx, Docs & PDF Formats, Samples, Examples and Forms
Inventory List Templates | 20+ Free Printable Xlsx, Docs & PDF Formats, Samples, Examples and Forms
the office supply inventory sheet is shown in this image, it shows several items that are available
the office supply inventory sheet is shown in this image, it shows several items that are available
Track inventory
Track inventory
Excel inventory list templates help you keep track of items for your business or home
Excel inventory list templates help you keep track of items for your business or home
Free Printable Stock List Template - Manage Your Product Inventory
Free Printable Stock List Template - Manage Your Product Inventory
Cash Flow Templates - Reseller Tracker Spreadsheet Template Excel Inventory & Sales for Etsy eBay
Cash Flow Templates - Reseller Tracker Spreadsheet Template Excel Inventory & Sales for Etsy eBay
How to Create an Inventory List in Excel (with Pictures)
How to Create an Inventory List in Excel (with Pictures)
Clothing Inventory Template
Clothing Inventory Template
Printable Simple Minimalist Table Style Inventory Sheet
Printable Simple Minimalist Table Style Inventory Sheet
Copy of Inventory Count Sheet Template
Copy of Inventory Count Sheet Template
The Best Pantry Inventory Spreadsheet - your template for food inventory.
The Best Pantry Inventory Spreadsheet - your template for food inventory.
Household Inventory List Templates - Excel Word Template
Household Inventory List Templates - Excel Word Template
FREE 9+ Inventory List Templates in MS Word | Excel | PDF
FREE 9+ Inventory List Templates in MS Word | Excel | PDF
how to make an inventory System Sheet in excel | how to create an inventory spreadsheet
how to make an inventory System Sheet in excel | how to create an inventory spreadsheet
the inventory log is shown in black and white
the inventory log is shown in black and white
Efficient Inventory Tracker for Businesses & Resellers | Google Sheets & Excel Templates
Efficient Inventory Tracker for Businesses & Resellers | Google Sheets & Excel Templates
10 Free Inventory Templates + Instructions
10 Free Inventory Templates + Instructions

Start adding your inventory items one by one or import data from an existing list. To add manually:

  1. In the first empty cell under "Item ID/Code," type the ID or code for the first item.
  2. Fill in the remaining columns with the relevant information for that item.
  3. Press "Enter" or "Tab" to move to the next row and repeat the process.

To import data, click on "Data" > "Get & Transform Data" > "From Table/Range," then select the range containing your data and click "OK." Follow the prompts to import and transform your data.

Using Formulas to Calculate Reorder Points

To save time, use Excel's SUMIF function to calculate the total quantity on hand and set reorder points. Assume you have a separate sheet named "Locations" with columns "Item ID/Code," "Location," and "Quantity on Hand."

In your "Inventory" sheet, enter the following formula in the "Quantity on Hand" cell for the first item:

=SUMIF(Locations!A:B, A2, Locations!C:C)

This formula sums the quantity on hand for the item in all locations. Drag the formula down to apply it to all items.

Calculating Total Inventory Value

Add a new column named "Total Value" and enter the following formula in the first cell:

=B2*C2

This calculates the total value of each item by multiplying the "Quantity on Hand" by the "Unit Price." Drag the formula down to apply it to all items.

Your comprehensive inventory list is now complete, providing you with a clear overview of your stock and enabling you to make informed decisions about restocking and inventory management. Regularly update your list to maintain accurate records and optimize your inventory process.