Clients and properties,ready for Jobber's client import.
Collect clients under the heading names Jobber's client import recognises, with names, phone numbers, addresses, titles and lead sources checked before the CSV goes into Clients.
Jobber Clients
Try the template with up to 3 rows
What You'll Collect
Name & company
StringFirst and last name, or a company name, with a title of Mr, Ms or Mrs and Is Company? set to TRUE or FALSE.
Contact details
PhoneMain, home, work, mobile and fax phone numbers and one text-message number, checked as they are typed.
A proper email address, with several separated by commas.
Property address
StringStreet, city, state, country and a postal code that keeps its leading zero. Without a street, Jobber creates no property.
Billing address
StringA separate billing street, city, state, country and postal code, for clients billed elsewhere.
Lead source & tags
EnumOne of Facebook, Google, Instagram, Flyer, Referral, Vehicle Wrap or Other, plus tags and a note.
Need more than three rows?
Collect every client's details.
The free template is limited to three rows so you can try the workflow. Create your own form to send to each branch or office, and get clients back in one file instead of a different spreadsheet from every source.
Create your own formJobber's heading names
Headings Jobber recognises, so its mapping step has little left to fix.
Checked as they type
Titles, Is Company? values, lead sources, phone numbers and balances are checked as they are entered.
Your own fields
Add a gate code, a service plan or a preferred day to your own form.
Up to 1,000 rows
Well inside Jobber's limit of about 5,000 rows per file.
How it works
From the client list to Jobber in three steps.
01
Collect
Import your client list from a spreadsheet or your old system, or send the form to each branch.
02
Complete
One client per row. Titles, lead sources and balances that Jobber would reject are highlighted.
03
Download and import
Download the CSV and import it from Clients, More Actions. Check the headings on the mapping screen, then fix any rows Jobber marks Invalid.
Why use a form?
Jobber marks bad rows red, one at a time.
Jobber lists invalid rows on its review screen: a title that isn't Mr, Ms or Mrs, a lead source it doesn't know, a balance that isn't a number, a malformed email or a client with no name. Each fix means going back to the spreadsheet and importing again.
A form flags those values as they are typed, so the file reaches Jobber ready to import.
Lead sources of your own
Jobber only takes Facebook, Google, Instagram, Flyer, Referral, Vehicle Wrap or Other. Custom lead sources can't be imported.
Clients with no property
Without a Street, Jobber creates the client but no property. Street is easy to miss in a long file.
Emails in the wrong shape
Several addresses must be separated by commas. Anything else is read as a malformed email.
Jobber clients import template
How Jobber imports clients
Jobber, field service software for home service businesses, imports clients from a spreadsheet. You start in Clients, choose More Actions and import your file. CSV, TSV and PSV files work, up to 2.5MB, which is roughly 5,000 rows. Only admins can import, and not from a private browsing window.
You don't have to follow a fixed template. Jobber matches each of your headings to one of its fields on a mapping screen, and offers any heading it doesn't recognise as a new text custom field. Using its own heading names, such as First name, Mobile Phone and Billing Street, means the mapping is mostly done for you.
A client needs a name: a full name, a first name, a last name or a company name. A Title must be Mr, Ms or Mrs, Is Company? is TRUE for a commercial client and FALSE for a residential one, and Lead Source must be one of Facebook, Google, Instagram, Flyer, Referral, Vehicle Wrap or Other. Without a Street, no property is created, and only text custom fields can be imported, not dropdown ones.
This template uses Jobber's heading names and checks those values as they are typed. It leaves out the reminder and follow-up columns and the Archived column, because Jobber's help doesn't say what values they take, and J_ID, which is only for clients exported from Jobber. If you use QuickBooks, Jobber recommends syncing it first so clients aren't duplicated.
How-To Guides
Related Templates
Read Jobber and ServiceTitan customer import errors for every rule and its fix, or see Import Builder for field services. Moving to ServiceTitan instead? Use the ServiceTitan customers template.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started