Free Inventory Spreadsheet Template
Excel, Google Sheets & CSV download
Download a free inventory spreadsheet template for general stock, retail, warehouse, or pharmacy. Preview the columns, select your template type, and download instantly — no account needed.
| SKU | Product Name | Category | Unit | Opening Stock | Received | Issued | Closing Stock | Unit Cost (₹) | Total Value (₹) | Reorder Level | Location | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SKU-001 | Widget A | Electronics | Pcs | 100 | 50 | 30 | 120 | 250.00 | 30000.00 | 20 | Rack A1 | — |
| SKU-002 | Widget B | Electronics | Pcs | 80 | 0 | 25 | 55 | 400.00 | 22000.00 | 15 | Rack A2 | — |
| SKU-003 | Packaging Box | Supplies | Pcs | 500 | 200 | 150 | 550 | 12.00 | 6600.00 | 100 | Shelf B3 | — |
Opens in Excel, Google Sheets, LibreOffice Calc, and any CSV-compatible tool. Includes sample data rows you can delete before use.
What Is an Inventory Spreadsheet Template?
An inventory spreadsheet template is a pre-formatted table with the right column headers for tracking stock — so you don't have to build one from scratch. Instead of opening a blank spreadsheet and figuring out what columns to include, you download a template designed for your business type, delete the sample data, and start entering your own products immediately. Our templates cover four common business types: general inventory, retail shops, warehouses, and pharmacies — each with the specific fields those businesses need.
How to Use the Inventory Spreadsheet Template
Step 1 — Choose Your Template Type
Select General Inventory for an all-purpose stock register, Retail Shop for MRP and margin tracking, Warehouse for bin and pallet management, or Pharmacy for batch number and expiry date tracking.
Step 2 — Preview the Columns
Review the column headers and sample data in the preview table. Each template includes columns specific to that business type — the pharmacy template has batch numbers and schedule types; the warehouse template has zone and pallet location fields.
Step 3 — Download and Open in Excel or Google Sheets
Click 'Download Template'. The file downloads as a CSV which opens directly in Excel, Google Sheets, LibreOffice Calc, or any spreadsheet app. Delete the sample rows and start entering your own inventory data.
Who Uses These Inventory Templates?
Small Retail Shops
Track stock levels, cost prices, and MRPs for each product without investing in inventory software.
Warehouse & Storage Facilities
Record bin locations, pallet counts, received dates, and zone allocations for organised warehouse management.
Pharmacy & Medical Stores
Track medicine names, batch numbers, expiry dates, and schedule types to stay compliant and avoid expired stock.
Startups & New Businesses
Start tracking inventory on day one with a ready-made template while evaluating long-term inventory management solutions.
Frequently Asked Questions
What is an inventory spreadsheet?
An inventory spreadsheet (stock register) is a structured table that tracks what products you have, how many, where they are, what they cost, and when to reorder. It is used by businesses that are not yet ready for dedicated inventory management software.
How do I open a CSV file in Excel?
In Excel, go to File → Open, change the file type filter to 'Text Files (*.csv)', and select the downloaded file. Alternatively, right-click the file, choose 'Open with', and select Excel. The data will appear in columns automatically.
How do I import a CSV into Google Sheets?
In Google Sheets, go to File → Import → Upload, then select the downloaded CSV file. Choose 'Replace spreadsheet' or 'Insert new sheet', set separator type to 'Comma', and click Import.
Which template is right for my business?
General Inventory: any product-based business. Retail Shop: stores tracking MRP, selling price, and margin. Warehouse: businesses with multiple zones, bin locations, and pallet tracking. Pharmacy: medical stores needing batch numbers, expiry dates, and medicine schedules.
Can I customise the template?
Yes. Once downloaded, you can add, rename, or delete columns in Excel or Google Sheets to match your specific needs. The CSV format is universally editable.
Is this inventory template free?
Yes, completely free. No account, email, or payment required.