A simple, ready-to-use spreadsheet for tracking your inventory. Works with Excel, Google Sheets, or any CSV-compatible tool. Import directly into StockZip when you are ready to upgrade.
Choose your preferred format. Both include the same columns and sample data.
The template includes these columns. Add, remove, or customize as needed for your business.
| Column | Description | Example |
|---|---|---|
| Item Name | The name or description of the item | Widget A |
| SKU | Unique identifier for the item | WGT-001 |
| Barcode | UPC, EAN, or custom barcode number | 012345678901 |
| Category | Product category or type | Electronics |
| Location | Where the item is stored | Warehouse A, Shelf 3 |
| Quantity | Current stock count | 150 |
| Unit | Unit of measure | Each |
| Cost | Cost per unit | $5.00 |
| Price | Selling price per unit | $12.99 |
| Reorder Point | Quantity that triggers reorder | 25 |
| Supplier | Vendor or manufacturer | Acme Corp |
| Notes | Additional information | Fragile, handle with care |
Download the CSV or Excel file. Open it in Excel, Google Sheets, or any spreadsheet app.
Delete columns you do not need. Add columns for custom fields specific to your business.
Replace the sample data with your actual items. Add one row per item or SKU.
Update quantities as you receive, sell, or move inventory. Set a schedule for regular updates.
Spreadsheets are a good starting point, but they have limitations that become painful as you grow:
Import this spreadsheet directly into StockZip and get barcode scanning, low-stock alerts, and real-time tracking. Keep your data, lose the manual work.