When your spreadsheet has outgrown itself
Spreadsheets are a great first tool. At some point, though, the sheet starts running the business instead of helping it. Here is how to tell, and how to move on carefully.
Warning signs
- Two people edit at once and one overwrites the other.
- You have copies named "final", "final2" and "final-REAL".
- The same customer is typed in many rows with slightly different spellings.
- Formulas break when someone sorts or inserts a column.
- One tab links to five others and only one person understands how.
- You need different people to see different data, and cannot do that safely.
- The file is slow to open.
- You want forms, reminders or a phone app, and are bolting them on.
If you recognize three or more, it is time to look at an alternative.
Your options
- Airtable: looks like a spreadsheet but each column has a type, and tables can link to each other (customers to orders). Good for teams who want to stay visual. Record limits and features depend on the plan.
- Zoho Creator: a low-code builder for custom apps with forms and workflows. A good fit if you already use other Zoho products. Plans vary.
- Google AppSheet: builds a phone and web app on top of a Google Sheet, Excel file or its own database. Good for field work such as checklists and inspections.
- Simple SQL database: for example SQLite, MySQL or PostgreSQL. The most flexible and the most work. Worth it when you need a custom website or reports tied to the data.
Choose based on who will maintain it. If nobody on your team wants to learn SQL, start with one of the first three.
How to migrate cleanly
- Freeze and copy. Save a dated copy of the spreadsheet and make it read-only. This is your safety net.
- Clean first. Make the first row a single header row with simple names. Remove merged cells, blank rows, and notes typed into data columns. Fix duplicates and spelling.
- Give each row a unique ID. AppSheet in particular relies on a key column to sync changes. A simple number works.
- Split the data into tables. Customers in one, orders in another, linked by the customer ID, instead of retyping names.
- Import a test batch. Airtable can import a CSV into a new base or an existing one. Its built-in import takes CSV files up to 100 MB (the separate CSV import extension is capped at 5 MB and 25,000 rows), and everything arrives as plain text fields that you then convert to proper types (dates, numbers, dropdowns). Airtable advises taking a base snapshot before importing into existing data.
- Compare. Check row counts and a few totals against the original sheet.
- Run in parallel for a week or two before retiring the sheet.
- Write down what each table and field means, in plain language.
Keep an export
Whatever tool you choose, schedule a regular export of your data to CSV or a database dump and store it outside the tool. This protects you from mistakes and from being stuck if you ever want to switch. Check how each vendor exports and whether it includes attachments and linked records. Put it on your monthly backup routine.