Skip to content
Guide · CRM setup and best practices

How do you move contractor data into a new CRM?

What to export, clean and import when a contractor switches CRMs or moves off spreadsheets: customers, properties, open jobs, invoices and the pricebook.

THE SHORT ANSWER

Export customers, properties, open jobs, scheduled appointments, unpaid invoices and your pricebook from the old system or spreadsheets, remove duplicates and fix addresses, map old fields to the new CRM, import in order (customers, properties, jobs, invoices), spot check a sample, then cut over on a set date.

  • Import open work and unpaid invoices first; history can follow.
  • Clean duplicates and addresses before import, not after.
  • Spot check a sample of records against the old system.
  • Keep a read-only export of the old system for reference.
Updated October 27, 2026 · By the Sunwell team

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

  1. Export. Export every table you need from the old system or collect your spreadsheets.
  2. Clean. Merge duplicates, fix addresses and remove junk records.
  3. Map fields. Match each old column to a field in the new CRM.
  4. Import in order. Import customers, then properties, then jobs, then invoices.
  5. Verify. Spot check a sample of records and compare totals.
  6. Cut over. Pick a date to stop creating new work in the old system.
Questions

What shops ask before they switch.

Will I lose data switching CRMs?

Not if you export everything first and keep a read-only copy. Sunwell imports customers, properties, open jobs and your pricebook during setup, and you can export your data from Sunwell whenever you want.

Can I move to a CRM from spreadsheets?

Yes. Spreadsheets are often the easiest source, because the columns are already visible. Clean them first, then import.

You shouldn't pay for software you don't use. So every team gets a quote built for it.

CUSTOM QUOTE

Talk to a developer who knows the trades.

You meet with a developer who spent five years as a CTO in the trades, so the call is about your real workflows, challenges and goals, not a generic software demo. Pick a time, tell us about your team, and get your written quote within one business day.

STEP 1 OF 3 · YOUR BUSINESS

Your business

Reply within one business dayNo contract to startData move includedCustomer portal always free

Required. We only use these details to contact you about Sunwell. We never sell them.

What happens next

  1. 1A 30-minute call with a developer

    Your workflows, challenges and goals, from someone who has run tech in the trades. Not a generic demo.

  2. 2Your quote in writing

    Within one business day, sized to your team, locations and what you turn on.

  3. 3We move you over

    Customers, jobs and pricebook imported, office and crews trained. Guided setup always included.

Not ready to talk yet?

Get one short update a month on what is new in Sunwell. No spam.

Book a 30-minute call

Talk to a developer who knows the trades

Pick a time

Online booking is paused right now. Email hello@sunwellcrm.com and we'll set a time.

Loading open times
OpenAlmost fullUnavailable
Next available
Morning
Afternoon

Your details

We email you a Confirm my call button. Press it to lock in your time.

Check your email

We sent a 6-digit code to . Enter it to lock in . We hold the time for 10 minutes.

You're booked.

30-minute demo · private video link

Add to Google Calendar

The join link opens 10 minutes before your call. The calendar invite in your email has it too. To move the call, reply to that email.

Before you go

Want a quote without a call?

Leave your email. We send a few quick questions about your team, then a written quote. No spam.