From spreadsheets to a CRM,
and what automation adds.

CRM means customer relationship management. A CRM system brings contacts, enquiries, interactions and next actions together. The useful change is a shared way to manage relationships, with fields, permissions and rules that fit your business.

Spreadsheets are brilliant tools. They are flexible, everybody has one, and they cost nothing extra. That is exactly why so many firms end up running their clients, enquiries and suppliers from one.

A basic spreadsheet records information. It can support reminders, reports and shared editing when you add scripts, formulas or connected tools. The difficulty is maintaining that setup, relationship history and permissions as the business grows.

In the founder-led firms I work with, the spreadsheet often grows one column and one tab at a time, until the business depends on a system nobody explicitly designed.

Moving the data is half the job. The value arrives when the CRM is connected to the way the business runs, so that it does part of the work instead of waiting to be updated.

In practice that means an enquiry from your website or inbox creates the record by itself. A follow-up task appears when a client has been quiet for the number of days you chose. A contact moves to dormant after months without a reply. The founder receives a weekly report built from the questions they actually ask. And when work is won, the client is created in the accounting software without anyone retyping it.

None of this needs AI. It needs clear rules, agreed once, and a reliable connection between the tools you already pay for.

1. Start from the questions. What do you want to know about your business that you cannot answer today? The fields follow from that, not the other way round.

2. Count what you really have. Open the files and count the rows. A description is a starting point, not a fact.

3. Agree the vocabulary. Statuses, types of contact, what counts as a live client. Fixed lists, so that everyone records the same thing the same way.

4. Test on a sample. Import ten records, check every field, then import the rest. Agree how notes and history will be mapped or archived, then compare sample records and totals against the source before accepting the import.

5. Add the automations. Follow-ups, status changes, alerts and reports, tested on copies before they touch real records.

6. Hand it over properly. A written guide, a named owner in your team, and a check of every rule a week after go-live.

A founder-led recruitment agency in London had its activity spread across spreadsheets, email and notes. Records now sit in one place, follow-ups come up as a daily list, and the founder can see which parts of the market respond, set against what they are worth.

For another founder-led firm, I recommended moving contacts, enquiries and supplier commission into one CRM, with passwords in a password manager. That was the recommended next step, rather than the outcome described for the recruitment agency.