Inventory spreadsheet template: pick the columns, download the file.
Choose the columns you need, see the sheet, and download it as a CSV that opens in Excel, Google Sheets and Numbers. The headers are the ones the InventoryQuick CSV import reads, so you can bring your items in later. It runs in your browser: nothing is uploaded.
Nothing is uploaded. The template is made in this browser tab, and it keeps nothing when you close it. The file opens in Excel, Google Sheets and Numbers.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | |||||||||
| 7 |
Rows 2 and 3 are one item kept in two places: the same SKU and name on both, with a different location and quantity on each. The import makes them one item with 42 at Rack A and 12 at Rack B.
What goes in each column
- SKU: your code for the item, the same on each row of one item. SKUs are matched exactly, so capital letters count: PLY-B34 and ply-b34 are two different SKUs.
- Name: what the item is called. Name is required on each row; a row with no name is refused, and the import says which row.
- Category: a group such as Hardware or Sheet goods. You don't need to set categories up first: a category you don't have yet is created.
- Location: where it is kept, such as Rack A or the hardware cage. A location you don't have yet is created while your plan has room for more; past that, the import leaves the item out and names it.
- Quantity: how many there are now, as a whole number such as 42 or 1200. A count cell the import cannot read as one whole number is not written, and the import names the row, the column and the value.
- Min Stock: your reorder point. The item shows as low once its total across locations is at or below it.
- Max Stock: the most you want to hold. It must not be below Min Stock, or the row is refused.
- Cost and Price: what you pay your supplier for one, and what you charge for one.
- Supplier: who you buy it from. A supplier you don't have yet is added by name while your plan has room for more; past that, the item comes in without it and the import names the supplier.
- Barcode: the number printed under the item's barcode. Format the column as Text so the spreadsheet keeps the digits.
- Description and Notes: any text you want kept on the item.
How to fill it in
- Keep row 1 as it is. It is the header row, and the headers are what tell the import which column is which.
- Format SKU and Barcode as Text first, before you type or paste, so leading zeros and long numbers survive.
- One row for each item, or one row for each location when an item is kept in more than one place, with the same SKU and name on each of its rows.
- Give each of those rows a location. On an item that is on other shelves, a row with no location has its quantity left out, and the import says so.
- Type the item's details the same on each of its rows. If the rows disagree on something like the cost, the first value in the file is kept, and the import says how many items that happened to.
- Delete the example rows before you type your own items, and save the sheet as a CSV or an Excel .xlsx file.
Bring it into InventoryQuick
On the web, open Import Items and choose the file. Because the headers are the import's own field names, each column is already matched to its field, and you can change a match before the import runs. Skip duplicates is the default, which leaves the items you already have unchanged; choose Update to overwrite them with the values in the file instead.
When it finishes, the import tells you what it could not do and why: a row it refused, a count it could not read, a location or supplier your plan had no room for, an item whose rows disagreed. CSV import is on every plan.
Moving off a spreadsheet? Read how to switch from a spreadsheet to inventory software, the signs you've outgrown your inventory spreadsheet, and what a spreadsheet really costs.
When the spreadsheet stops keeping up
- Low stock: put a minimum stock on an item and it shows as low once its total across locations is at or below it.
- Labels and scanning: print barcode labels for many items at once and scan an item with the iPhone or Android app to open it. Scanning is on every plan.
Flat monthly plans from $19/mo, with no per-user fees. Every plan starts with a 7-day free trial, and you won't be charged for 7 days. On the web you pick a plan and enter a card.
Frequently asked questions
Is the inventory spreadsheet template free?
Yes. There is no sign-up and no email is asked for. The template is made in your browser, and the columns you pick are not sent to InventoryQuick or stored.
What columns should an inventory spreadsheet have?
A name for each item, a SKU, where it is kept and how many there are. Most shops add a category, a minimum stock level to reorder at, the cost, the price and the supplier. Max stock, barcode, description and notes are there to turn on if you need them.
How do I list one item that is kept in more than one place?
Give it one row for each location, with the same SKU and name on each row and the quantity at that location. Rows 2 and 3 of the example show it. When you import the file into InventoryQuick, rows that share a SKU become one item with stock at each location.
Do I have to fill in each column?
No. Name is required on each row, and the rest can be left blank. A blank quantity on a new item is 0. A row with no SKU is matched by name to an item you already have, or is given a placeholder code if it matches none.
Why does Excel turn my barcodes into 1.2E+11 or drop the leading zeros?
Excel treats a long run of digits as a number: it can show it as 1.2E+11, which is what a CSV then saves, and it drops zeros at the start. Format the SKU and Barcode columns as Text before you type or paste into them. The InventoryQuick import does not load a barcode in scientific notation, because the real digits are gone, and it tells you how many items that happened to.
Can I bring the spreadsheet into InventoryQuick?
Yes. The headers are the names the CSV import reads, so each column is matched to its field when you open Import Items on the web and choose the file, as a CSV or an Excel .xlsx file. You can change a match before the import runs. Skip duplicates is the default, which leaves the items you already have unchanged. CSV import is on every plan.
More free tools: SKU generator, inventory count sheet, item label maker, reorder point calculator.