Free Download

Free Etsy Pricing Calculator Spreadsheet

Know Your True Profit on Every Etsy Sale

Download our FREE Etsy pricing calculator to factor in every cost — materials, labor, and all Etsy fees (transaction, payment processing, listing) — so you can set prices that actually make you money.

Trusted by 3,000+ makers
Free Etsy pricing calculator spreadsheet showing fee breakdown and profit margins
Excel Numbers Google Sheets

Join the Craftybase mailing list and we'll send you our Etsy pricing spreadsheet template for free! We typically send 2-4 emails a month about small batch production topics which we hope are useful to our readership.

    Stop guessing your prices and start charging what your products are actually worth

    If you're setting Etsy prices by checking what competitors charge and adding a bit on top, you're flying blind. Most Etsy sellers don't realize how much fees eat into their margins until they sit down and do the math — and by then, they've been underpricing for months.

    This free Etsy pricing calculator spreadsheet helps you factor in every cost that goes into a sale — materials, labor, overhead, packaging, and all Etsy fees. It shows you your true profit margin so you can set prices with confidence, not guesswork.

    • Material cost tracking for all ingredients and supplies
    • Labor cost per product (enter your cost per unit)
    • Full Etsy fee breakdown (transaction, processing, listing)
    • Customizable markup percentage (default 100%)
    • Suggested price calculated from your costs + markup
    • Profit and margin % calculated per product after all fees
    • Dashboard with total revenue, profit, and average margin
    • Side-by-side comparison for up to 50 products

    Perfect for Etsy sellers at any stage who want to move beyond gut-feel pricing and actually understand their margins before setting a price.

    Full Fee Breakdown

    See exactly what Etsy takes from every sale — transaction fee, payment processing, and listing fee — all calculated automatically from your suggested price.

    True Cost Per Product

    Combine materials, labor, and Etsy's cut into one clear number. Stop guessing — know exactly what each product costs before you set a price.

    Profit Margin Visibility

    See your actual margin on each product after all fees. Set your markup percentage and the spreadsheet calculates a suggested price — then shows the profit you'd actually keep. Compare margins across your product line at a glance.

    Ready to price your Etsy products with confidence?

    Download the free spreadsheet and see your true profit margin — after every fee — before you list a single product.

    Download the free spreadsheet ↑

    Excel, Numbers & Google Sheets compatible

    What's Inside the Etsy Pricing Calculator Spreadsheet

    This spreadsheet goes beyond a basic fee calculator. It helps you build a complete picture of every cost that goes into a sale — so you know your real margin, not just your revenue.

    If you haven't already downloaded the spreadsheet, enter your email address above. You'll receive a link to download the file. Open it in Excel, Numbers, or upload the Google Sheets version to your Google Drive.

    Important note: Some cells are calculated automatically and should not be edited manually. These are typically shaded or marked with a note in the spreadsheet.

    Complete Etsy Fee Breakdown

    The spreadsheet automatically calculates Etsy's transaction fee (6.5%), payment processing fee (3% + $0.25), and listing fee ($0.20). Enter your material and labor costs, set your markup, and it shows you exactly what Etsy takes from each sale — no more mental math mid-listing.

    Transaction Fee (6.5%)
    Etsy's cut of the suggested sale price. Applied to the price the spreadsheet calculates from your costs and markup.
    Payment Processing Fee (3% + $0.25)
    Etsy Payments fee applied to the sale price. Defaults to the US rate — you can adjust the percentage in the Settings tab if you're outside the US.
    Listing Fee ($0.20)
    Per-listing fee charged by Etsy when you publish or renew a listing. Factor this in when selling low-cost items — it can eat into margins fast.
    What's Not Included
    The spreadsheet doesn't account for offsite ads fees (12–15%), shipping costs, or overhead. For automatic tracking of all costs including these, see what Craftybase tracks.

    One of the most common Etsy pricing mistakes is forgetting to account for payment processing fees. This spreadsheet makes sure you've covered the core fees before you set a price.

    True Cost Per Product

    Add your material costs and labor. The calculator combines everything — ingredients, packaging, your time, Etsy's cut — into one clear cost-per-unit number. No more guessing whether you're actually making money on a sale.

    Material Costs
    The cost of all raw materials and supplies that go into making the product — ingredients, components, packaging, labels. Enter your total material cost per unit.
    Labor Cost
    Enter your labor cost per unit (e.g., 45 minutes at $20/hr = $15). The spreadsheet uses this alongside your material cost to calculate your total cost base. Learn how to calculate handmade labor costs.
    Markup Percentage
    Set a global markup (default 100%, meaning costs × 2) and the spreadsheet calculates a suggested sale price for every product. Adjust the markup to see how it affects your margins across your whole line.
    What About Overhead & Shipping?
    This spreadsheet focuses on direct costs (materials + labor) and Etsy fees. For overhead allocation and shipping cost tracking, you'll want dedicated cost tracking software. Learn how to factor in overheads.

    Profit Margin Visibility

    See your actual profit margin on each product — not what you think it is. The spreadsheet calculates your profit after materials, labor, and all Etsy fees, so you can spot underpriced products before you've sold 200 units at a margin you can't sustain.

    Profit Margin %
    After all costs and fees, this is your real margin on a sale. If this number is below 20-30%, you're likely underpricing — or your costs are higher than you realized.
    Profit Per Sale ($)
    Dollar amount you keep after costs and fees. Helpful for understanding which products are worth your time — sometimes the best sellers aren't the most profitable. See our guide on how to determine product pricing.
    Dashboard Totals
    The Dashboard tab shows total revenue, total profit, and average margin across all your products — giving you a bird's-eye view of your pricing health.
    Per-Product Breakdown
    See price, total fees, profit, and margin for every product in one table. Quickly identify which items are earning their place in your shop and which ones need a price review.

    Multi-Product Comparison

    Price multiple products side by side. See which items are your real money-makers and which ones are barely breaking even. This is useful for deciding what to promote, what to bundle, and what to retire from your shop.

    Up to 50 Products
    Add each product in your line. Use a consistent naming convention — it'll make the comparison easier to read as your product list grows.
    Side-by-Side Margin View
    Compare profit margins across products at a glance. Sort by margin to quickly identify which products are earning their place in your shop and which ones deserve a price review.

    For a deeper look at your product mix and what it's worth tracking, see our post on Etsy pricing hacks and the true cost of running an Etsy shop.

    What is a Free Etsy Pricing Calculator Spreadsheet?

    An Etsy pricing calculator spreadsheet is a structured tool that helps handmade sellers calculate the true cost of each product and determine what price to charge on Etsy to be profitable. Unlike a basic fee calculator, it factors in every cost category — materials, labor, overhead, shipping — alongside Etsy's full fee structure to show you your real margin before you set a listing price.

    Think of it as a business decision tool, not just a math tool. You're not just calculating what Etsy charges — you're understanding whether the price the market will bear is actually viable for your business. A $28 candle might look profitable until you add in the wax, fragrance, jar, wick, label, your time, the listing fee, the transaction fee, and the payment processing fee. Then you realize you've been netting $3.40 per sale.

    Our online Etsy fee calculator is great for a quick per-sale fee check. This downloadable spreadsheet goes deeper — it's designed to be your pricing workbook for your entire product line, helping you compare margins across products and set prices that are sustainable from day one.

    Why do Etsy sellers need a pricing calculator?

    The most common reason Etsy sellers struggle with profitability isn't that they're not selling — it's that they're pricing without knowing their true costs. Etsy makes it easy to list products and start getting sales. It doesn't tell you whether those sales are actually making you money.

    Most sellers underestimate costs in at least one of these categories:

    Labor.
    Many sellers don't pay themselves for their time at all, or use an unrealistically low rate. If you're spending 3 hours making a product and charging $0 for your time, that's not free — it's invisible.
    Overhead.
    Studio rent, utilities, subscriptions, tools, craft show fees — these business costs need to be recovered somewhere. If they're not allocated to products, they're silently eating your profits.
    All Etsy fees.
    Many sellers only count the transaction fee. They forget payment processing, listing renewal, and offsite ads — which can add another 5-6% to Etsy's total take on a sale.
    Shipping packaging.
    Tissue paper, mailers, boxes, tape, labels — these aren't free. If you offer free shipping, these costs still exist and need to be built into your product price.

    This spreadsheet helps you face the first two — materials and labor — alongside all three Etsy fee types. For overhead and shipping, you'll need to calculate those separately and fold them into your material cost entry (or upgrade to software that tracks everything automatically). Either way, a pricing calculator is one of the most important tools in any handmade pricing framework.

    Disadvantages of using a pricing spreadsheet

    A pricing spreadsheet is an excellent starting point, but it has real limitations as your business grows:

    Static costs.
    Material costs change — a supplier raises prices, you find a better deal in bulk, you switch to a different supplier. The spreadsheet doesn't know. You have to update it manually, and if you forget, your cost calculations drift from reality.
    No connection to actual purchases.
    The spreadsheet uses the costs you enter — not what you actually paid on your last order. If you're buying materials at fluctuating prices, your real landed cost is probably different from what's in the spreadsheet.
    Manual overhead allocation.
    Deciding how much overhead to allocate per product is judgment-based and hard to keep accurate as your product mix changes. It's easy for overhead to become a number you just make up rather than one grounded in actual costs.
    Doesn't track what actually happened.
    The spreadsheet helps you plan prices. It doesn't track your actual sales and COGS over time to tell you whether pricing decisions played out the way you expected. For that, you need a COGS tracking system.

    When your product line grows beyond 10-15 SKUs, or when you're buying materials frequently at different prices, a spreadsheet becomes a burden. That's when most Etsy sellers start looking at inventory and cost tracking software.

    When you're ready to move beyond spreadsheets

    When you outgrow the spreadsheet — because your product line grows, you start selling on multiple channels, or you just want costs calculated automatically from your Etsy orders — Craftybase picks up where the spreadsheet leaves off. It connects directly to Etsy, tracks materials as you use them, and calculates COGS in real time.

    Instead of manually entering costs into a spreadsheet, Craftybase reads your Etsy orders, knows what materials went into each product (based on your recipes), and calculates your true margin on every sale using your actual purchase prices — not estimates. When material costs change, your COGS updates automatically.

    Etsy sellers like those featured in our Etsy pricing guide often describe the moment they connected their shop to Craftybase as the first time they could see what was actually happening in their business — not just what they hoped was happening.

    Etsy Pricing Calculator Spreadsheet FAQ

    Who Should Use This Etsy Pricing Calculator?

    This free pricing calculator spreadsheet is built for Etsy sellers at any stage who want to understand their true margins before setting prices — or who suspect their current prices might not be covering all their costs.

    New Etsy sellers setting prices for the first time

    If you're just opening your shop and trying to figure out what to charge, this spreadsheet gives you a structured framework. You'll enter your real costs, see the fee math, and land on a price you can justify — not just one that feels about right.

    Sellers who suspect they're underpricing

    If you're making sales but not sure why profits feel thin, this spreadsheet often reveals the answer. Running the numbers usually uncovers at least one cost category that wasn't properly accounted for — and shows exactly how much the fix would change your margin.

    Sellers with multiple products who want to compare margins

    If you have 10-20 products in your shop, the multi-product comparison feature shows you which items are your real earners and which ones are barely breaking even. Useful for deciding what to promote and what to sunset.

    Sellers evaluating free vs. paid shipping

    Etsy often promotes free shipping listings. But offering free shipping means absorbing the cost somewhere. This spreadsheet helps you model both scenarios — charging for shipping vs. building it into the product price — so you can decide with real numbers.

    Sellers in the Offsite Ads program

    If Etsy has enrolled you in Offsite Ads (mandatory above $10k annual sales), the additional 12-15% fee changes your margin math. This spreadsheet includes an offsite ads toggle so you can see exactly how it affects profitability on each product.

    Growing sellers preparing to raise prices

    Raising prices is one of the most effective ways to improve Etsy profitability — but it's nerve-wracking without data. This spreadsheet gives you a defensible basis for a price increase: your actual costs, your current margin, and the price you'd need to hit a healthy target margin.

    When You Outgrow the Spreadsheet

    When your product line grows, you start selling on multiple channels, or you just want costs calculated automatically from your Etsy orders — Craftybase picks up where the spreadsheet leaves off.

    Craftybase connects directly to Etsy, tracks your materials as you use them, and calculates your COGS in real time. When material prices change, your margins update automatically. No more manual spreadsheet maintenance — just accurate numbers, all the time.

    Start free trial Learn about Craftybase for Etsy

    No credit card required. 14-day free trial.