Customers

Import customers from a spreadsheet, QuickBooks, Jobber, or Housecall Pro

Upload a CSV or Excel export, check the column matches, review duplicates and errors, and import in one pass. Failed rows can be downloaded, fixed, and re-uploaded.

Owner/AdminCustomers & Leads5 minutesUpdated Sep 23, 2026Current instructions
Still need help?

Before you start

  • A CSV, XLSX, or XLS file with a header row (up to 10 MB, 5,000 rows).

What you'll do

Customers → Customer List → Import walks through four steps: Upload, Map columns, Review, Import. Nothing is created until you press the final Import button, so you can back out at any point.

Do this

  1. 1

    1 · Upload

    Pick where the data comes from (Generic CSV / Excel, QuickBooks, Jobber, Housecall Pro, ServiceTitan) so column names auto-match, then drag the file in or Choose a file. Download a sample template shows the columns Zentive understands.

  2. 2

    2 · Map columns

    Each column in your file is matched to a Zentive field: First name, Last name, Email, Phone, Street address, Unit, City, State, ZIP, Company, Notes, or Full address (split automatically). Fields marked * are required. Pick Don't import to skip a column.

  3. 3

    3 · Review

    Three tabs: Ready to import, Duplicates (email or phone already exists; skipped by default), and Errors (missing required fields, bad email). Fix errors in the file and Change file, or continue without them.

  4. 4

    4 · Import

    Press Import N customers. Large files take a minute; keep the tab open. The result shows Added, Skipped, and Failed with a Download failed rows (CSV) button so you can correct and re-upload only those.

Match your columns
Review before importing

What happens to imported customers

They are created as Active with the address geocoded for routing. No invitation is sent by the importer; send portal invites later from each customer card, or leave customers on pay-by-link only. Employees have their own importer under Schedule → Employees → Add Employee → Import, and leads under Lead Management → Import.

Was this helpful?

Still need help?

Contact Zentive support

Include your business name, account email, what you were trying to do, what happened instead, and a screenshot if possible. For billing, sync, or login issues, include the exact error message if shown.

Replies by emailLogin, billing, sync, and setup help
Email support

Keep going