Your lists, in a spreadsheet
The Customers, Jobs, and Service Locations pages each have Export CSV (in the More menu at the top right of each page) that downloads the list you are looking at as a spreadsheet file. Use it for a mailing list, a backup, a price review, a hand-off to your bookkeeper, or anything else you do in Excel.
Export customers
- 1Go to Customers and set up the list you want. Search, + Area (zip code or city), Filter by tags, the + Filter chips (Texting, Billing, Service, Address), + Monthly, Sort, and the Active / Archived tab all carry into the file.
- 2Click More (top right of the page, next to Add Customer) and choose Export CSV.
- 3The file downloads as customers-YYYY-MM-DD.csv (customers-archived-YYYY-MM-DD.csv from the archived view) and opens in Excel, Google Sheets, or Numbers.
You get every customer matching the current filters, not just the rows scrolled into view. On the Active tab (the default), archived customers are left out. On the Archived tab, the file holds only archived customers. There is no single file with active and archived customers together: export each view.
What's in the file
One row per customer, with these columns: First Name, Last Name, Company, Email, Phone, Additional Emails, Service Street, Service Street 2, Service City, Service State, Service Zip, Other Service Addresses, Billing Address, Tags, Parent Account, Billing (On AutoPay, Saved method, AutoPay off, No payment method, or Billed to parent account; blank for roles that cannot view invoices), Notes, Status (Active or Archived), and Customer Since (the date the customer was added).
The first service location is split into columns, so the file can go straight back through Bulk Import. A customer with more than one location has the rest in Other Service Addresses, separated by |.
The customer export is customer records only. It does not include pool or equipment details, jobs, visit history, invoices, balances, or saved cards. Jobs and service locations have their own exports, below.
Export jobs
- 1Go to Jobs → View all jobs and set up the list you want. The tab you are on (All, Recurring, Work orders, Not started, Archived), the search box and everything under Filters (Work Order Status, Technician, Route, Created dates, Tasks) carry into the file.
- 2Click More (top right, next to Add Job), then Export CSV.
- 3The file downloads as jobs-YYYY-MM-DD.csv (jobs-archived-YYYY-MM-DD.csv from the Archived tab).
One row per job, with these columns: Customer, Job Name, Type (Maintenance or Work Order), Status, Service Street, Service Street 2, Service City, Service State, Service Zip, Rate (in dollars, per visit for maintenance), Frequency, Route, Day, Technician, Scheduled Date (work orders), Minutes at Stop, Due Start, Due End, Notes, Archived, and Created. A job on more than one route lists each route, day, and technician separated by ;.
Status matches the badges in the All jobs list: Scheduled, Unscheduled, or Suspended for maintenance; Not Started, Scheduled, In Progress, Done, Invoiced, or Paid for work orders. The file does not include visit history, completed visit photos, line items, or invoices.
Export service locations
- 1Go to Service Locations and set up the list you want. Search, Filter by tags, the + Equipment filter, and the Active / Archived tab carry into the file.
- 2Click More (top right, next to Add Service Location), then Export CSV.
- 3The file downloads as service-locations-YYYY-MM-DD.csv (service-locations-archived-YYYY-MM-DD.csv from the archived view).
One row per location, with these columns: Street, Street 2, City, State, Zip, Customer, Tags (location tags), Location Notes, Status (Active or Archived), and Added. It does not include bodies of water, gallons, equipment, on-site contacts, or photos.
Someone without View location notes (gate codes, access) gets the file with Location Notes blank.
Who can export
The Customers button needs the Export customer list (CSV) permission. Owners, Administrators, Office Managers, and Bookkeepers have it by default; the built-in Technician and Viewer roles do not.
The Jobs and Service Locations buttons need the Export jobs and service locations (CSV) permission. Owners, Administrators, and Office Managers have it by default; the built-in Bookkeeper, Technician, and Viewer roles do not. Without it the button is not shown. See Roles and permissions to give either permission to a custom role.
Someone without View customer contact info (phone, email) gets the customer file with the Email, Phone, and Additional Emails columns blank. The jobs and service locations files have no phone or email columns.
Frequently asked questions
Can I export my customers to Excel?
Yes. On the Customers page, click More (top right), then Export CSV. The file opens directly in Excel or Google Sheets.
Does the export include archived customers?
Only from the Archived tab, and then it holds only archived customers. From the Active tab (the default), archived customers are left out.
Can I export just some of my customers?
Yes. The export follows the search box and every filter on the Customers page (zip or city, tags, and the Texting, Billing, Service, Address and Monthly filters), so narrow the list first, then click More → Export CSV.
Can I export my jobs or service locations?
Yes. The All jobs list (Jobs → View all jobs) and the Service Locations page each have Export CSV in their More menu, which downloads every job or location matching the current search and filters.
Can I export invoices or visit history?
Not from these buttons: they export customer, job, and location records. Payroll and deposit breakdowns have their own Export CSV buttons.