From spreadsheet to CRM: how to move your contacts without losing anything
2026-11-17
When a spreadsheet stops being enough
A spreadsheet is a good first CRM. It breaks down when several people edit it, when one client has many deals, or when you need to know who changed what.
- Two people overwrite each other
- The same client is typed three different ways
- Nobody can see only their own deals
- Reminders live in somebody's head
Step 1: one sheet per kind of thing
Split the sheet into one table per kind of object: clients, deals, invoices. In a CRM each becomes a module, and a deal points to its client instead of repeating the name.
Step 2: import, then fix
Export each sheet as CSV and import it. Check the column mapping, let the import report rows it could not read, and fix those in the CSV rather than by hand afterwards.
Step 3: replace free text with fields that check themselves
A status becomes a choice list, an amount becomes a currency field, a deadline becomes a date. The CRM can then filter, add up and remind, which a column of text never does.
Step 4: a dashboard you open every morning
Count open deals, add up what is due this month, list what is overdue. Keep it to five blocks you really read.