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

Inventory spreadsheet template columns
ColumnNeeded?What to put there
NameRequiredWhat you call the item. Be specific: “Printer paper A4, 500 sheets” beats “Paper”.
SKUOptional, uniqueYour own short code. Handy on labels and when a product has no barcode.
BarcodeOptional, uniqueThe EAN/UPC on the packaging, or any code you print yourself.
QuantityOptionalHow many you have now. Becomes an opening-balance movement when imported.
LocationNeeded if Quantity is setWhere the stock is. Use “Back room > Shelf A” for a shelf inside a room; new locations are created for you.
Min levelOptionalAlert when stock falls to this number or below.
CostOptionalWhat one unit costs you, like 4.20 (no currency sign needed).
PriceOptionalWhat you sell one unit for.
TagsOptionalGroups such as office; paper — separate several with semicolons.

Example rows

The three example rows in the template (delete them before importing)
NameSKUBarcodeQuantityLocationMin levelCostPriceTags
Blue ballpoint pens (box of 12)PEN-BLU-12200000000001524Back room > Shelf A104.207.99office
Printer paper A4, 500 sheetsPAP-A4-50020000000000226Back room > Shelf B105.108.50office; paper
Compression elbow 15 mmCMP-ELB-1512Van 1201.352.95plumbing; fittings

Tips for a spreadsheet that stays useful

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

  1. Save your sheet as CSV (File → Download → CSV in Google Sheets; Save As → CSV UTF-8 in Excel).
  2. In StockKit, open Import, choose the file and check the column matches — StockKit guesses them from your headings.
  3. Run the dry run. It lists any problems by line (duplicate SKUs, text in number columns) before anything is created.
  4. 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