How to Find, Search, and Filter Customers (Customers)

Last updated October 16, 2026 · Admins and office staff

The Customers page is your customer directory: every customer account in one searchable, filterable list. From here you can look up any customer, jump into their profile, export your customer base to Excel or PDF, or kick off a mail merge on a filtered group. To add a new customer instead, see Create a Customer.

Customers list grid with search, sortable columns, and export options


Before you start

  • An operator account with access to the Customers menu.
  • Nothing else is required. The list simply shows whatever customers exist. If you haven’t added any yet, the getting-started guide at the top of the page walks you through the first steps and offers an Add Customer button.

Steps

  1. Go to Customers. You’ll see the customer list with the breadcrumb Home / Customers and an Add Customer button in the header.
  2. Search: click the search box in the grid’s toolbar and type any part of a name, address, email, or phone number. The list narrows as you search.
  3. Sort: click a column header to sort by it. Click again to reverse. You can sort by more than one column at a time.
  4. Filter: open a column’s menu (the icon on the column header) and choose Filter to show only rows matching a value, for example, only customers in a certain city or state. The column menu also lets you group by a column and show or hide columns.
  5. Open a customer: click the customer’s name, or the View button in the Actions column. Either takes you to that customer’s Customer Summary page.
  6. Shortcuts: right-click a row for View Customer, Create Job (opens Add work with the customer picked), Create Estimate and Schedule Appointment.

What the list shows

Column Shown by default
Customer (name) Yes
Status (Active, Prospect, Lead or Inactive) Yes
Address Yes
City Yes
State Yes
Email Yes
Phone Yes
Actions (View button) Yes
Zip No, turn on from the column menu
Address 2 No, turn on from the column menu
Customer ID No, turn on from the column menu

The list is paged at 20 customers per page by default; use the page-size picker at the bottom to switch to 40, 50, 75, or All.

Toolbar actions

  • Excel Export / PDF Export / CSV Export: download the current list as a spreadsheet, PDF (landscape) or CSV file.
  • Search: free-text search across the list.
  • Mail Merge: runs a mail merge on the customers matching your current filter (the whole filtered set, not just the visible page). See Mail Merge (Customers).
  • Save View: saves your current layout (columns, sorting, filters, page size) to your account, so the list opens that way next time.
  • Reset View: returns the list to the default layout.

What happens next

Opening a customer takes you to their Customer Summary, the hub for that customer’s contact info, job sites, jobs, visits, programs, estimates, invoices, contacts and notes. Exports download immediately in your browser.

Tips & best practices

  • Filter first, then mail merge. The Mail Merge toolbar button picks up your active filter, so filtering to (say) one city or status is how you target a merge.
  • Use column show/hide to build the view you actually work with (for example, turn on Zip if you route by ZIP code), then click Save View so it sticks.
  • Search matches partial text, so a few letters of a street name or the last 4 digits of a phone number are usually enough.

Troubleshooting

  • A customer you expect is not in the list. Check for an active search term or column filter and clear them, or click Reset View. Also confirm the customer was created (see Create a Customer); customers belonging to a different company login never appear.
  • “An error occurred while retrieving customers”. The list failed to load. Refresh the page; contact support if it persists.
  • Mail Merge says “No customers to merge”. Your current filter matches zero customers. Adjust the filter and try again.
  • Mail Merge is blocked at 5,000. A merge run is limited to 5,000 records. Narrow the filter and run it in batches.

Put it to work in your own account

14-day free trial · No credit card required