Etsy pricing spreadsheet: from your cost to the price to list at
One row per product. Type what the item costs you, the shipping you charge and the profit or margin you want to keep; the sheet works out the item price to list at on Etsy after every fee for your country, and the break-even price where you keep nothing. Same formula as the free online pricing calculator.
Excel .xlsx. Google Sheets: File → Import → Upload. No signup, no email.
Or see Growtsy’s verdict on a sample listing — free, no signup →
What’s in the file
- Settings — your shop country and whether a VAT ID is on file with Etsy; the percentage and fixed fees for that country are worked out below.
- Prices — 100 rows, one per product: list price, break-even price, order total, what Etsy takes and what you keep, as formulas.
- Rates — the fee table for 32 seller countries with the date each was verified (2026-10-30).
Every calculation is a formula you can click and read, not a pasted result.
What the template shows for the example products
The two example rows that come in the file, worked by its formulas for a US shop. Prices are rounded up to the cent, so you keep a cent or so more than the target.
| Target | List at | Break-even price | Order total | Etsy takes | You keep |
|---|---|---|---|---|---|
| Keep $15.00 per sale$8.00 cost, $6.00 shipping | $19.92 | $3.34 | $25.92 | $2.91 | $15.01 |
| Keep 30% of the order$8.00 cost, $6.00 shipping | $7.97 | $3.34 | $13.97 | $1.78 | $4.19 |
How to use it
- Download the file and open it in Excel, or in Google Sheets with File → Import → Upload.
- On Settings, pick your shop country and say whether a VAT ID is on file with Etsy (yellow cells).
- On Prices, type each product’s cost and the shipping you charge, in US dollars.
- Pick Profit (a dollar amount to keep per sale) or Margin (a percentage of the order total) and type the target.
- List at is the price to enter on Etsy; Break-even is the price where Etsy’s fees and your cost use up the whole order.
Etsy’s rules this sheet uses, word for word
- “You will be charged a listing fee of $0.20 USD for each item that you list” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
- “you will be charged a transaction fee of 6.5% of the price you display for each listing plus the amount you charge for shipping and gift wrapping.” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
- “Payment processing fees are a set rate plus a percent of the total sale price of the item. This rate and percent vary by country. The fees are taken from the item’s total sale price, including its shipping fees, and any applicable sales tax.” — What are Payment Processing Fees for Selling on Etsy? — Etsy Help.
- “This fee is charged on the item price and shipping costs” — What is a Regulatory Operating Fee? — Etsy Help.
- “VAT is collected on all Etsy fees for sellers located in countries where VAT should be applied.” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
What it doesn’t do
- It doesn’t say what buyers will pay. To see the asking prices of live listings for a product, use the free niche checker — listing prices, not sale prices.
- It doesn’t estimate sales or revenue; Etsy doesn’t publish sales for a single listing.
- It leaves out Offsite Ads, Etsy Ads and currency conversion, and assumes an order without sales tax.
Common questions
How do I work out an Etsy price from my cost in a spreadsheet?
Etsy’s percentage fees (the 6.5% transaction fee, payment processing and any regulatory operating fee, plus the tax Etsy adds to its fees) come off the whole order, so the price is: (target profit + your cost + the fixed fees) ÷ (1 − the percentage fees), minus the shipping you charge. The fixed fees are the $0.20 listing fee and the fixed part of payment processing. The template does this per product and rounds up to the cent.
What is the break-even price?
The item price at which Etsy’s fees and your cost use up the whole order and you keep nothing. Below it, every sale loses money. The template shows it next to each list price.
Profit or margin — which should I use?
Profit is a dollar amount you keep from each sale; margin is the share of the order total you keep. If a margin target is higher than what is left after Etsy’s percentage fees, no price reaches it and the sheet says Out of reach.
Does it tell me what other Etsy sellers charge?
No. It works from your own numbers. The free niche checker shows the middle half of the US-dollar asking prices among Etsy’s first 100 search results for a product — listing prices, not sale prices.
Related
- Etsy pricing calculator — the same formula for one product, online.
- Etsy fee calculator — price in, every fee out.
- Niche checker — what live listings for a product ask.
- All free Etsy spreadsheet templates — the other templates.
Next: the listing itself
A spreadsheet tracks the numbers; Listing Analysis reads one of your listings against live Etsy data and says the one thing to change first — not a score, a decision. Free account, no card.
Or see Growtsy’s verdict on a sample listing — free, no signup →