How to Create a Spreadsheet Template to Sell

Spreadsheets are the most underrated product on this list and the easiest to get wrong. Formulas that survive a stranger, and the tab nobody builds.

27 September 20266 min read

A spreadsheet is the only digital product where the buyer's first action is to type into it. That is what makes it valuable — they are getting a working tool, not a document — and it is what makes it fragile, because the moment they type, everything you built has to hold.

Most spreadsheet products fail in one of two ways: a formula that breaks when a row is added, or a file so clever that nobody can tell what to type where.

The short version

The product is the structure, not the formulas. If the buyer cannot tell where to type, nothing else matters.
Build for the row the buyer will add, not the rows you tested with.
Never use merged cells in a data range. They break sorting, filtering and every formula that references the range.
The "Start here" tab is not optional. It is the difference between a tool and a puzzle.
Test in a fresh copy, with someone else's hands if you can.

What actually sells

Spreadsheet products sell to three buyers, and each one is buying something different:

Buyer	What they are actually buying	Typical price
The one replacing a subscription	A tool they own, once, instead of paying monthly	£19–£49
The one who cannot build it	A model with the maths already right	£29–£79
The one who wants the numbers to be defensible	Confidence in a decision they are about to make	£39–£99

That third row is the highest-priced and the least obvious. A pricing calculator, a runway model or a loan comparison is worth a lot to a buyer who is about to commit money on the strength of it — not because the spreadsheet is complicated, but because getting it wrong is expensive.

Build it

Decide the one question it answers

Not "a budgeting tool". "How many months can I survive if my income halves?" Every tab, every column and every formula is justified by that question, and anything that does not serve it is a feature you are building instead of shipping.

Write the question at the top of the Start here tab. It is also the first line of your product description.

Separate the input from the output, physically

Grey or blue cells for anything the buyer types. White or locked for anything calculated. A one-line legend at the top.

This is the single highest-value convention in spreadsheet design, and it costs you nothing. It answers "what do I type" before it is asked, and it survives the buyer adding rows, deleting columns and generally exploring.

Make every formula survive a new row

The failure everyone ships: a SUM over rows 2:20, and the buyer adds row 21.

Use whole-column references where you can, structured table references where the tool supports them, and open-ended ranges (A2:A) rather than fixed ones. Then add three rows yourself and check every number still makes sense.

Kill the merged cells

Merged cells look tidy in a header and break everything in a data range: sorting, filtering, and any formula that references it. Use centre-across-selection for the cosmetic cases instead, and leave the underlying grid alone.

This is the most common reason a template the buyer liked becomes one they cannot use.

Write the Start here tab

Three short sections: what this answers, what to type and where (with colours), and what not to touch.

Then a fourth: what to do when it breaks. One line on how to restore the formulas. Buyers who know the recovery path will experiment; buyers who do not will treat the whole file as fragile.

Test it in a fresh copy, on a different account

Open your own download as a stranger would. Type nonsense into it. Add rows. Delete a row in the middle. Sort a column.

Half of what you find will be cosmetic and half will be real, and the real ones are the entire difference between a product and a file.

The compatibility decision

Google Sheets or Excel? It matters more than it seems, because the answer changes who can use it.

Google Sheets is the better default for anything sold to individuals. It opens anywhere including a phone, it is free, and buyers can copy it to their own Drive in one click. The cost: you cannot truly revoke access to a copy, and some Excel functions do not exist.

Excel suits business buyers and anything with heavy modelling. It also means your buyer needs Excel, which is a real barrier for consumers.

The pragmatic answer for most products is Sheets, exported as .xlsx as well, with a note saying which one is the primary. Shipping both costs you one export and removes an entire category of complaint.

What it is. A spreadsheet that answers one specific question, with the input cells marked, the formulas built to survive new rows, and a Start here tab.

Who buys it. Someone paying monthly for a narrower tool, or someone about to make a decision they cannot afford to get wrong.

What you need. Google Sheets, a real question you have answered for yourself, and an hour of deliberately trying to break your own file.

What to charge. £19–£79. The top of that range is for models where being wrong is expensive, not for models with more tabs.

Time to build. An afternoon for the tool, a week of using it, and an hour of testing it in a fresh copy before you sell it.

Price it

The anchor is almost always a subscription. If someone is paying £25 a month for a narrow tool and your sheet replaces the part they use, £49 is four weeks of what they already pay and then nothing forever. Say that out loud in the description — the arithmetic does the work.

For models sold to businesses, the anchor is different and much higher: it is the cost of the decision. A pricing model that stops someone underpricing a year of work is not competing with a £25 app. It is competing with the mistake, and that is why £79 is defensible and £9 is not.

Build This Product: A Budget Planner — a spreadsheet product worked through end to end, including the second version.
How to Create a Notion Template to Sell — the same structure-first thinking, without the formulas.
What spreadsheets and models sell for — who buys, what to bundle, and where to share it.