---
title: "Export Customers, Jobs, and Service Locations"
description: "Download your customers, jobs, or service locations as a CSV file that opens in Excel or Google Sheets: what is included, what columns you get, and who can export."
canonical: https://www.poolfounder.com/help/export-customers
source: https://www.poolfounder.com/help/export-customers
---

# Export customers, jobs, and service locations to CSV or Excel

Source: https://www.poolfounder.com/help/export-customers

> Download your customers, jobs, or service locations as a CSV file that opens in Excel or Google Sheets: what is included, what columns you get, and who can export.

_Export Customers, Jobs, and Service Locations_

1.  [Help Center](https://www.poolfounder.com/help)

3.  [Customers & Leads](https://www.poolfounder.com/help#customers)

5.  Export customers, jobs, and service locations to CSV or Excel

Download your customers, jobs, or service locations as a CSV file that opens in Excel or Google Sheets: what is included, what columns you get, and who can export.

Updated September 26, 2026

## 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.

On this page

1.  [Export customers](#section-0)
2.  [What's in the file](#section-1)
3.  [Export jobs](#section-2)
4.  [Export service locations](#section-3)
5.  [Who can export](#section-4)

## Export customers

1.  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.
2.  2Click **More** (top right of the page, next to Add Customer) and choose **Export CSV**.
3.  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](https://www.poolfounder.com/help/import-your-customers). 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

1.  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.
2.  2Click **More** (top right, next to **Add Job**), then **Export CSV**.
3.  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

1.  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.
2.  2Click **More** (top right, next to **Add Service Location**), then **Export CSV**.
3.  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](https://www.poolfounder.com/help/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.

## Related articles

[

Customers & LeadsAdd and manage customers

](https://www.poolfounder.com/help/add-and-manage-customers)[

Customers & LeadsService locations and pools

](https://www.poolfounder.com/help/service-locations-and-pools)[

Getting StartedImport your customers

](https://www.poolfounder.com/help/import-your-customers)[

Team & PermissionsRoles and permissions

](https://www.poolfounder.com/help/roles-and-permissions)

Still stuck? Email [support@poolfounder.com](mailto:support@poolfounder.com) or ask George from your dashboard — he can walk you through it.

## Make Monday easier than last Monday.

30-day free trial. No credit card required. Cancel anytime.

[Start free trial](https://www.poolfounder.com/signup) [Book a call with Anthony](https://www.poolfounder.com/book-a-call)
