Jobber vs Housecall Pro: customer imports and duplicates

A big customer import is only a win if the office can find the right person, send the bill to the right address and keep the service history together. Start with one clean source, import a small batch, then deal with genuine duplicates—not everyone who happens to share a surname.

Both apps can merge customer records. The useful difference is how you get there: Housecall Pro groups possible duplicates for review; Jobber lets you choose a primary client and combine one duplicate at a time. Our pick is Jobber for carefully organizing billing clients and service properties; HCP is the grouped-cleanup alternative.

Customer imports and duplicate cleanup compared

Office task	Jobber	Housecall Pro
Bring in a customer file	CSV, TSV or PSV; admin import	File wizard supports CSV/TSV, Excel, XML and TXT; choose the worksheet
Keep the file manageable	Under 2.5 MB; about 5,000 rows is the maker’s reference, not a fixed row cap	Map the selected sheet’s columns, review validation errors, then submit
Separate billing from the job site	Separate billing and service-address fields; repeated client rows can create multiple properties	Separate billing and service-address fields; parent/child structures need preparation
Map extra information	Import text-based client custom fields; dropdown custom fields are excluded	Put supported information in mapped fields; unmapped fields are discarded
Find records to combine	Open the client or Clients list and choose Merge client	Manage duplicates groups possible matches by name, phone numbers or email; direct list selection also works
Choose the surviving details	Choose primary and secondary; primary values win conflicts, while contact lists combine	Review contact choices and the records selected for Merge Customers
Recover from a wrong merge	Merge cannot be undone	Merge cannot be undone
Bring in outside help	Admin-led self-service client import	Max includes access to the Data Import team; complex formatting has its own scope

The import details come from Jobber’s client-import guide and HCP’s import wizard. Native cleanup follows Jobber client merging and HCP duplicate management. HCP’s self-service help does not name a minimum subscription tier; its assisted import option is the Max feature.

Pick one source before importing anything

Choose the most up-to-date list and make it the import source. Export a backup before editing the working copy. Keep the old customer ID in your preparation sheet so the office can trace a record later.

On Jobber, start with QuickBooks when that is where the current customers live. Jobber recommends syncing those clients first, then importing only additional clients by CSV. Uploading the same customers again is an easy way to turn one list into two (Jobber import guidance).

On HCP, choose the current software file or QuickBooks—not both for the same records. HCP explicitly recommends one source of truth. You can connect QuickBooks afterward without importing its past data again (HCP customer-import options). Our QuickBooks sync comparison covers the ongoing handoff once the starting list is right.

Start with a ten-row import

Use this first-batch checklist before sending the full customer list through. The row counts are our suggested pilot, not a vendor limit or a tested import result.

Include in the first batch	Rows	What the office checks
An ordinary household and a business customer	2	Names, company status and the person who receives the invoice
One billing customer with two service addresses	2	One billing relationship, two correctly identified locations
Two different people with the same name	2	Separate customers remain separate
An existing customer who may already be in the app	1	Match the identity before merging anything
A contact with no service street address	1	Whether the intended job location exists afterward
A record with an extra field	1	The value lands in a supported field rather than disappearing
A record with a specific notification preference	1	The import preserves the customer’s actual preference

Open the resulting profiles and compare them with the working sheet. Then check billing address, service address, email, phone and the receiving contact. Use that same review on the larger batches. Do not turn every notification flag on just because a column accepts True.

Jobber: map the client and the property separately

Use an admin account in a normal browser window; Jobber says the client import does not run in incognito/private browsing.

1. Build the columns. Put the client’s name or company, contact details, service street and billing address in separate fields. Keep multiple emails and tags comma-separated.
2. Give each service property a row. Repeat the same client details and billing address, changing the service address. A blank Street field creates no property during import.
3. Keep custom fields simple. Text-based client custom fields can import; dropdown fields cannot. Map the extra column as the appropriate custom field rather than squeezing it into a street address.
4. Run Clients → More Actions → Import. Add the file, review each suggested mapping and inspect the values shown beside it.
5. Fix the red rows. Use the Invalid filter, correct the fields and then import. Split large files so each stays under 2.5 MB.
6. Review the client and its properties. The client is the billing relationship; the property is where the crew works.

For a new property on a client already in Jobber, export the client list first. Copy that client’s row, enter the new service address and leave the copied J-ID blank on the new-property row. Preserve the existing rows’ IDs. These steps follow the client-import instructions.

For a landlord or property manager, our multi-property comparison goes deeper on site contacts, reminders and invoices by unit.

Jobber: choose the primary client before merging

Merging is available on every Jobber plan from Jobber Online, not the mobile app. The operator needs the View, edit, and delete full client and property info permission.

Open the client or Clients list, choose More actions → Merge client, and select the second record. Make the record you want to keep the primary. Review the confirmation, then confirm the merge.

The primary’s values win conflicts. Empty fields can fill from the secondary, while emails, phone numbers, tags and list-type custom fields combine without duplicate entries. Jobs, quotes, invoices, properties and communications move into the primary client.

Keep the payment record in view. A secondary client’s card, other payment method or ACH consent never transfers. Where possible, make the record with the card on file the primary. The merge guide explains that consequence and the separate cleanup required in connected apps such as QuickBooks or Xero.

If two properties are also duplicates, merge them after the client cleanup. Jobber only merges properties belonging to the same client. Use merge, rather than deleting the duplicate property: deleting a property also deletes its related quotes and jobs (property guidance).

Alternative: Housecall Pro: map the sheet before submitting

HCP’s wizard is useful when your spreadsheet headings differ from its field names. It shows a preview while you decide which column belongs where.

1. Prepare names and IDs. Use a consistent customer identifier and keep billing and service addresses separate. HCP’s data-preparation guide lists required fields and formats.
2. Open Customers → Actions → Import. Choose the file source and the worksheet to import.
3. Review every mapping. A column left unmapped is discarded. Put useful extra information in an appropriate supported note or tag field before import.
4. Correct the invalid rows. Hover over the red value to see the problem, fix it and submit when the sheet is ready.
5. Wait for the completion email, then review the profiles. Compare the first batch with your sheet before importing the rest.

The wizard guide supports only one customer level during import. For a parent/child billing structure, prepare the child records on their own lines and set up the relationships in HCP afterward. Max customers can work with the Data Import team on customers, job history, equipment and the price book.

Alternative: Housecall Pro: work through the duplicate groups

Choose Customers → Actions → Manage duplicates. Expand a matching-detail group—name, mobile, home/work phone or email—then review the possible matches inside it. HCP flags candidates; you decide which are the same customer.

Select the genuine duplicates, choose Merge, review the contact information and finish with Merge Customers. You can also select multiple profiles directly from the Customers list and merge them there.

Tags, notes, addresses, emails and attachments combine. If any selected profile is marked Do not service, the resulting customer is marked that way too. Those rules come from the duplicate-management guide.

Make the identity decision before the final click. People can share a name. Match the phone, email and address before combining their profiles.

Finish with an office check, not just a row count

A completed progress bar is the start of the handoff. Open a household, a company and a multi-address customer, then verify the contact, property, history and notification settings the team will actually use. Review the connected accounting records separately after a merge.

Give one office person ownership of that final check. Use our technician-permissions comparison to keep customer cleanup with the right role, and the paper-to-app migration plan to stage the rest of the move.

For the subscription and workflow decision behind the import, compare Jobber vs Housecall Pro. Keep one current customer list the office can use to book, bill and find the next job.