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, overhead, and all Etsy fees (transaction, payment processing, listing, offsite ads) — 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 calculation with customizable hourly rate
  • Full Etsy fee breakdown (transaction, processing, listing, offsite ads)
  • Shipping cost inclusion (packaging, postage, materials)
  • Overhead allocation per product
  • Profit margin calculator with target margin setting
  • Break-even analysis per product
  • Side-by-side comparison for multiple 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, listing fee, and offsite ads — all calculated automatically from your sale price.

True Cost Per Product

Combine materials, labor, overhead, 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, set a target margin, and find out what price you need to charge to hit it. 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), listing fee ($0.20), and optional offsite ads fee (15%). Enter your sale price 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 sale price, including shipping if you charge for it. Applied to the total item price.
Payment Processing Fee (3% + $0.25)
Etsy Payments fee applied to the total payment amount. Varies slightly by country — the spreadsheet lets you adjust 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.
Offsite Ads Fee (12–15%)
Optional toggle in the spreadsheet. If Etsy promotes your listing and makes a sale, they take an additional 12-15% depending on your annual revenue. Learn about offsite ads

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

True Cost Per Product

Add your material costs, labor time, and overhead. 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 costs per unit or per batch.
Labor Cost
Set your hourly rate, enter how long the product takes to make, and the spreadsheet calculates your labor cost per unit. We recommend starting at $15-20/hr minimum — learn how to calculate handmade labor costs.
Overhead Allocation
Studio rent, utilities, tools, subscriptions — these costs need to be spread across products. Enter a monthly overhead total and the spreadsheet allocates a portion to each item. Learn how to factor in overheads.
Shipping Costs
Postage, packaging materials, poly mailers, boxes, tissue paper, tape. If you offer free shipping, these costs still exist — the spreadsheet helps you factor them in to your product price.

Profit Margin Visibility

See your actual profit margin on each product — not what you think it is. Set a target margin and the spreadsheet tells you what price you need to charge to hit it. It also shows your break-even price, so you know the absolute floor beneath which you'd be selling at a loss.

Actual 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.
Target Margin Price
Set a desired margin (e.g., 40%) and see the exact price you'd need to charge to achieve it after all fees. Useful for setting pricing floors and anchoring your rates.
Break-Even Price
The minimum price to cover all costs with zero profit. Never list below this number — it means you're paying for the privilege of making and selling the product.
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.

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.

Product Name & SKU
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.

A pricing calculator forces you to face all of these numbers before setting a price — not after you've already sold 200 units at a margin you can't sustain. It's 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

The calculator comes in two formats — an Excel file (which also works in Apple Numbers) and a Google Sheets-compatible version. Pick whichever you prefer. Both files are included when you download.

The core calculations work for any Etsy seller. Etsy's fee structure is broadly the same globally, though payment processing rates vary slightly by country. You can adjust the processing fee percentage in the spreadsheet to match your region's rate.

Our online Etsy fee calculator gives you a quick per-sale fee breakdown — great for checking a single price. This spreadsheet goes deeper: it includes material costs, labor, overhead, and lets you compare multiple products side by side to see your true profit margins across your whole product line.

No. The spreadsheet is completely free and standalone — it works without a Craftybase account. We'll send you a few helpful emails about pricing and cost tracking for makers, but the spreadsheet works on its own from the moment you download it.

Start with what you'd want to pay yourself per hour — we suggest at least $15-20/hr as a minimum. Track how long each product takes to make, then multiply time × rate. For example, if a product takes 45 minutes to make and your rate is $20/hr, your labor cost is $15 per unit. Our post on calculating handmade labor costs walks through the full process.

Most successful Etsy sellers aim for 30-50% gross profit margins after all costs (materials, labor, overhead, Etsy fees). This means if your fully-loaded cost to make and sell a product is $12, you'd want to price it at $17-24. Lower-margin products aren't necessarily bad — if volume is high and production is efficient, they can work. But most handmade sellers benefit from higher margins because volume is inherently limited by production capacity.

Review your pricing at minimum twice a year — and any time your material costs change significantly. Supplier price increases, shipping cost changes, and new product variations should all trigger a pricing review. The spreadsheet makes this easy: update your material costs and it recalculates margins across all products immediately. See our guide on Etsy pricing strategies for more on when to adjust prices.

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.