How to Create an Inventory List in Excel

This wikiHow teaches you how to manage a work inventory using an Excel spreadsheet on your Windows or Mac computer. You can use a pre-formatted inventory list template, or create your own sheet.

Table of Contents

Use templates

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c4/Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c4/Create-an- Inventory-List-in-Excel-Step-1-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Open Microsoft Excel. Dark green app with a white “X” inside.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/78/Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/78/Create-an- Inventory-List-in-Excel-Step-2-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the search bar at the top of the Excel window.

On a Mac, click File in the upper-left corner first, then click New from Template… in the drop-down menu.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9e/Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9e/Create-an- Inventory-List-in-Excel-Step-3-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Find the inventory list template. Type inventory list in the search bar at the top of the page and then press ↵ Enter . A list of samples used for product inventory will appear.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2f/Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2f/Create-an- Inventory-List-in-Excel-Step-4-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Sampling. Click on the inventory list template that best suits your needs. The template preview page opens.

Each inventory template offers different features. If you don’t like the template you just selected, you can press Esc to return to the template page.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1a/Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1a/Create-an- Inventory-List-in-Excel-Step-5-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Create on the right side of the template preview window.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/85/Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/85/Create-an- Inventory-List-in-Excel-Step-6-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Wait for the sample to be loaded. This process will take a few seconds. Once the template opens, you can continue.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ca/Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ca/Create-an- Inventory-List-in-Excel-Step-7-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter inventory information. To change a pre-filled cell, double-click the cell, delete the number or text in it, and then enter your data. While the template you choose may vary slightly, all inventory lists include the following options:

Item Number – The inventory number (SKU or inventory unit) of the item.
Item Name – The name that describes the item.
Item Cost – The price per unit of the item.
Number in Stock – Number of items in stock.
Net Value – The net value of the item.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e9/Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e9/Create-an- Inventory-List-in-Excel-Step-8-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Save the work. To save a document:

Windows – Click File , click Save As , double click This PC , click a save location on the left side of the window, enter a name for the document (such as “Inventory List”) in the box text “File name” and then click Save .
Mac – Click File , click Save As… , enter a name for the document (such as “Inventory List”) in the “Save As” field, choose a save location by clicking the “Where” box “, click the folder, and then click Save .

Create each part by yourself

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/61/Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/61/Create-an- Inventory-List-in-Excel-Step-9-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Open Microsoft Excel. Dark green app with a white “X” inside.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a4/Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a4/Create-an- Inventory-List-in-Excel-Step-10-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Blank workbook . This box is in the upper left of the window.

Skip this step if you’re on a Mac.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cd/Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cd/Create-an- Inventory-List-in-Excel-Step-11-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser-output”></div>”}

Create a title for your inventory list. Enter the corresponding title in the following boxes:

A1 – Item Number or Inventory Number
B1 – Item Name or Item Name
C1 – Item Cost or Item Price
D1 – Number of Items or Number of Items
E1 – Net Value or Net Value

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2e/Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2e/Create-an- Inventory-List-in-Excel-Step-12-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Adjust column widths. Click the space between the two letters of the column name (for example, A and B ) at the top of the worksheet, then drag your mouse to the right to expand the column.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/99/Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/99/Create-an- Inventory-List-in-Excel-Step-13-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter the item’s inventory number. Click in cell A2 , then enter the item code (such as 123456 ) and press ↵ Enter .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2a/Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2a/Create-an- Inventory-List-in-Excel-Step-14-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Add item name. Click cell B2 , then enter the item’s official name (ex: Drawstring ).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/58/Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/58/Create-an- Inventory-List-in-Excel-Step-15-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Determine the unit price of the item. Click cell C2 , then enter the individual item’s cost (such as 50,000 ).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/97/Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/97/Create-an- Inventory-List-in-Excel-Step-16-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Add the total number of existing items. Click cell D2 and enter the number of items you have in stock (for example, if you currently have 80 drawstring sets, enter 80 ).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/26/Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/26/Create-an- Inventory-List-in-Excel-Step-17-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter the formula for calculating net worth. Click in cell E2 , then type =C2*D2 in the cell and then press ↵ Enter . You will see the net value calculated and shown in the box.

You can repeat this general formula with each cell in the “Net Value” column—just remember to replace C2 and D2 with the appropriate cell (for example, if you’re multiplying the values of cells C10 and D10 , you’ll need to use name these cells instead of C2 and D2 ).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Create-an- Inventory-List-in-Excel-Step-18-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Add the remaining items to the inventory list. Repeat the above process for each item to be inventoryed. You need to assign each item to each line until the list is complete.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c7/Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c7/Create-an- Inventory-List-in-Excel-Step-19-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Save the work. To save a document:

On Windows – Click File , click Save As , double-click This PC , click a save location on the left side of the window, enter a name for the document (such as “Inventory List”) in the “File” text box name” and then click Save .
Mac – Click File , click Save As… , enter a name for the document (such as “Inventory List”) in the “Save As” field, choose a save location by clicking the “Where” box “, click the folder, and then click Save .

Advice

You can add more worksheets to the worksheet set by clicking the ＋ sign in the lower left of the page.

Steps

Use templates

Create each part by yourself

Advice

Related Posts