Customers and locations,ready for ServiceTitan's customers template.
Collect customers and their service locations in the 18 columns of ServiceTitan's Customers template, with the required columns filled in and contact details checked before the file goes to your Implementation Manager.
ServiceTitan Customers
Try the template with up to 3 rows
What You'll Collect
Customer name
StringThe customer, as it should read in ServiceTitan. Required in the template.
Billing address
StringBilling street (required), city, state and a ZIP that keeps its leading zero.
Service location
StringLocation name and location street (both required), plus city, state and ZIP.
Phone details
PhonePhone1, a memo and name for it, mobile and fax, checked as they are typed.
One email address, checked as it is typed.
Notes & SourceID
StringFree-text notes, and an ID from your old system if you have one.
Need more than three rows?
Collect every customer'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 customers back in one file instead of a different spreadsheet from every source.
Create your own formServiceTitan's columns
All 18 columns of the Customers template in its order, so the CSV pastes straight in.
Required columns enforced
Customer Name, Billing Street, Location Name and Location Street are required, so none is left blank.
Your own fields
Add a service plan, a gate code or a preferred day to your own form.
Up to 1,000 rows
A whole customer list in one file.
How it works
From the customer list to ServiceTitan in three steps.
01
Collect
Import your customer list from a spreadsheet or your old system, or send the form to each branch.
02
Complete
One customer location per row. Missing required values, bad emails and phone numbers are highlighted.
03
Download and send
Download the CSV, paste its rows under the headings of customers.xlsx, and send the file to your Implementation Manager.
Why use a form?
The file goes to a person, not an import screen.
ServiceTitan provides the Customers template through your Implementation Manager, and you send the completed customers.xlsx back. A blank required column or a ZIP code that lost its zero is found after the file has gone, and costs a round trip.
A form checks the required columns and contact details before the file is sent.
Blank required columns
Customer Name, Billing Street, Location Name and Location Street are marked required in the template.
ZIP codes losing their zero
Billing Zip and Location Zip are kept as text, so 02134 stays 02134.
A template that was rebuilt
ServiceTitan asks you to keep the file name customers.xlsx and its columns. Paste values under its headings instead of building your own sheet.
ServiceTitan customers import template
How ServiceTitan's Customers template is laid out
ServiceTitan, field service software for contractors and home service companies, brings customers in during onboarding. It supplies a Customers template through your Implementation Manager. You fill it in, keep the file name customers.xlsx, and send it back.
The template has 18 columns: Customer Name, a billing address (Billing Street, City, State and Zip), a service location (Location Name, Street, City, State and Zip), phone details (Phone1, Phone Memo, Phone Name, Mobile and Fax), Email, Notes and SourceID. Required columns are pink in the template: Customer Name, Billing Street, Location Name and Location Street. Optional columns can be left blank.
ServiceTitan's page doesn't give formats for phone numbers or ZIP codes, or explain SourceID, so ask your Implementation Manager about those. This template keeps ZIP codes as text and checks the phone numbers and email address for obvious mistakes.
This template follows the column order, so the CSV you download pastes straight under the headings. It covers the Customers template only. Importing clients into Jobber instead? Use the Jobber clients template.
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. Importing into Jobber instead? Use the Jobber clients template.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started