Guides

Moving from spreadsheets to a CRM

How to tidy your spreadsheet, import it and start using a CRM without losing anything.

A spreadsheet works until it doesn't: someone overwrites a row, nobody remembers who called whom, or the sheet has five versions. Moving to a CRM puts everything in one place. Here is how to do it carefully.

1. Decide what to bring across

You usually have lists of customers, prospects, and maybe jobs or quotes. Decide which are worth keeping. Old, dead contacts clutter the system, so archive them in the spreadsheet first.

2. Tidy the spreadsheet

  • One row for each person or company, with a header row.
  • One column for each kind of information: first name, last name, email, phone, company.
  • Remove duplicates and fix obvious typos in emails and phone numbers.
  • Keep an ID or unique column if you have one, so records can be linked.

3. Split into separate files

Put companies, people, and deals in separate sheets or files. ZyfrHub links them together, and imports organisations, contacts, leads, opportunities and products first, then their notes and activities. See Importing your data.

4. Import and match

Go to Import data, upload a file, and match your columns to ZyfrHub's fields. You'll see each owner, stage and status found in the file and can pair them with your teammates and stages. Rows that can't be imported are listed with the reason so you can fix them and import again.

5. Check and undo if needed

Look through a few records. If something is wrong, use Import data › Recent imports › Undo to remove what the import added, fix the file and try again.

6. Clean up duplicates

Possible duplicates are flagged by email, phone, name or company, and you can merge two records without losing history. See Duplicates and company look-up.

7. Switch over

Pick a date, tell your team the spreadsheet is now read-only and make the CRM the only place to add new customers. Keep the old spreadsheet as a backup for a few weeks.

If you're coming from another CRM such as Pipedrive, HubSpot, Salesforce or Zoho, the import recognises each system's export and links notes and activities to the right records.

Still stuck? In ZyfrHub, click ? in the top bar, then Contact support, or email support@zyfrhub.com.
New to ZyfrHub?
14 days of the full Pro plan, no card needed.