The short answer
A spreadsheet is enough as long as one person maintains it, there is a single file and nobody needs to know who changed what. It stops being enough when several people depend on the same numbers, when you have to prove the history of a change, or when the information in one document has to show up in another.
It is not a question of being modern. It is a question of what happens when something goes wrong: if the cost of a silent error is low, the spreadsheet is enough; if it is high, you need the system to catch it for you.
When a spreadsheet is still enough
- A small project or a single work front, with one person in charge of the data.
- Calculations done once and filed away: a quotation, a one-off check.
- A form that only you fill in and only you read.
- A prototype, while you do not yet know which data you need.
A well-built spreadsheet, with reviewed formulas and a disciplined person behind it, can last for years. Changing tools without needing to also has a cost.
When it starts to fail
| Situation | Spreadsheet | Construction software |
|---|---|---|
| Several people update at the same time | Diverging copies or editing conflicts; someone reconciles by hand | One live version, with every change tied to its author |
| Knowing who changed a value and when | Depends on someone writing it down or on reviewing file versions | The history is part of the record |
| A piece of data must appear in several documents | It is copied and pasted; each copy can go out of date | It is entered once and the other documents read it |
| A formula error | It can go unnoticed until someone adds up by hand | The calculation rules live in one place and are tested |
| Working on site with no signal | A local file works; syncing it is manual | Depends on the product: ask whether it saves offline and how it syncs |
| Permissions by role | All or nothing, or several separate files | Each person sees and edits their own part |
| Periodic reports | Assembled by hand every time | They can be generated from what is already recorded |
Worked example: the error that gives no warning
A budget of five line items: 12,500,000; 8,300,000; 21,000,000; 4,750,000; 9,900,000 pesos. The correct total is 56,450,000.
The total formula was written when there were four line items, and it summed exactly that range. Later someone added the fifth one below it, outside the range. The spreadsheet shows 46,550,000: 9,900,000 pesos short, with no warning. No red cell, no message. The numbers are invented; the mechanism is not.
Six questions to decide
- How many people change this data? If it is more than two, the spreadsheet starts to cost you.
- Does anyone need to know who changed a value and why?
- Is the same piece of data written in more than one document?
- What happens if there is a 1% error nobody sees? If the answer is "nothing serious", stay with the spreadsheet.
- How much time each month goes into assembling reports by hand? The hours simulator on this site lets you put a number on it with your own data.
- What would migrating cost? Changing tools has a cost in data and in habits; do it when the pain justifies it.
Limits of this comparison
It compares two categories, not specific products, and it includes no cost or savings figures because they depend on each company. Construction software can also be badly configured or left unused; no tool replaces the discipline of recording on time.
Frequently asked questions
Isn't a well-made spreadsheet enough?
It can be. It depends on how many people use it and on how much an error costs. The comparison above shows when the answer changes.
Can both be used?
Yes: many companies keep using spreadsheets for one-off calculations and a system for what must be recorded and shared.
What should I require from construction software?
That it records who changed what, that it does not lock your data in (you can export it) and that it works where you work, including a site with poor signal.
Sources
- This comparison is based on professional practice criteria, not on studies or external data. The example is arithmetic with invented figures.