From spreadsheets to custom software: when to switch and how to keep everything you have

It's time to move from spreadsheets to a system when several people edit the same file, when the same data gets entered in more than one place, or when the business depends on one person understanding the file. You don't start from scratch: you carry over what you already have, which is a lot more than it looks.

Spreadsheets aren't the enemy. For plenty of businesses they're the right tool for years. This guide is about spotting the moment they stop being the right tool, and making the switch without drama.

Your spreadsheet is already a (homemade) system

If your business has run on Excel or Google Sheets for a while, that file has more design in it than you think. The columns you added, the colors that mean something, the tabs split by month, the formula someone built that nobody dares touch: all of that is business knowledge. It says which data matters, what order work happens in, and what needs checking.

That's why a good move to software doesn't throw the spreadsheet away; it reads it. Before designing a single screen, I look at how you use it: which column gets filled first, what you search for most, and what gets scribbled off to the side because it had no home.

Signs your spreadsheet has hit its limit

You don't need all of them. Two or three usually make the switch worth it:

• Multiplying versions: “inventory final,” “inventory final 2,” “inventory final USE THIS.” Nobody knows which one is right.
• Two people editing at once and overwriting each other, or waiting for someone to close the file.
• The same data in several places: the customer is in the sales sheet, the billing sheet and someone's phone, with different details in each.
• Formulas that break when someone inserts a row, and nobody notices until month end.
• No idea who changed what: a price is suddenly different and there's no way to tell when or why.
• Useless on a phone: it works on a computer, but at the counter or out in the field it's impossible.
• Only one person understands it: when they go on vacation, the business stalls.

When to stick with spreadsheets

If it's just you, you enter a little data a day, you don't need it on your phone and the spreadsheet answers your questions, there's no rush. Software costs something to build and maintain, and it has to save you more than it costs.

Sometimes the problem isn't the spreadsheet but the lack of a process: if everyone enters things their own way, software helps, but you first need to agree on how work gets done. For a wider list of symptoms, see signs your business needs custom software.

What happens to each part of your spreadsheet

How to switch without losing anything

There are four steps. First, read the spreadsheet together, as I described above. Second, clean the data: consistent formats, no duplicates, and a decision on what comes over and what gets archived. Third, import everything and check together that it's complete. Fourth, a short overlap: the system becomes the main tool, and the spreadsheet stays as a read-only reference that nobody keeps updating.

That last part matters. If both get updated for months, neither one is ever current, so it's worth setting a cutover date. From that day on, your data is safer than in a loose file; I explained why in backups for business software.

If your spreadsheet is for pricing

A very common case at manufacturers is the pricing spreadsheet: a huge sheet with sizes, materials and formulas only the owner knows how to use. There, the step isn't just to internal software, but to letting customers price things themselves. The Estructuras 3D blog has a piece on a 3D quoting tool vs spreadsheets and drawings that shows that path.

If you're torn between building something or buying a program, custom software vs off-the-shelf should help. I work remotely from Buenos Aires, Argentina (UTC−3), with video calls and progress you can open from a link, and I quote each project separately.

Frequently asked questions