Best Etsy Inventory Spreadsheets — Free Templates for Sellers
Comparing the best free Etsy inventory spreadsheets for handmade sellers — what each tracks, where each falls short, and a free download to get you started today.
You know that feeling when an order comes in and you’re not sure if you actually have the materials to make it?
That moment of panic (checking your shelf, counting jars, doing mental math) is exactly what a good Etsy inventory spreadsheet is supposed to eliminate. But not all spreadsheets are built the same, and picking the wrong one means you’ll either outgrow it in three months or spend every Sunday manually updating cells.
This guide covers the best free options for tracking your Etsy shop inventory, what each one does well, and where each starts to crack under pressure.
What a Good Etsy Inventory Spreadsheet Actually Needs
Before comparing templates, it’s worth knowing what to look for. A lot of free spreadsheets cover the basics (product name, quantity, price) but miss the columns that actually matter once you’re selling regularly.
Here’s what separates a useful template from one you’ll abandon:
- Material tracking: not just finished products, but the raw ingredients that go into each item. A candle spreadsheet should track wax, fragrance, and wicks, not just “vanilla soy candle.”
- Cost per unit: the actual cost to produce each item, including materials and time. Without this, your pricing is guesswork.
- Reorder thresholds: a flag that tells you when you’re running low before you’re completely out.
- Order integration: some way to update stock levels when a sale happens, even if it’s manual.
- COGS calculation: especially important at tax time. You need to know what your products cost, not just what they sold for.
Most free spreadsheets handle two or three of these. Few handle all five. That’s not a dealbreaker. Just know what you’re signing up for before you commit.
The Best Free Etsy Inventory Spreadsheet Templates
1. Craftybase’s Free Etsy Inventory Spreadsheet
If you want one template built specifically for Etsy handmade sellers, this is it. The Craftybase free Etsy inventory spreadsheet covers product stock, raw material quantities, and cost tracking in a format that’s ready to use in Excel or Numbers without any setup.
It’s designed around the job most makers actually have: “I need to know what I have, what it costs me, and when I’m running low.” Columns for unit cost and reorder levels are already built in. You’re not adding them yourself.
Download:Free Etsy Inventory Spreadsheet
What makes it practical for Etsy sellers specifically:
- Separate tabs for materials and finished products (so you track both, not just one)
- Built-in cost-per-unit calculation
- Reorder point column to flag low stock before it becomes a crisis
- Works in both Excel and Numbers (no Google account required)
Where it falls short: Like any spreadsheet, it’s still manual. When a sale happens on Etsy, you update the spreadsheet yourself. It doesn’t sync with your shop. And if you’re making multi-ingredient products, tracking the material deductions per sale gets tedious fast.
2. A Simple DIY Google Sheets Template
If you want complete control and your needs are straightforward (a small product range, no complex recipes), a basic Google Sheets setup can work. The advantage is that it’s shareable and free, and you can customise it however you like.
A minimal Etsy inventory sheet in Google Sheets typically has:
- Product name, SKU, price
- Starting stock, units sold, current stock
- A simple formula for remaining inventory
For sellers with fewer than 20 product lines and no complex material tracking needs, this is actually fine. Keeping things simple is a genuine virtue, not a shortcut.
The catch: Google Sheets is a blank canvas. You have to build every formula yourself, and there’s no standardised structure. When something breaks (and something always breaks), you’re debugging it alone.
3. Niche Inventory Spreadsheet Templates by Product Type
If you sell a specific category of handmade goods, a niche-specific template will save you time building custom columns.
Craftybase offers free downloadable spreadsheets for the most common Etsy verticals:
- Candle Inventory Spreadsheet: tracks wax, fragrance oil, wicks, and containers alongside finished product stock
- Soap Making Inventory Spreadsheet: includes lye, oils, and fragrance tracking with batch size fields
- Jewelry Inventory Spreadsheet: covers components (beads, wire, clasps) with per-item cost calculations
These are more useful than a generic template if your materials have specific units or batch calculations involved. A candle maker tracking fragrance oil by the ounce doesn’t want to adapt a generic “materials” column. A candle-specific sheet has those fields already named correctly.
If your business tracks raw materials across multiple products, the material tracking spreadsheet is also worth a look. It’s built for ingredient-level visibility rather than finished product stock.
4. Pricing and Fee Calculators (Separate but Related)
Inventory tracking and pricing are different problems, but they overlap. If you don’t know your material costs, you can’t set prices properly. And if your prices are wrong, accurate inventory data doesn’t help much.
Two free tools worth pairing with your inventory spreadsheet:
- Etsy Pricing Calculator Spreadsheet: calculates your selling price based on materials, labor, and overhead, including Etsy fees
- Etsy Fee Calculator Spreadsheet: breaks down exactly what Etsy takes from each sale so you’re not guessing your net margin
Neither replaces an inventory spreadsheet, but both fill gaps that pure stock-tracking templates leave open. If you want a deeper look at how Etsy bookkeeping fits into this picture, the Etsy bookkeeping guide covers how to connect your inventory records to your income and expense tracking for tax time.
5. Paper & Spark Excel Templates
Paper & Spark is a well-known name in the Etsy bookkeeping space. Their paid Excel templates are thorough, with separate worksheets for income, expenses, inventory, and COGS, and they come with setup instructions.
The upside: they’re trusted by a lot of sellers and cover the bookkeeping side thoroughly.
The downside: they’re not free, and they’re oriented toward bookkeeping rather than operational inventory tracking. If you want a tool to help you know when to reorder materials or how much stock you have right now, the Paper & Spark templates are a bit heavy for that use case.
For a comparison of how Paper & Spark stacks up against a dedicated inventory approach, we’ve put one together here.
How to Choose the Right Template
It comes down to two questions:
How many products and materials do you have?
| Situation | Best fit |
|---|---|
| Under 20 SKUs, simple single-ingredient products | Basic Google Sheets or generic template |
| 20+ SKUs, or any recipes (candles, soap, resin) | Niche-specific template |
| Multi-ingredient products with batch calculations | Niche-specific + material tracking spreadsheet |
| Selling on 2+ channels (Etsy + Shopify, craft fairs) | Consider inventory software (see below) |
How important is cost tracking?
If you need to know your COGS for tax purposes (and you should, since it directly affects your Schedule C), pick a template with material costs built in from the start. Adding a cost column later, after you’ve already been tracking stock without it, is more work than it’s worth. For a full breakdown of how Etsy COGS actually works (including what Etsy’s dashboard misses), see the Etsy COGS tracking guide.
A note on multi-channel sellers
If you sell on Etsy and Shopify, or Etsy plus craft fairs, a spreadsheet starts showing its limitations pretty quickly. Every channel needs updating separately, and keeping stock numbers in sync manually is exactly the kind of thing that leads to overselling. At that point, you’re not looking for a better spreadsheet. You’re looking for a system that handles all channels in one place.
When Spreadsheets Stop Working
Spreadsheets have a ceiling. Most Etsy sellers hit it eventually, not because the spreadsheet breaks, but because the manual effort becomes too much.
Common signs you’re there:
- Updating inventory after every sale takes 10–15 minutes
- You’ve made a pricing error because your cost data was out of date
- Tax time involves reconstructing your COGS from memory or old invoices
- You sell on multiple channels (Etsy + Shopify, or Etsy + craft fairs) and tracking across both is a mess
When that happens, the answer isn’t a better spreadsheet. It’s a system that does the updating for you. Craftybase connects directly with Etsy to pull in orders automatically and deduct materials from stock as each sale happens. No manual entry required.
There’s a free 14-day trial if you want to see how much time that actually buys back.
Frequently Asked Questions
What should an Etsy inventory spreadsheet track?
At minimum, an Etsy inventory spreadsheet should track your finished product stock (how many units you have ready to ship), your raw materials (what goes into each product), and your cost per unit (so you know your true cost of goods). Reorder thresholds (a flag that triggers when stock drops below a set level) are also valuable. Many free templates skip material tracking and cost data, which creates gaps at tax time.
Is there a free Etsy inventory spreadsheet I can download?
Yes — Craftybase offers a free Etsy inventory spreadsheet available in both Excel and Numbers formats. It includes separate tabs for materials and finished products, cost-per-unit calculations, and reorder point tracking. Download it at craftybase.com/etsy-inventory-spreadsheet. There are also niche-specific versions for candle makers, soap makers, and jewelry sellers if you need columns tailored to your materials.
How do I track inventory for Etsy if I make multi-ingredient products?
For multi-ingredient products — candles, soaps, baked goods, resin items — you need a spreadsheet with a recipe or bill-of-materials structure: each product lists every ingredient and the quantity used per batch. When a sale happens, you deduct from your material stock, not just your finished product count. This is hard to do accurately in a generic spreadsheet. A niche-specific template (like the candle inventory spreadsheet or soap inventory spreadsheet) has these columns pre-built. For higher volume, dedicated inventory software like Craftybase automates those deductions automatically.
Can I use an Etsy inventory spreadsheet for COGS at tax time?
You can, but only if your spreadsheet has tracked material costs accurately throughout the year. COGS (Cost of Goods Sold) for Schedule C requires your beginning inventory value, the cost of materials purchased, and ending inventory value. A spreadsheet that only tracks quantities — not costs — won't give you those numbers without reconstruction. If you're selling on Etsy as a business, set up your cost tracking from day one. Craftybase calculates COGS automatically from your material costs and sales history, which makes year-end reporting straightforward.
What's the difference between an Etsy inventory spreadsheet and Etsy's built-in inventory?
Etsy's built-in inventory tracking only manages listing quantities. It shows buyers how many you have in stock and reduces that number when an item sells. It doesn't track your raw materials, production costs, or profitability. A separate inventory spreadsheet (or inventory software) handles the business side: what you have on your shelf, what it cost you to make, and when to reorder. The two systems cover different needs, and most serious Etsy sellers use both.
Do I need a different spreadsheet if I sell on Etsy and Shopify?
A spreadsheet gets quite difficult to manage across multiple channels because every sale on every platform requires a manual update. You'll quickly find yourself with stock numbers that don't match reality. The practical answer for multi-channel sellers is dedicated inventory software — tools like Craftybase connect to both Etsy and Shopify and keep your stock levels in sync automatically. A spreadsheet works well for a single channel at low volume; once you're selling on two or more platforms, the manual maintenance cost usually outweighs the "free" benefit.
If you’re just getting started, the free Etsy inventory spreadsheet is the fastest way to get your stock tracking in order. No setup required, works in Excel or Numbers, and covers materials alongside finished products.
Once you’re selling enough that keeping it updated starts eating into your making time, that’s a good sign to look at something that runs automatically. Craftybase’s Etsy integration syncs your orders and handles the stock math for you, so you spend less time on the spreadsheet and more time on the work you actually enjoy.
