In many Indian companies, the most important software is not the ERP. It is a workbook called something like "MASTER_orders_FINAL_v7_new.xlsx" on one person's desktop. It calculates dealer incentives, tracks pending orders, plans production or decides credit limits. It has grown over years, with formulas referencing other files, a macro nobody fully understands, and colour codes that only its owner can read.
Excel is a superb tool. The problem starts when a spreadsheet becomes mission-critical without anyone deciding it should be. This article helps you spot that moment, get the most out of Excel automation before you outgrow it, and move to proper software without disrupting the team.
What can Excel automation do well?
Before replacing anything, use what you already have. Modern Excel can do a lot:
- Power Query pulls data from other files, folders, databases and exports, cleans it and refreshes with one click. It replaces most copy-paste work.
- Tables, XLOOKUP and dynamic arrays make formulas sturdier than old VLOOKUP chains.
- PivotTables and Power Pivot summarise large data sets without manual subtotals.
- Macros (VBA) and Office Scripts automate repetitive formatting, file generation and emailing.
- Data validation and protected ranges stop people typing text into number columns or overwriting formulas.
If your pain is "someone spends two hours every morning copying exports into a sheet", Power Query alone may solve it this week. Not every spreadsheet needs to become an app.
When does a spreadsheet become a risk?
Spreadsheets fail quietly. A well-known example: in October 2020 Public Health England said that 15,841 positive Covid-19 cases from 25 September to 2 October had been left out of reported daily figures. Its statement said some files containing positive results had exceeded the maximum file size that its central systems could load, and the immediate fix was to split large files before loading. The point is not that any one tool is bad; it is that an important process relied on a file-based step with a limit nobody was watching, and the failure was silent until the numbers were checked.
Your spreadsheet has become mission-critical when several of these are true:
- Money, stock or customer commitments depend directly on its output.
- Several people edit it, often by emailing copies back and forth.
- Only one person really understands it.
- Nobody can say who changed a number, or when.
- It takes minutes to open or recalculate, and crashes occasionally.
- It is linked to other workbooks that break when renamed or moved.
- Data is entered manually from forms, WhatsApp messages or emails.
- Errors have already caused a wrong invoice, a missed order or a payout dispute.
A note on audit trails
Since financial years beginning on or after 1 April 2023, companies that keep their books in accounting software must use software that records an audit trail of every transaction, with an edit log that cannot be disabled, under the proviso to Rule 3(1) of the Companies (Accounts) Rules, 2014. A spreadsheet has nothing comparable built in. If incentive calculations, credit decisions or cost workings that feed your books live in Excel, nobody can show later who changed a number and when. That is a good test of whether a sheet has outgrown itself: would you be comfortable explaining its history to an auditor?
Excel, low-code or custom software: which next step?
| Situation | Better Excel | Low-code / workflow tool | Custom application |
|---|---|---|---|
| One person, repetitive data prep | Best fit (Power Query, macros) | Overkill | Overkill |
| Several people entering data, simple approvals | Fragile | Good fit | Possible |
| Field staff, mobile entry, photos | Poor | Good fit | Good fit |
| Complex business rules, integration with ERP or billing | Risky | Possible, can get messy | Best fit |
| Customer- or dealer-facing access | No | Limited | Best fit |
| Thousands of records a day, audit needs | No | Depends on tool | Best fit |
How do you move a critical spreadsheet to software without disruption?
- Document what the sheet actually does. Sit with its owner. List every input, every calculation, every output and who uses it. Hidden rules ("dealers in the north get an extra 2% in March") live in formulas and in people's heads.
- Separate data, logic and reports. The data becomes database tables, the formulas become business rules in the application, and the pivot tables become dashboards.
- Keep the familiar outputs. If the sales team relies on a particular layout, reproduce it as a report or an export. People accept new software faster when the output looks familiar.
- Replace data entry at the source. Instead of someone typing orders from WhatsApp into Excel, capture them in a form or app that writes straight to the database.
- Run in parallel for one or two cycles (a week, a month-end, an incentive payout). Compare the spreadsheet's results with the application's, line by line, and explain every difference.
- Keep Excel as an analysis tool. Let people export or connect Excel to the new system for ad-hoc analysis. Banning Excel only drives shadow copies.
- Retire the old file deliberately. Make it read-only, archive it and tell everyone the date it stops being the source of truth.
Common mistakes to avoid
- Rebuilding every quirk of the spreadsheet, including workarounds for problems the new system does not have.
- Leaving out the spreadsheet's owner. They are your best tester, and potentially your biggest opponent if ignored.
- Choosing a tool before understanding the process.
- Skipping the parallel run because "the logic is the same".
- Forgetting access control. One advantage of moving off a shared file is that you can finally decide who sees margin and salary data.
What does the new system usually look like?
For most mid-sized businesses the replacement is modest: a web application with a database, a few forms (often mobile-friendly for field staff), role-based access, an approval step where money is involved, a history of every change, and two or three dashboards that replace the old pivot tables. It connects to Tally, the ERP or billing software through an export or API so numbers are not typed twice. It does not need to be large to be a big improvement.
A quick audit you can run this week
- List the five spreadsheets the business would struggle without.
- For each, note the owner, number of editors, update frequency and what decisions depend on it.
- Check whether a backup and a second person who understands it exist.
- Rank them by risk: money involved multiplied by fragility. Start with the top one.
If you want to try smaller improvements first, our free AI tools for Indian businesses are worth a look for routine tasks.
How Cehpoint can help
We turn critical spreadsheets into reliable workflow applications with forms, approvals, audit history and dashboards, and keep Excel exports for the people who want them. See our business process automation service. Where the spreadsheet is really a reporting problem across several systems, our data engineering and BI dashboard service is the better fit.