This article is reader supported. Some links are affiliate links, which means TradeProStack may earn a commission at no extra cost to you if you subscribe through them. That commission never changes the verdict, recommendations order, or limitations stated here.
What is the quick take?
Clean customer list before you import it, not after. Export the list you have, remove duplicates and dead contacts, map every field to the new system, decide what to archive instead of import, and run a small test import before moving the full list.
This checklist is based on vendor help documents read on October 31, 2026, not on hands-on testing. Where a document does not state a detail, this article says so instead of filling the gap.
If you are moving to Jobber, start with Jobber and work through the steps below in order. The same cleanup steps apply if you are moving elsewhere, but the menu labels and field rules here are the ones published by Jobber and Housecall Pro.
Best for: owners about to switch software.
Why does dirty customer data break a migration?
A migration copies problems as faithfully as it copies good records. A duplicate becomes two records that can each receive reminders, quotes, and invoices. A wrong phone number means reminders go nowhere. A missing street address can mean a customer arrives without a property record attached.
Cleaning first protects the work after the move. With one record per customer and one service address per property, scheduling, invoicing, and follow-up start from the same list. For the cost side, read the software switching cost calculator. For moving off paper, read the signs paper and spreadsheets are costing you jobs.
How do you export before you clean?
Start with an export from the system you are leaving, so you are cleaning a copy and the original stays intact until the new list is verified. In Jobber, the published export route is Clients in the side navigation, then top right More Actions, then Export Clients, then choose VCard or CSV, then Export. Jobber emails the exported list when ready.
Jobber exports as CSV or vCard, full list or filtered by tag, including tags, property addresses, contact information, or custom fields. If multiple tags are selected, only clients with every selected tag are exported. A CSV export handles up to 1,500 rows at a time, so more than 1,499 clients produces multiple files in the export email. Client exporting is available on select plans only, and Jobber does not name the plans on that help page, so no plan is named here. Keep the original export untouched as your backup, and clean a separate copy.
How do you dedupe a customer list before import?
Sort by name, then phone number, then email address, and look for the same customer entered more than once. Duplicates often hide behind small differences: a nickname in one row and a full name in another, a mobile number in one row and a home number in another, or a company name in one row and a personal name in another. Merge those rows into one record, keeping the best details.
Do the same check for properties. In Jobber, use one new row per property, with the same client details and billing address and differing only in service address. For an existing Jobber client, export the client list, add a row per additional property with the new service address, and leave J-ID blank for each new property. Housecall Pro warns the same way: combine duplicate rows first, because its Import Wizard expects one row per job or invoice.
Check phone and email format. Jobber validates email format, multiples comma-separated. Housecall Pro requires 10 or 11 digit phones, with multiple phones, emails, or tags comma-separated. Correct bad details from your own records, or remove that record from the active list. A customer with no working phone, email, or service address cannot be scheduled, invoiced, or reminded, so archive it or hold it out.

