Inventory spreadsheet template
A plain inventory spreadsheet with the nine columns small businesses actually use. Open it in Excel, Google Sheets or Numbers, fill it in, and it imports straight into StockKit when you're ready to scan.
Download the template (CSV)Import it into StockKit
The columns
| Column | Needed? | What to put there |
|---|---|---|
| Name | Required | What you call the item. Be specific: “Printer paper A4, 500 sheets” beats “Paper”. |
| SKU | Optional, unique | Your own short code. Handy on labels and when a product has no barcode. |
| Barcode | Optional, unique | The EAN/UPC on the packaging, or any code you print yourself. |
| Quantity | Optional | How many you have now. Becomes an opening-balance movement when imported. |
| Location | Needed if Quantity is set | Where the stock is. Use “Back room > Shelf A” for a shelf inside a room; new locations are created for you. |
| Min level | Optional | Alert when stock falls to this number or below. |
| Cost | Optional | What one unit costs you, like 4.20 (no currency sign needed). |
| Price | Optional | What you sell one unit for. |
| Tags | Optional | Groups such as office; paper — separate several with semicolons. |
Example rows
| Name | SKU | Barcode | Quantity | Location | Min level | Cost | Price | Tags |
|---|---|---|---|---|---|---|---|---|
| Blue ballpoint pens (box of 12) | PEN-BLU-12 | 2000000000015 | 24 | Back room > Shelf A | 10 | 4.20 | 7.99 | office |
| Printer paper A4, 500 sheets | PAP-A4-500 | 2000000000022 | 6 | Back room > Shelf B | 10 | 5.10 | 8.50 | office; paper |
| Compression elbow 15 mm | CMP-ELB-15 | 12 | Van 1 | 20 | 1.35 | 2.95 | plumbing; fittings |
Tips for a spreadsheet that stays useful
- One row per thing you count separately. If you count pens by the box, the item is “Blue pens (box of 12)” and the quantity is boxes.
- One location per row. If an item sits in two places, use two rows during setup — or import one location and move the rest in StockKit.
- Keep codes as text. Spreadsheets love turning 0012345678905 into 1.23E+10. Format the Barcode column as text before pasting codes.
- Don't store totals. Formulas and summary rows break imports. Keep the sheet as a plain list.
- Set min levels for the things that hurt to run out of. You don't need one on every row on day one.
Why move from a spreadsheet at all?
A spreadsheet holds a snapshot: it's right on the day you count and drifts every day after. StockKit records every change as a movement — who took what, when and why — so the quantity stays current, you can see where a difference came from, and low stock shows up on the Alerts tab instead of when the shelf is empty. The import keeps your spreadsheet's numbers as opening balances, so nothing is lost.
How to import
- Save your sheet as CSV (File → Download → CSV in Google Sheets; Save As → CSV UTF-8 in Excel).
- In StockKit, open Import, choose the file and check the column matches — StockKit guesses them from your headings.
- Run the dry run. It lists any problems by line (duplicate SKUs, text in number columns) before anything is created.
- Import. Up to 10,000 rows per file.
Ready to import?
Create a free workspace, then choose Import. Your quantities become opening balances.
Create a free workspace