The Spreadsheet That Became Your Entire Business
A simple spreadsheet can gradually become the centre of a business. Learn how to recognise when it's doing too many jobs and what to improve first.
In this guideJump straight to what you need3 sections
It began as a spreadsheet for tracking orders. Someone added customer details, then a column for payment status, then another for delivery dates. Eventually, it became the place everyone went to find out what was happening in the business.
There was never a meeting where anyone decided the spreadsheet should become the company's main operating system. It simply grew into the role.
Spreadsheets are remarkably flexible. That's part of what makes them useful, and part of what can make them difficult to manage.
When one file starts doing five jobs
A spreadsheet might begin with a straightforward purpose: keeping track of outstanding work.
Over time, employees discover that adding another column is easier than introducing a separate process. Soon, the file contains customer records, stock information, job assignments, invoice references and internal notes.
The spreadsheet becomes increasingly important, but its responsibilities are rarely documented.
One employee might use it to plan tomorrow's work. Another might rely on it for weekly reporting. A third might update customer information without realising that a formula elsewhere depends on the same cells.
Problems begin when these different uses interfere with one another.
A sorting mistake changes the order of records. A copied formula references the wrong row. Somebody accidentally overwrites information another employee needs.
The spreadsheet may still work most of the time, which makes the underlying risk easy to overlook.
Separate the information from the process
The answer isn't automatically to replace Excel or Google Sheets with custom software.
First, identify what the spreadsheet is actually being asked to do.
Does it store information? Calculate figures? Assign work? Track progress? Produce reports? Remind employees about unfinished tasks?
These functions may look similar inside a spreadsheet, but they solve different business problems.
For example, a wholesale business might use a spreadsheet to track customer orders and prepare a daily dispatch list.
If the main difficulty is copying new orders from email into the spreadsheet, automation might solve the problem without changing the rest of the workflow.
If the difficulty is several employees editing orders simultaneously, better data validation and a more structured entry process might help.
If the spreadsheet has become responsible for customer records, stock control, invoicing and staff scheduling, a more substantial software solution may eventually be appropriate.
The important thing is to understand the responsibilities before choosing the technology.
Improve the most fragile part first
A large spreadsheet can be intimidating to change, particularly when nobody fully understands every formula.
That doesn't mean improvement has to happen all at once.
Start with the part that causes the most frequent mistakes or consumes the most time.
Perhaps employees spend half an hour every morning copying yesterday's figures into a report. Perhaps customer details are entered twice. Perhaps a manager manually checks for overdue orders.
These are relatively contained problems that can be investigated individually.
Before automating them, make sure the underlying information is consistent and that the process has clear rules.
A reliable small improvement is often more valuable than a rushed attempt to replace everything.
At Software Logic, we help businesses explore spreadsheet automation, integrations and custom software where existing tools have become difficult to manage.
If you opened your most important spreadsheet today, could you explain exactly which parts of your business would stop working without it?
Have a question about your business? Talk to Liam.
Counting readers…