A craft pricing spreadsheet is the tool most makers reach for first, and for good reason: it's free, flexible, and forces you to actually write down your costs instead of guessing. Done well, a spreadsheet turns pricing from a gut feeling into a repeatable formula you can apply to every product in your shop.
This guide gives you the exact structure of a working craft pricing spreadsheet—every column you need, the formula behind it, and a filled-in example—so you can build one in Google Sheets or Excel today. Then we'll cover where spreadsheets start to break down, and the faster alternative that does the same math without the manual upkeep.
What a Good Craft Pricing Spreadsheet Must Include
Most homemade pricing spreadsheets fail for the same reason: they only track material costs. They leave out labor, overhead, and marketplace fees, so the "price" they produce is really just a break-even number dressed up as a profit. A complete craft pricing spreadsheet captures four cost layers plus your profit:
- MaterialsEvery physical component that goes into one finished item—down to thread, glue, and packaging.
- LaborYour production time multiplied by an hourly rate you've actually chosen, not left at zero.
- OverheadYour monthly business costs (fees, software, booth rent, utilities) divided across the items you make.
- Profit and feesA markup for profit, plus a buffer for marketplace and payment fees so your take-home survives Etsy or a card processor.
The Craft Pricing Formula Behind the Spreadsheet
Every cell in a good pricing spreadsheet exists to feed one formula. Get this right and the rest is just data entry:
Selling Price = (Materials + Labor + Overhead) x Profit Multiplier
Then, because marketplaces take a cut, many sellers add a second step so fees don't eat the margin they just built in:
Listed Price = Selling Price / (1 - Fee %)
If your fees total roughly 11% on Etsy, you'd divide by 0.89. For the full breakdown of each component, see our handmade pricing formula guide.
The Exact Columns to Build (Free Template Layout)
Open a new Google Sheet or Excel file and create these columns. This is the template—you're building a row per product. Anything in brackets is a calculated cell.
- A – Product nameText
- B – Material costInput
- C – Minutes to makeInput
- D – Hourly rateInput
- E – Labor cost[ =C/60*D ]
- F – Overhead per itemInput
- G – Base cost[ =B+E+F ]
- H – Profit multiplierInput (e.g. 2.5)
- I – Price before fees[ =G*H ]
- J – Fee %Input (e.g. 0.11)
- K – Final listed price[ =I/(1-J) ]
- L – Profit per item[ =K-K*J-G ]
Pro Tip: Calculate overhead per item once and reuse it. Add up a month of business expenses (fees, subscriptions, booth, utilities), then divide by the number of items you realistically make that month. If overhead is $300 and you make 100 items, that's $3.00 per item in column F.
A Filled-In Example
Here's a single row for a macramé wall hanging, showing how the formula columns resolve:
- Material cost (B)$9.00
- Minutes to make (C)75
- Hourly rate (D)$22.00
- Labor cost (E = C/60 x D)$27.50
- Overhead per item (F)$3.00
- Base cost (G = B+E+F)$39.50
- Profit multiplier (H)2.0
- Price before fees (I = G x H)$79.00
- Fee % (J)11%
- Final listed price (K = I / (1 - J))$88.76
Notice what the fee adjustment did: without it, you'd list at $79 and lose nearly $9 to fees, dropping your real margin. The spreadsheet builds that back in automatically so the price you set is the margin you keep.
Tired of calculating craft costs manually?
CraftsTrack automates pricing so you can focus on what you do best—creating.
Tips to Make Your Spreadsheet Actually Useful
- Build a separate materials tab. List each supply, its pack price, and the quantity per pack, then calculate a true per-unit cost. Reference those cells in your product rows so a price change updates everywhere.
- Round the output sensibly. $88.76 becomes $89 or $90. Use charm pricing only if it fits your brand—premium handmade often rounds up cleanly.
- Add a wholesale column. Duplicate column I at a lower multiplier (around 1.5x base cost) so you can quote wholesale without re-deriving numbers.
- Date your costs. Add a "last updated" column so you know when material prices were last verified— essential as supply costs keep rising in 2026.
Where Craft Pricing Spreadsheets Fall Short
A spreadsheet is a great starting point, but most sellers eventually hit its limits. The math is simple; the maintenance isn't.
- It goes stale fast: Every time a supplier raises a price, you have to find and update the right cell. Miss one and your prices drift out of date.
- Broken formulas are silent: One accidental edit to a formula cell and a whole column produces wrong prices with no warning.
- It doesn't scale: Managing 50+ products, variations, and material conversions in one sheet becomes unwieldy and error-prone.
- No guardrails: A spreadsheet will happily let you price below cost. It doesn't warn you when a multiplier is too low to be profitable.
The Faster Alternative: A Craft Pricing Calculator
If you just want correct prices without building and babysitting a spreadsheet, a dedicated calculator does the identical math with none of the upkeep. CraftsTrack's free craft pricing calculator runs the same materials + labor + overhead + profit formula, factors in marketplace fees, and gives you an instant recommended price with a full cost breakdown—no cells, no formulas to break.
You can save multiple products, update a material cost once and have every affected price recalculate, and compare profit at different multipliers side by side. Think of it as a craft pricing spreadsheet that maintains itself. Many makers keep a simple spreadsheet for record-keeping and use the calculator for the actual pricing decisions.
Bottom line: Build the spreadsheet to understand the formula—it's genuinely worth doing once. Then let a calculator handle the day-to-day so rising costs and new products never leave your prices out of date.
Price Your Crafts with Confidence
CraftsTrack helps artisans and makers calculate accurate costs and set profitable prices—automatically.
Get Started Free