Free Inventory Spreadsheet Template

What Is an Inventory Spreadsheet?

An inventory spreadsheet is a structured document that tracks every product in your business — recording SKU codes, quantities on hand, cost prices, selling prices, storage locations, and reorder levels. It gives you a single view of what you have, what it's worth, and what needs restocking.

For ecommerce sellers managing products across Shopee, Lazada, TikTok Shop, and Shopify, an inventory spreadsheet is often the first step toward getting stock under control before adopting dedicated inventory management software.

Why Ecommerce Sellers Need an Inventory Spreadsheet

Most sellers start by tracking inventory in their heads or relying on each platform's built-in stock count. That works with 10 products — but breaks down fast:

• Overselling risk — without a central count, you sell the same item on Shopee and Lazada simultaneously. One customer gets a cancellation, and your seller rating drops.
• Stockout blind spots — you don't notice a product is running low until orders start failing. A reorder point column flags items before they hit zero.
• Unknown inventory value — how much capital is tied up in stock? Cost price × quantity gives you the answer instantly.
• Reordering guesswork — without historical data, you're guessing how much to reorder. A spreadsheet creates the data trail that informs smarter decisions.
• Accounting nightmares — your bookkeeper needs a cost of goods sold figure. Without cost prices in a spreadsheet, you're reconstructing numbers at tax time.

The template above includes all the columns an ecommerce seller needs — with presets that pre-fill sample data for different business types.

Essential Columns for an Inventory Spreadsheet

Inventory Spreadsheet vs Inventory Management Software

A spreadsheet is a great starting point, but it has limits. Here's when each approach works best:

If you're outgrowing your spreadsheet — orders coming in faster than you can update quantities, or you've had overselling incidents — it's time to consider multichannel inventory management software that automates what this spreadsheet does manually.

How to Use This Inventory Spreadsheet Template

1. Pick a preset — choose the template closest to your business type. Each preset loads sample products with relevant columns and categories.
2. Replace sample data — click any cell to edit. Replace the example products with your actual inventory.
3. Set reorder points — for each product, enter the minimum quantity at which you should reorder. Items below this threshold appear in red.
4. Review the summary — the metrics bar shows total SKUs, units, inventory value at cost and retail, and how many items are below reorder point.
5. Download as CSV — export your inventory to open in Excel, Google Sheets, or import into inventory management software.

Tips for Maintaining Your Inventory Spreadsheet

• Update daily — set a routine. End-of-day stock counts keep your spreadsheet accurate and prevent overselling.
• Use consistent SKU formats — follow a pattern like CATEGORY-COLOUR-SIZE (e.g. TSHIRT-BLK-L). Our free SKU generator can create standardised codes for you.
• Track cost price changes — supplier prices change. Update cost prices when you receive new purchase orders to keep your margins accurate.
• Review low stock weekly — don't wait for items to hit zero. Use the reorder point alerts to place orders before you run out.
• Keep one source of truth — if multiple people update inventory, use a shared Google Sheet. Or better yet, upgrade to inventory management software that syncs automatically.

Frequently Asked Questions

Is there a free inventory template I can download?

Yes — the template above is completely free. Add your products directly in the browser and download the completed spreadsheet as a CSV file. You can open the CSV in Excel, Google Sheets, or any spreadsheet application. No signup or account required.

What columns should an inventory spreadsheet have?

At minimum: SKU, product name, quantity on hand, cost price, and selling price. For ecommerce sellers, you should also include category, storage location (or sales channel), reorder point, and supplier name. The template above includes all of these columns with presets tailored to different business types.

How often should I update my inventory spreadsheet?

Daily is ideal — especially if you sell on multiple channels. Every sale reduces your stock, and delays in updating can lead to overselling. If daily updates feel unmanageable, that's a sign you've outgrown spreadsheets and should consider automated inventory management software that syncs in real time.

Can I use this template for multichannel selling?

You can use the "Multi-Channel Seller" preset, which includes a platform/location column. However, spreadsheets can't automatically sync stock across platforms — if you sell one unit on Shopee, you need to manually reduce the count for Lazada too. For automated multichannel sync, tools like OneCart handle this in real time across Shopee, Lazada, TikTok Shop, Amazon, Shopify, and more.