Free Price List Template Spreadsheet Template for Google Sheets & Excel
A row per item on one working sheet, each with a category, the unit it is sold by, a regular price and a sale price beside it. The Free Price List Template takes free-text item names and categories, so the filing is yours, and keeps its How to Use guide on a second tab. A list of prices rather than a quoting tool. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
The FinancialAha Free Price List Template Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Price List Template Excel template and a Free Price List Template Google Sheets template from the same download. This Free Price List Template spreadsheet template holds a row per item with what each is sold by, the standard price and a sale price beside it. No macros, no VBA, no sign-up.
Inside the workbook
What's inside the FinancialAha Free Price List Template spreadsheet template
The FinancialAha Free Price List Template Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Price List Template spreadsheet holds.
01of 01
Price List
A row per item, each naming it, the category it belongs to, the unit it is sold by, its regular price and a sale price alongside. The unit column is the one people skip and then regret - a price means nothing until you say whether it is per cup, per hour, per bag or per event, and putting it in its own column keeps that unambiguous on a list a customer will read. Two things this build does not do: the sale price is a figure you type rather than a percentage off the regular one, and there is no quantity or total anywhere - it is a list of prices, not an order form.
Price List
Included guide
How to Use
A step-by-step guide on its own tab, covering how to replace the sample values and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.
Works in both Google Sheets and Excel
Free Price List Template Spreadsheet template for Google Sheets
Upload the Free Price List Template Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Price List Template Google Sheets template needs no conversion step and nothing gets rewritten on the way in. The currency dropdown beside the title relabels the price columns, which matters on a document customers are going to read, and the whole Free Price List Template spreadsheet is small enough to open instantly.
Free Price List Template Google Sheets template setup
A shared copy of the Free Price List Template Google Sheets template is a practical way to publish prices, since a link stays current where an emailed file goes stale the moment anything changes. Sheets version history covers a price typed over, which matters on a document other people are working from.
Sharing the Free Price List Template Google Sheet
The Free Price List Template Google Sheet is edited when prices change rather than on any schedule. Because the sale price sits beside the regular one rather than replacing it, a promotion can be set up and then cleared without losing what the item costs the rest of the time.
Free Price List Template Spreadsheet template for Excel
The Free Price List Template spreadsheet Excel download is a plain .xlsx. Excel opens this Free Price List Template Excel template directly, with no import step and no compatibility prompt, and it prints cleanly, which matters for a list that often ends up on a counter or in a folder. There are no macros and no VBA in the file.
Free Price List Template Excel template setup
The same Free Price List Template Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Price List Template spreadsheet download to choose between.
Free Price List Template spreadsheet Excel notes
The Free Price List Template spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt - worth something when the file is being sent to customers or suppliers whose systems block macro-enabled attachments.
Opening the Free Price List Template spreadsheet Excel file
Nothing in the Free Price List Template Excel template is version-specific, so this Free Price List Template spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.
The FinancialAha Free Price List Template Spreadsheet Template covers one sheet with a row per item, a regular price and a typed sale price on each. The Essentials Price List Template Spreadsheet Template for Google Sheets and Excel changes how the discount works: you enter a percentage and the final price is worked out from it, so a price change does not mean recalculating every promotion by hand. It also adds a SKU and a description on every line, a volume pricing block with four tiers and their order minimums, a notes and terms section, and protection on the formulas so a list being edited by more than one person does not quietly break.
Notes on working in the Free Price List Template spreadsheet template
The discount column is derived - the sale price against the regular one - and stays blank where either is missing.
The sale price itself is typed rather than worked out from a percentage, so changing a regular price does not move it.
There is no quantity column and no total anywhere. This is a list of prices rather than a document that adds up.
The unit column is what a price is quoted against, and nothing validates it.
The dropdown beside the title relabels the price columns. It changes the label and nothing else.
How the Price List Template template works
The Free Price List Template Spreadsheet Template holds each item on a row of its own, with the category it belongs to, the unit it is sold by, a regular price and a sale price beside it. The unit column is the one people skip and then regret - a price means nothing until the list says whether it buys a cup, an hour, a bag or an event. Two things worth knowing: the sale price is typed rather than worked out from a percentage, and there is no quantity column or total anywhere. This is a list of prices, not an order form.
When this template helps
01
You need a price list customers or staff can actually read.
02
You run promotions and want the sale price visible beside the standard one.
03
You sell in mixed units - by the hour, by the bag, by the event - and a flat list will not do.
04
You want something that prints for a counter and shares as a link.
Tips to get the most out of it
A price means nothing until the list says what it buys, which is what the unit column is for.
Keeping the sale price beside the regular one rather than replacing it lets a promotion be cleared without losing the standard price.
A price change means revisiting the sale prices too, since the discount follows them rather than driving them.
Common mistakes to avoid
Expecting it to total an order. There is no quantity column and no total - every row states what one unit costs.
Overwriting the regular price with a sale price. Once it is gone, the promotion has no baseline to end at.
Leaving the unit blank on anything sold by weight, time or group size. That is where pricing disputes come from.
Emailing the file to customers and then changing it. A shared link stays current; a sent file does not.
How to Use the Free Price List Template Spreadsheet Template
1
Name your items
One row per product or service, with the name a customer will read.
2
Set the unit
Per cup, per hour, per bag, per event - whatever the price actually buys.
3
Enter the regular price
The standard price before any promotion.
4
Add any sale price
Typed beside the regular price rather than calculated from it, so both stay visible.
We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.
Excel
Sheets
No signup
Download instantly, no email required
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away
Frequently Asked Questions
What is the difference between the free and Essentials Free Price List Template spreadsheet template?
Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build - more capacity, more detail, and more worked out for you rather than typed. This template has no Ultimate build. What each tier holds differs by template - the comparison table on every template page lists it exactly.
Which Free Price List Template spreadsheet template should I download?
Upgrade to Essentials if you want a dashboard with charts, more categories, larger capacity, and a more polished spreadsheet for ongoing use. The Free version is a good fit for one-off planning or trying out the layout.
Can I upgrade the Free Price List Template spreadsheet template later?
Essentials is a one-time $19 purchase with no subscription. It typically adds a full dashboard, 30-50% more categories or rows than the Free version, and richer formulas. Most buyers upgrade after using the Free version for a few weeks and hitting its limits.
Is the FinancialAha Free Price List Template Spreadsheet Template a Google Sheets template?
Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Price List Template Google Sheets template, and the currency dropdown still relabels the price columns. Sharing a link is often better than emailing a file, since the link stays current.
Is the FinancialAha Free Price List Template Spreadsheet Template an Excel template?
Yes. The download is a plain .xlsx, so the Free Price List Template Excel template opens directly in Excel with no import step. There are no macros and no VBA, which matters when a price list goes to customers whose systems block macro-enabled files.
Will the Free Price List Template spreadsheet Excel file open in older versions of Excel?
Yes. The Free Price List Template spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.
Does the FinancialAha Free Price List Template Spreadsheet Template calculate order totals?
No. It is a list of prices, not an order form - there is no quantity column and no total anywhere in it. Every row states what one unit costs.
Is the sale price worked out from a discount in the Free Price List Template spreadsheet?
No, it is typed. That means changing a regular price does not update the sale price beside it. The Essentials build takes a discount percentage and works the final price out from it.
How many items does the Free Price List Template spreadsheet hold?
Sixteen, with twelve filled in the sample. The Essentials build takes twenty, and adds a stock code and a description to every line.
Is the Free Price List Template spreadsheet safe to download?
Yes. No macros, no sign-up, no tracking. The file is a plain .xlsx that opens directly in Excel or Google Sheets.
How do I open the Free Price List Template spreadsheet template in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
Can I use the Free Price List Template spreadsheet template for commercial work?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
