Data import

Bring customers in from a CSV or Excel file, or from ServiceTitan’s Customers and Locations reports. Running the same file again skips what was already brought in.

From ServiceTitan: pick the Customers report first, then the Locations report (.xlsx, as exported). Everything on the files comes in as it is. A customer’s address is kept as its billing address; only the Locations report makes service locations, so a customer with no location there has none here. Running totals and memberships are not brought in.

Any other file: columns name (required), customer_id, type, contact, phone, email, address, address 2, city, state, zip, access notes. Download a sample CSV or sample Excel file. Excel files use the first sheet.