Import your customers

Import from a spreadsheet or screenshot

1. 1Open the Import Wizard (or click Bulk Import on the Customers page).
2. 2Upload your CSV or Excel file, or a screenshot of your old software's customer list — AI extracts the data and matches your columns to Pool Founder fields automatically.
3. 3Review everything in the Review & edit spreadsheet. It works like Excel: click any cell to fix a typo, paste in values from Excel or Google Sheets, or drag the fill handle to copy a value down a column. Emails and phone numbers that don't look right are tinted red.
4. 4Uncheck any row you don't want — unchecked rows are left out of the import. Rows still missing required info (a name, or an address for locations) are grayed out and skipped; fix them in the sheet or in the Needs your attention list below it.
5. 5Click Import N of M rows in the bar above the sheet. Every checked, valid row imports; the rest are skipped, never imported incomplete.

How rows become customers, locations, and jobs

• Rows in the same file that share an email (or phone, or name when contact info is missing) import as one customer with multiple service locations — so exports with one row per pool (like Skimmer's) work as-is.
• Extra email columns become the customer's additional emails; extra info columns (gate codes, secondary phones, lead source) are kept as notes.
• Phone and email are optional — customers import fine without them. Contact info is only needed later for emailed invoices and the customer portal, and can be added any time.
• Addresses in one column are fine, with or without commas ("123 Main St Naples FL 34102" works).
• Files that only have addresses (like a route-assignment export with no customer names) still work — each pool imports as a customer named after its address, renameable later.
• When a row has a service plan filled in (Template, Day, Tech, Frequency, and Rate columns), import also creates the recurring service on that pool — no separate bulk setup step for those rows.

Rows already in Pool Founder (duplicates)

Before you import, the review sheet flags rows that match someone already in your book. Re-uploading the same file is safe — already-imported rows are recognized and left out by default.

• Email or phone match — the row gets a Status dropdown with three choices: Skip · exists (the default — the customer is not re-created), Add pools to existing (attach this row's service locations to the matched customer), or Import as new (create a second customer with the same contact info).
• Service address match — if the pool address already exists, the row shows Exists and is always skipped. There is no override for address duplicates.
• A blue banner above the sheet counts how many rows match customers already in Pool Founder. After import, the result screen reports how many rows were skipped and how many existing customers had pools added.
• Your Status choices are saved with the import — refreshing the page mid-review keeps them, along with every edit you have made to the sheet.
• Import as new creates the customer, but a pool address that already exists is still not duplicated. If every address on the row was already in Pool Founder, the new customer ends up with no pools and the result screen says so — move the pool over from the existing customer, or use Add pools to existing instead.

Service columns: jobs in the same import

Route exports usually carry the whole service arrangement next to each pool — price, how often, which day, and which technician. Pool Founder maps those columns into the review spreadsheet's Template, Tech, Day, Frequency, and Rate columns. Fill them (or bulk-fill with the bar above the sheet), then import — customers, pools, and recurring services are created together.

• The review spreadsheet shows those service columns so you can correct a rate or day before importing, or set the same template / day / tech on many rows at once.
• Columns recognised from the file: service price, charge type (flat monthly vs per visit), frequency, service day, assigned technician, route name, and whether chemicals are billed separately.
• You need at least one service plan first (the Jobs step in guided setup, or Job Templates later). Pick which plan each pool gets in the Template column.
• Technicians are matched by name — the full name, ignoring middle initials and suffixes, or just a first or last name when only one person on your team has it. Nicknames and small misspellings ("Mikey" for Mike Rivers) are matched too. Anyone the file names who nobody on your team answers to is left on "Any tech" rather than guessed at, and two possible people (two Nicks) is left blank on purpose.
• Anything the file was ambiguous about is left blank rather than guessed. "Twice a month" is not the same as every other week, so Pool Founder leaves the frequency for you to pick.
• The Frequency column is visits per week (Weekly up to 5x/week). A file that says "Biweekly", "Every other week", or monthly leaves Frequency blank and highlighted rather than importing as Weekly — every-other-week is set by the job template you pick (its own frequency) or on the route afterwards. The value from your file is still saved with the pool either way.
• Pools that import without a service assignment still need one before they can go on a route — the result screen offers Set up service, which opens Add Service in Bulk.

Switching from Skimmer

Skimmer's customer export lets you choose which columns to include, so before you download, add the columns that carry your service arrangement — that's the difference between re-typing every pool and just confirming it.

• Include the Rate and Rate Type columns. Skimmer's Rate Type reads like "Per Month With Chemicals" or "Per Visit" — Pool Founder reads it as both the charge type (flat monthly vs per visit) and whether chemicals are already in the price, so it fills those in for you.
• Include the Service Day column if your export offers it, so each pool arrives with its day already set.
• Everything else Skimmer carries — gate codes, dog names, tags, location notes, secondary phones and emails — comes across automatically as notes and contact info.

Switching from other software (Jobber, Pool Brain, Paythepoolman, Pool Office Manager, Housecall Pro…)

Any customer or route report you can export to CSV or Excel will import — the AI column mapper reads whatever layout your old software produces, so you don't need a specific layout. If you can't find an export at all, a screenshot or photo of a customer list or route sheet works too.

• Must-have columns: customer name and service address — those create the customers and pools.
• Worth including if your export offers them: price, how it's charged (monthly vs per visit), service day, visit frequency, and assigned technician — these fill the service columns so recurring services are created in the same import.
• One row per pool is fine — rows sharing an email (or phone, or name) import as one customer with multiple service locations.

Banners and warnings you might see

• Rows already in Pool Founder — the blue banner above the spreadsheet counts rows that match an existing customer by email, phone, or service address. Use the Status column on contact matches to Skip · exists, Add pools to existing, or Import as new. Address matches always stay on Exists and are skipped.
• "Data extracted from screenshot" — when you upload a screenshot, a blue banner names the source software AI detected and asks you to review the extracted data carefully before importing.
• The Needs your attention list shows at most 30 fix-it cards. If more rows are missing the same info, a note counts the rest — when a whole column is empty, it's faster to fix the file and re-upload. Unfixed rows are simply skipped, never imported broken.
• "Rate limit reached" — AI file analysis is limited to 10 uploads per rolling 24 hours. If you hit it, wait and try again; the final import itself is not limited.
• "No pool addresses came through" — shown after an import that created customers but zero service locations. Jobs can't be scheduled until each pool has an address, so either re-import with the address column mapped (Import Another File) or add a service location to each customer.

Import from QuickBooks

Click Connect QuickBooks on the Customers page (a one-click sign-in with Intuit). Once connected, use Import from QuickBooks on the Customers page and pick which customers to bring over. The review list has a spreadsheet view (the grid icon next to the search box) where you can fix names, emails, phone numbers, and addresses in place before importing — changes save as you type. Sync settings live on the QuickBooks page — see QuickBooks sync.

QuickBooks marks every customer you have ever invoiced as active, so a full import can bring in hundreds of old one-time customers. After the import finishes, Pool Founder checks QuickBooks for billing activity: customers with no invoices or sales receipts in the last 12 months and no open balance are flagged as inactive, and the completion screen offers to archive them in one click. Archiving is local to Pool Founder only — their QuickBooks records are not changed — and any archived customer can be unarchived later.

After the import: anything still missing a service

When every row had a service assigned in the review sheet, you can go straight to routes. Pools that still need a service show a card on the result screen — use Add Service in Bulk to schedule a plan with per-row rate, day, tech, and visits per week. The Jobs page also shows a banner counting pools with no service scheduled that links straight there. QuickBooks imports always land in this follow-up (they bring customers and locations only).

Frequently asked questions

Related articles