How do you map fields for Jobber?
In Jobber, import by CSV instead of adding clients one by one. Accepted types: CSV, TSV, PSV; CSV is most common, and a sample file is offered. If clients are already in QuickBooks, sync from QuickBooks first to avoid duplicates, then CSV-import the rest. Only admin users can import and export clients, except some client data can be exported by team members with the Reports permission setting. The import cannot run in incognito or private browsing. Go to Clients, top right click More Actions, choose the import option, then click Begin Import, then Add file. Jobber import follows that route.
Jobber matching is automatic. On mismatch, pick the correct field from the dropdown or add data as a custom field. Preview values per column, then click Continue after confirming headings. Errors are highlighted in red and filtered with the Invalid filter. Validated fields: Name (full, first, last, or company name must exist), Email (proper format, multiples comma-separated), Account balance (must be a number), Title (Mr, Ms, or Mrs), J_ID (previously exported clients, two numbers separated by an underscore, e.g. 3434_5434). Click Import after review; a progress screen follows and you can navigate away while it runs.
Headers include names, company details, Is Company? (TRUE commercial, FALSE residential), phone types, Email, Street or anything beginning with Address, City, Province or State, Country, Postal or Zip Code, billing address fields, Text Message Enabled Phone Number, reminder and follow-up flags, Account Balance, Archived, Note, comma-separated Tags, and Lead Source. Empty Street means no property is created. Files must be under 2.5MB, about 5,000 rows; split larger lists by tag or service area.
Only text-based client custom fields can be imported, not dropdown fields. Title the CSV column as the desired field name, and on the Map fields page select Add as new field from the dropdown (the name may show with CFT added). If a matching field exists, data maps to it; otherwise a new field is created. Custom lead sources cannot be uploaded. Only Facebook, Google, Instagram, Flyer, Referral, Vehicle Wrap, and Other can be imported as lead sources.
How do you map fields for Housecall Pro?
Housecall Pro offers four ways to add customers: import a customer list from a .CSV file, connect and import from QuickBooks (Online or Desktop), import contacts, or add customers manually. Import from only one source, whichever is most up to date. If QuickBooks and another system both hold data, import from the source of truth, and do not also import past data from QuickBooks.
In the Housecall Pro Import Wizard, you upload historic data, map each field to the Housecall Pro field, and correct errors before finishing. The import page states you do not need to modify your data to match a template, because the system matches your fields to Housecall Pro fields. The wizard matches fields; it does not decide which duplicate is correct.
Rules include: Customer ID up to 191 characters, required, but Display name is used if you have no ID; Display name, usually the full or company name, required, but First, Last, or Full name is used if missing; you must have one of name, company, or email; zip must be a real USA zip, states full name or 2-digit code; phones 10 or 11 digits; multiple emails comma-separated; lead source one per customer, optional; tags comma-separated, optional; Type homeowner, owner, or business, optional; Notifications enabled and Is a contractor accept true or false, yes or no, or t or f, both optional.
Housecall Pro imports only one sheet, so merge split reports first, joined on shared data such as invoice number. Merge several columns into one field where needed, split a column where separate fields are required, and replace labels or values in bulk, highlighting only intended cells. Custom fields cannot be created. For unmapped data, put it in customer or job notes with a label in front, e.g. “pH Level: 7.2”. Only one level of customers is supported; parent-child billing options did not extract as text, so they are not described here.
Full options, as plain text: Housecall Pro import options help article.
Should you archive a customer or import them?
Import customers you can still serve; archive the rest. Ask: working phone or email, a service address where work could be booked, and a reason the customer might still need you? If all three are no, archive, do not import into the daily list. Jobber supports that split in the import file, with mass updates for text-message-enabled phone, visit and assessment reminders, job, quote, and invoice follow-ups, Archived status, and Tags.
Clean customer list: what is the import checklist?
- Export the full list; keep the original export untouched.
- Jobber: admin user only, never in incognito or private browsing. Housecall Pro: one most up-to-date source only.
- Merge duplicates into one record per customer; one row per property.
- Check Street: in Jobber, empty Street means no property is created.
- Check phone format (10 or 11 digits for Housecall Pro) and email format; separate multiples with commas.
- Rename columns to vendor field names. Jobber: text-based client custom fields only; allowed lead sources only. Housecall Pro: unmapped details go in notes with a label.
- Merge sheets into one sheet for Housecall Pro. Split a Jobber file over 2.5MB or about 5,000 rows by a clear rule.
- Map fields and review the preview. Jobber: fix red errors with the Invalid filter before Import. Housecall Pro: correct errors in the Import Wizard before finishing.
- Run a small test import first, verify it, then import the full list.
- Run the post-migration checks below before booking from the new list.
How do you verify the list after migration?
Start with counts. Compare customers imported against cleaned records intended for import, and account for every difference. A shortfall usually means rows were rejected, split across files, or held out as archived. An excess usually means duplicates survived cleanup. Do not book from the new list until the counts reconcile.
Spot-check across the list, not just the first page. Confirm each property arrived for multi-property customers, custom text arrived in the right field or in notes with its label for Housecall Pro, comma-separated values arrived intact, and lead sources map to an allowed value. Then test: send a reminder to your own number, book a test job for a multi-property customer, and run a filtered export. In Jobber, multiple tags export only clients with every selected tag. Keep the old export until the new list has run one full scheduling cycle.
What is the verdict?
Clean customer list first, import second, verify third. Both vendors automate field matching and flag errors before import finishes, but neither decides which duplicate is correct, which number still works, or which customer to archive. Those owner decisions are cheaper in a spreadsheet than in a live system full of booked jobs. If Jobber is the destination, start from Jobber after cleanup, and keep the original export until post-migration checks pass.
This article covers the customer list only, not job history, price book, equipment, or payment data. Where a document did not state a detail, this article left it unknown. Confirm unmapped fields, billing structures, or plan questions with the vendor before importing.
What should you read next?
- Software switching cost calculator: the cost side of a move, covered by the tool rather than repeated here.
- Paper and spreadsheets costing you jobs: the wider case for moving off paper, upstream of this checklist.








