The import rules
Where each file goes
In Jobber, open Clients, choose More Actions and import your file, then review the rows it marks as invalid. ServiceTitan doesn't have a self-service customer upload on the page we checked: your Implementation Manager gives you the templates and loads the completed file.
Common errors and their fixes
Jobber: clients with no name
Cause: Jobber needs a full name, a first name, a last name or a company name for every client. A row with only an address or a phone number is marked invalid.
Fix: Fill in at least one name column on every row, and use Company name for a business.
Jobber: headings it doesn't recognise
Cause: Headings that don't match one of Jobber's field names send you to a mapping step, or are offered as a new text custom field.
Fix: Use Jobber's own heading names, such as First name, Mobile Phone and Billing Street, and check on the mapping screen that every heading goes to the field you meant.
Jobber: a title other than Mr, Ms or Mrs
Cause: Title only accepts Mr, Ms or Mrs. Dr, Miss or Mx are marked invalid.
Fix: Use one of the three, or leave Title blank and put the rest in the first or last name.
Jobber: Is Company? not TRUE or FALSE
Cause: Jobber reads TRUE for a commercial client and FALSE for a residential one.
Fix: Enter TRUE or FALSE, with nothing else in the cell.
Jobber: a lead source of your own
Cause: Lead Source can only be Facebook, Google, Instagram, Flyer, Referral, Vehicle Wrap or Other. Custom lead sources can't be imported.
Fix: Map your own sources to the closest of the seven, and put the detail in Note or Tags.
Jobber: a malformed email, or several in one cell
Cause: An email must be in a proper format. Several addresses in one cell have to be separated by commas, and anything else is read as a malformed address.
Fix: One address per client, or addresses separated only by commas, with no names or notes in the cell.
Jobber: account balance that isn't a number
Cause: Account Balance must hold a number. Jobber accepts periods, commas or single quotes as separators, so words like paid or none are not read.
Fix: Enter the amount as a plain number, such as 150.00, and leave it blank if there is none. See stripping currency symbols.
Jobber: clients with no property
Cause: If the Street column is empty, Jobber creates the client but no property for them.
Fix: Fill in Street for every client who needs a job booked at an address, and check the other address columns on the same row.
Jobber: dropdown custom fields
Cause: Only text-based client custom fields can be imported. Dropdown custom fields can't be.
Fix: Import the value as text under a new heading, or add the dropdown field in Jobber and fill it in there.
Jobber: a file that is too big or the wrong type
Cause: Jobber takes CSV, TSV or PSV files under 2.5MB, roughly 5,000 rows. An Excel workbook, or a longer list, isn't accepted.
Fix: Save as CSV, and split a larger list across several files. See Excel to CSV.
Jobber: duplicates of clients already in QuickBooks
Cause: If Jobber is linked to QuickBooks, importing a list that is already there creates a second copy of each client.
Fix: Sync with QuickBooks first, as Jobber recommends, then import only the clients that aren't there yet.
Jobber: the import won't start
Cause: Only admin users can import clients, and the import can't run in a private or incognito browser window.
Fix: Sign in as an admin and use a normal browser window.
ServiceTitan: a required column is blank
Cause: The pink columns of the Customers template are required: Customer Name, Billing Street, Location Name and Location Street.
Fix: Fill them in on every row. If you have no separate location name, ask your Implementation Manager what to use.
ServiceTitan: a template that was rebuilt or renamed
Cause: ServiceTitan's page asks you to keep the file name, customers.xlsx, and to leave optional columns blank rather than removing them.
Fix: Paste your values under the headings of the template you were given, in its column order, instead of building your own sheet.
ZIP and postal codes lose their leading zero
Cause: A spreadsheet reads 02134 as a number and shows 2134. Both templates have ZIP or postal code columns for the billing address and the service location.
Fix: Format those columns as text before pasting. See leading zeros in CSV files.
ServiceTitan: problems found after the file is sent
Cause: ServiceTitan's page doesn't list import errors. The completed template goes to your Implementation Manager, so a mistake comes back as a question, not a red row on a screen.
Fix: Check the required columns, ZIP codes, phone numbers and emails before sending, and ask your Implementation Manager how SourceID is used and how to enter a customer with several locations.
After importing
In Jobber, use the Invalid filter on the review screen, fix those rows in your own file and import again, rather than editing each client by hand.
Open a few clients or customers afterwards and compare them with your file: the name, the property address, the billing address and the phone numbers. A shifted column shows up there before it spreads across a whole list.
Checklist before you import
Collecting customers from several branches?
Send each branch a form instead of a spreadsheet. The Jobber clients template uses Jobber's heading names and checks titles, lead sources, emails and balances as they are typed. For ServiceTitan, the ServiceTitan customers template keeps the template's column order and requires its pink columns.
Try the Jobber templateRelevant Templates
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Jobber or ServiceTitan. Jobber and ServiceTitan are trademarks of their owners. Import rules as described in their help centers, November 2026.