What should you export from the old system?
- Customers with phone, email and billing details.
- Properties and service addresses linked to each customer.
- Open estimates, proposals and jobs, with status.
- Scheduled appointments and crew assignments.
- Unpaid invoices and deposits received.
- Pricebook items, labor rates and templates.
- Notes, photos and documents that matter for open work.
How do you clean data before importing?
Merge duplicate customers, standardize address formats, split full names into first and last where the new CRM expects it, and remove test or junk records. Fixing these in a spreadsheet takes hours; fixing them after import takes weeks.
How do you check the import worked?
Pick twenty records across job types and compare them with the old system: contact details, property, open job status and balance due. Then compare totals, such as the number of customers and the sum of unpaid invoices.
Step by step
- Export. Export every table you need from the old system or collect your spreadsheets.
- Clean. Merge duplicates, fix addresses and remove junk records.
- Map fields. Match each old column to a field in the new CRM.
- Import in order. Import customers, then properties, then jobs, then invoices.
- Verify. Spot check a sample of records and compare totals.
- Cut over. Pick a date to stop creating new work in the old system.