CSV Template

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's heading namesTitles and lead sources checkedTry it free

Jobber Clients

Try the template with up to 3 rows

What You'll Collect

Name & company

String
*Required

First 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

Phone
*Required

Main, home, work, mobile and fax phone numbers and one text-message number, checked as they are typed.

Email

String
*Required

A proper email address, with several separated by commas.

Property address

String
*Required

Street, city, state, country and a postal code that keeps its leading zero. Without a street, Jobber creates no property.

Billing address

String
*Required

A separate billing street, city, state, country and postal code, for clients billed elsewhere.

Lead source & tags

Enum
*Required

One 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 form

Jobber'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.

Need a CSV form of your own?

Create a custom Import Builder form with your own fields, validation and row limits.

Get started
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Jobber. Jobber is a trademark of its owner. Fields as described in Jobber's help center, November 2026.