Comparison Tracker · Free · No account
A product comparison spreadsheet for Excel, for something to buy.
The buy setup names each row an Option and has three must-haves: In budget, In stock and At least two years’ warranty. There is no quote date or contact column. Good points and Doubts give each option two short notes, and a Link column stores the listing.
- Excel 2016 and later
- Calculations checked in LibreOffice and Google Sheets
- Name each rowType what each row is called, such as Quote, Provider or Place. It becomes the first column heading and the sheet name.
- Write your must-havesList up to six, one per line. Each becomes a column answered Yes, Partly or No. Choose the currency and how many months to compare costs over.
- Download and add optionsDownload the workbook, open the sheet and add each quote as it arrives. The total, the gap from the cheapest and the Summary update automatically.
Build your workbook
Preview: Product comparison. Change the selected dates, categories or layout to update the preview.
JavaScript is required to use the builder. The workbook is made in your browser.
What you get
What is different in this setup
Shoppers comparing a washing machine, a laptop or a sofa across several shops, who want the price with delivery added on.
- Rows are called Options, with a Link column for the product page.
- Must-haves suited to a purchase: budget, stock and warranty.
- No quote dates or contact columns, so the sheet is narrower.
Sheets included (4)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- OptionsEach option once, with its costs and must-haves.
- SummaryWhat is still in the running, by total cost, and what is still to find out.
- ListsEdit the white lists to change dropdown choices. Shaded lists are fixed because formulas use those names.
File details
- Made for
- Excel 2016 and laterThe download is an .xlsx workbook.
- LibreOffice
- No calculation errors in our testLibreOffice recalculated every formula in the workbook with no error values, such as #VALUE! or #N/A.
- Google Sheets
- Calculations matched Excel in our testGoogle Sheets removes sheet protection and repeated print headings.
- Apple Numbers
- Some calculations do not workMany calculations on the Quotes sheet and the Summary sheet do not work in Apple Numbers. Numbers converts list-based dropdowns to plain cells and removes colour markers, sheet protection, frozen headings and number and date validation. Use Excel for these calculations and features.
- Calculations
- The Start Here sheet lists the calculations used in this workbook. Results update from the entries you add.
- Builder privacy
- The builder runs in your browser. The entries used to make the workbook stay on your device. How the utilities work
Questions
Are my builder entries sent to Due Form?
No. The builder uses them in your browser to make the workbook on your device.
Information is sent to Due Form when you submit a form or use another service described on the How it works page.
Where do I put delivery or installation?
Use One-off extras. The Total cost adds it to the price, so a cheaper item with expensive delivery no longer looks like the lowest total.
Can I add my own must-have, such as a colour?
Yes. Replace or add must-haves before you download, up to six. Each becomes a Yes, Partly or No column, so Colour available works as well as In stock.
Related Due Form edition
The Decision File
Compare viable options, record the reasoning and set a review date.
For weighing the options once the facts are in
Request a tool or send feedback
Request a tool or report a problem
Tell us what you would like to add, change or fix in the Comparison Tracker builder.