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.