docs / articles / How to Create a Simple Inventory List in Excel

How to Create a Simple Inventory List in Excel

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

Streamlining your inventory management can significantly boost your business efficiency. One of the simplest and most effective ways to achieve this is by creating a basic inventory list using Microsoft Excel. This article will guide you through the process, making it easy for you to maintain and update your inventory records.

My simple and easy method for tracking product inventory using Excel spreadsheets
My simple and easy method for tracking product inventory using Excel spreadsheets

Before we dive into the step-by-step process, let's ensure you have the right version of Excel. This guide is compatible with Excel 2010 and later versions, including Excel Online. If you're using an older version, you might need to upgrade to access all the features mentioned here.

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

Setting Up Your Inventory List

To begin, open a new or existing Excel workbook and click on the sheet where you want to create your inventory list. For better organization, consider renaming the sheet to "Inventory".

FREE Printable Inventory List Templates
FREE Printable Inventory List Templates

Next, decide on the columns you want to include. For a simple inventory list, you might need columns for Item Name, Quantity, Unit Price, and Total Price. You can add more columns based on your specific needs, such as Supplier, Category, or Reorder Point.

Defining Your Columns

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

In the first row (Row 1), enter the header names for your columns. For example, in cells A1 to D1, you could enter "Item Name", "Quantity", "Unit Price", and "Total Price" respectively. Use the fill handle (small square in the bottom-right corner of the cell) to drag these headers across to fill the entire row.

To make your inventory list more user-friendly, consider applying some basic formatting. You can merge and center the headers, change the font size and style, or add a background color to make the headers stand out. To do this, select the header row, click on the "Home" tab, and use the formatting options in the "Styles" and "Font" groups.

Formatting Your Inventory List

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

Now that your headers are in place, it's time to format your list for better readability. Select the entire data range (including headers) by clicking and dragging from the top-left cell (A1) to the bottom-right cell. Then, click on the "Home" tab and use the "Borders", "Fill", and "Alignment" options to apply consistent formatting throughout your list.

For instance, you can add a border around the entire data range, fill the header row with a light color, and center the text within each cell. You can also adjust the column widths by hovering over the line between two column headers until the cursor changes to a double-headed arrow, then click and drag to resize the column.

Entering and Calculating Inventory Data

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

With your inventory list set up, it's time to start entering your data. Begin by entering item names in the first column (Column A). To keep your list organized, consider sorting the items alphabetically. To do this, select any cell within the data range, click on the "Data" tab, and click on "Sort A to Z" or "Sort Z to A" in the "Sort & Filter" group.

Next, enter the quantity, unit price, and any other relevant data for each item. To calculate the total price for each item, use the formula "=Quantity * Unit Price". For example, if you enter "5" in cell B2 (Quantity) and "10" in cell C2 (Unit Price), enter the formula "=B2*C2" in cell D2 (Total Price). The cell will display the result "50".

Simple Inventory Checklist
Simple Inventory Checklist
Budgetplaner Vorlage Excel – Effektiv Kosten Steuern & Sparen | Gratis Download
Budgetplaner Vorlage Excel – Effektiv Kosten Steuern & Sparen | Gratis Download
36+ Printable Inventory List Templates | ExcelSHE » ExcelSHE
36+ Printable Inventory List Templates | ExcelSHE » ExcelSHE
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
How to Create an Inventory List in Excel (with Pictures)
How to Create an Inventory List in Excel (with Pictures)
Inventory Tracker Excel | Stock Management Spreadsheet | Small Business Template
Inventory Tracker Excel | Stock Management Spreadsheet | Small Business Template
Organized | Inventory Planner | Google sheet
Organized | Inventory Planner | Google sheet
Free Household Inventory List Template In Google Sheets
Free Household Inventory List Template In Google Sheets
Inventory Tracker Checklist for Excel
Inventory Tracker Checklist for Excel
Free Inventory and Sales Spreadsheet
Free Inventory and Sales Spreadsheet
Inventory Management System in Excel using VBA - Don't buy it but make it.
Inventory Management System in Excel using VBA - Don't buy it but make it.
Efficient Inventory Tracker for Businesses & Resellers | Google Sheets & Excel Templates
Efficient Inventory Tracker for Businesses & Resellers | Google Sheets & Excel Templates
Printable Simple Minimalist Table Style Inventory Sheet
Printable Simple Minimalist Table Style Inventory Sheet
Farm Equipment Inventory List | Templates at allbusinesstemplates.com
Farm Equipment Inventory List | Templates at allbusinesstemplates.com
Inventory Management Template for Store
Inventory Management Template for Store
the inventory log is shown in black and white
the inventory log is shown in black and white
Free Homeschool Planner Printable (40 Pages)
Free Homeschool Planner Printable (40 Pages)
Inventory Tracker Google Sheets Template & Excel Spreadsheet
Inventory Tracker Google Sheets Template & Excel Spreadsheet
a printable inventory list sheet
a printable inventory list sheet
Google Sheets Inventory Templates Boost Efficiency in 2025, Wardrobe Inventory Spreadsheet
Google Sheets Inventory Templates Boost Efficiency in 2025, Wardrobe Inventory Spreadsheet

Using AutoFilter for Easy Navigation

As your inventory list grows, it can become challenging to find specific items. To make navigation easier, enable AutoFilter. Click on any cell within the data range, then click on the "Data" tab. In the "Sort & Filter" group, click on "Filter" to display dropdown arrows in the header row.

Now, you can filter your inventory list by any column. For example, to find all items with a total price greater than $100, click on the dropdown arrow in the "Total Price" header, then click on "Number Filters" and select "Greater Than". Enter "100" in the "Custom AutoFilter" dialog box and click "OK". Your list will now display only the items with a total price greater than $100.

Updating Your Inventory List

To keep your inventory list up-to-date, regularly update the quantity and other relevant data. When you add new items, simply enter the data in the appropriate columns. When you remove items, you can either delete the entire row or use the "Remove Duplicates" feature to remove all instances of the item from your list.

To use "Remove Duplicates", select any cell within the data range, then click on the "Data" tab. In the "Data Tools" group, click on "Remove Duplicates". In the "Remove Duplicates" dialog box, ensure that the correct columns are selected, then click "OK". Excel will remove all duplicate items from your list, leaving only the unique items.

With your inventory list set up and regularly updated, you'll have a clear overview of your stock levels, making it easier to manage your inventory and make informed decisions. By following this guide, you've created a simple yet powerful tool to streamline your inventory management process. As your business grows, you can further customize your inventory list to meet your evolving needs.