Bulk Import Your Existing Accounts
Fill in one template and OpsVara brings your whole list over in one pass, with anyone you no longer service already archived.
Updated November 12, 2026
Moving to OpsVara from spreadsheets or another system starts with your customer list. You fill one CSV template with your customers and their service sites, send it to your OpsVara onboarding contact, and they import it for you in one pass: customers, contacts, billing addresses, sites with their map pins, and details such as pool volume or acreage. Customers you no longer service can come along too, already archived, so their history is kept without cluttering your active lists.
Service contracts are a separate, second pass once your customers are in. See After the import.
Before you start
- Export your customer list from your current system, or gather it in a spreadsheet.
- Every customer needs a contact first name, last name, and email address. The import stops on any customer missing one.
- Every site needs a full street address, city, two-letter state, and ZIP code. OpsVara pins each site on the map from its address.
Fill and send the template
Download the template for your industry
Open Settings
Setup Wizard and go to the Bulk Import step. Click Download Template. The file carries the site types and site detail columns for your industry, plus three sample rows you can overwrite. The step also lists every column with a short description. Add one row per site
Each row is one site. For a customer with two sites, add two rows, repeat the customer columns exactly, and change only the site columns. Rows with the same customer name and contact email become one customer with several sites.
Mark former customers inactive
In the status column, put
inactiveon every row for a customer you no longer service. Leave it blank or putactivefor everyone else. See The status column.Save as CSV and send it
Save the file as CSV and send it to your OpsVara onboarding contact. They run the import and let you know when your customers are in.
The columns
Required on every row
| Column | What to put in it |
|---|---|
customer_name | The account name, such as a person, household, HOA, or business. Up to 255 characters. |
contact_first_name, contact_last_name | The main contact's name. |
contact_email | The main contact's email. Must be a valid address. |
billing_address_line1, billing_city | The billing street and city. |
billing_state | Two-letter US state code, such as FL. |
billing_zip | Five-digit ZIP, or ZIP+4. |
site_name | What you call the site, such as "Backyard Pool" or "Cimarron Ponds". |
site_type | The kind of site. See the table below for your industry's values. |
site_address_line1, site_city, site_state, site_zip | The service address, same formats as billing. |
| Industry | Accepted site_type values |
|---|---|
| Pool service | inground, above_ground, spa, commercial, other |
| Aquatic weed and lake management | pond, lake, fountain_site, other |
| Lawn care | residential, commercial, common_area, other |
| Other field service | residential, commercial, other |
Use other for a site that fits none of your industry's types, such as a stream or decorative fountain a pool company services.
Optional, about the customer
| Column | What it does |
|---|---|
contact_phone | The main contact's phone. |
billing_address_line2, billing_country | Suite or unit, and country. OpsVara keeps one street line, so the suite is added to the end of the billing street: 100 Shore Dr, Suite 12. |
tags | Comma-separated labels, such as hoa, net 30. Useful for finding groups of customers later. |
notes | Notes on the customer record. |
active_years | Every year the customer was active, comma-separated, such as 2022, 2023, 2025. |
customer_since | The first year they were a customer, such as 2019. It is used even when active_years starts later, so a customer since 2009 with invoices only from 2024 keeps 2009. |
last_active_year | The most recent year they were active. Used together with customer_since when active_years is blank. |
status | active or inactive. Blank means active. |
customer_type | residential, commercial, hoa, municipal, hotel, or golf_course (only the types your industry offers), in any capitalization. Golf Course, golf and country club also mean golf_course. Blank means commercial when any of the customer's sites is a commercial or spa site, and residential otherwise. Every row of one customer that states a type must agree. |
Optional, about the site
| Column | What it does |
|---|---|
site_address_line2, site_country | Unit or gate line, added to the end of the site's street, and country. |
same_as_billing | true makes the site use the billing address. Fill the site address columns anyway, because they are still required. |
site_notes | Notes on the site, such as gate codes or access instructions. |
site_tags | Comma-separated labels on the site itself, such as permit required, gate code. Up to 20 per site, each up to 40 characters. |
| Site details | Pool tenants get site_pool_volume_gallons, site_pool_sanitizer (chlorine, salt, or automated), and site_pool_surface (plaster, vinyl, or fiberglass). Lawn and aquatic tenants get site_acreage, in acres, not square feet. Aquatic tenants also get depth, alkalinity, fountain model, irrigation, the lakeshore permit columns, site_lake (see Link lake sites to their lake), and site_lake_sizing (band or area; lake rows only — see How a lake site is measured). Every industry gets site_pricing_tier, from 1 to 5. |
The template you download lists only the detail columns for your industry. Any detail you leave blank can be filled in on the site later.
Link lake sites to their lake
Aquatic companies can link each lake or pond site to its lake in OpsVara's lake catalog as part of the import, the same link you make by picking the lake on a site. Put the lake in the site_lake column. The site page then shows it under Catalog lake, and the site takes the lake's county. The site keeps the name and address from your file.
- Write the lake's catalog ID or its name. In Minnesota the ID is the DNR lake number, such as
27011700.27-0117-00works too, and so does an ID that lost its leading zero in a spreadsheet. - The catalog spells most lakes without the word "Lake".
Christmas Lake,Lake Christmasandchristmasall match the catalog'sChristmas. - Lake names repeat within a state. When a name matches more than one lake, the import stops and lists them with their counties and IDs. Write the ID instead, or add the county in parentheses:
Christmas (Hennepin). - The lake must be in the site's state. When
same_as_billingistrue, that is the billing state. - Fill it only on
lakeandpondrows. Leave it blank for a site whose lake you are not sure of; you can link the lake on the site later.
How a lake site is measured
On a lake row, site_lake_sizing is band or area. Shoreline band (band) sizes the site from approved lakeshore × approved lakeward (site_approved_lakeshore_ft × site_approved_offshore_ft). Treatment area (area) is an offshore bay, channel, or open water sized by site_acreage — measure it on the map later, or type the acres on the site. site_requested_offshore_ft is Requested lakeshore (ft): feet of lakeshore the owner asked to have treated (along the shore, not out from it).
Leave site_lake_sizing blank and the import treats the row as a shoreline band, except when the row has acreage and neither approved lakeshore nor approved lakeward — that combination is an offshore area, because that is the only way acreage can land on a lake without a band.
On the site form after import, How is this site measured? is the same choice: Shoreline band or Treatment area. The site page labels a treatment-area lake Treatment area.
The status column
Put inactive in the status column for customers you no longer service. They are imported archived, the same state as clicking Archive on a customer. The customer and every one of their sites are archived together.
Archived customers:
- Are hidden from Directories
Customers until you open Filters and set Status to Archived or All. - Are left out of campaign audiences, which start at Active customers, unless a campaign deliberately targets Archived customers.
- Cannot have their sites put under a service contract until the sites are activated again.
- Keep their contacts, addresses, notes, tags, and active years, so a win-back campaign can pick out, for example, customers active in 2024 but not since, using Customer years (optional) on the campaign audience.
The status column accepts active and inactive, in any capitalization. archived is also accepted as a way to write inactive. Anything else, such as Cancelled, stops the import with a message naming the row, so an unexpected value is never imported as active by mistake. When a customer has several rows, every row that states a status must agree. Blank rows follow the row that states one.
Bringing a former customer back
Open Directories
What happens to your file
Your onboarding contact runs four checks before anything is created:
- Review. Every customer is listed with its sites. Values the import is unsure of are highlighted, and customers marked inactive show Archived on import.
- Duplicates. A customer that already exists in your account is flagged, and your contact either skips the row or creates it anyway.
- Map pins. Every site is placed on the map from its address. An address that cannot be found is pinned by hand. Nothing is imported until every site has a pin.
- Confirm. The final summary shows how many customers and sites will be created, and how many will arrive archived.
A file in the template's format is read exactly as written. A CSV in another layout, or a PDF, is read by AI instead. That works, but every value it is unsure of has to be checked by hand, so the template is faster and more accurate.
After the import
- Open Directories
Customers and spot-check a few customers and their sites. - Set Status to Archived to confirm your former customers arrived there.
- Customers with a blank
customer_typearrive as residential, or as commercial when one of their sites is a commercial or spa site. Change Customer type on the edit form for any that came in wrong. - Service contracts come next, as a second import for your active customers. Archived customers are not offered contracts, which is why former customers need no contract rows.
- The contract file carries a price per month (
monthly_rate) or per visit (visit_rate), the first month OpsVara bills (first_billing_month), whether the invoice on the 1st covers the month just finished (bill_last_month; avisit_raterow on a monthly schedule always does), and an optional visit schedule per row (visit_dayswithevery_n_weeks, orvisits_per_week/visits_per_month). Rows for the same customer, work type, and season merge into one contract that covers every listed site at its own rate — how a property manager's homes become one plan and one monthly invoice. Each imported contract gets one Service Scope row named for the work type. It bills at every site because it is the agreement itself: its How it bills reads A rate (Per month, Applies to Every site) for amonthly_rateon a monthly schedule, and Part of the plan price otherwise (Billed as: Included under Advanced Billing). Avisit_raterow is A rate at Per visit with Applies to Only sites that chose it (Billed as: Add-on), because it bills each completed visit. A merged contract's row priced site by site is Billed as: Add-on too. See Bill the Month Just Finished and Bill Per Visit on a Monthly Invoice.
Troubleshooting
| Message or problem | Fix |
|---|---|
| A row says a required column is missing | Fill that column on that row. Every customer needs a first name, last name, and email, and every site a full address. |
billing_state or site_state must be a 2-letter US state code | Replace state names with codes, such as FL instead of Florida. |
| ZIP must be 5 or 9 digits | Spreadsheets drop leading zeros from ZIP codes. Format the column as text and retype the ZIP. |
site_type must be one of your industry's values | Use a value from the table above, spelled exactly. |
| status must be active or inactive | Change the value to active or inactive, or clear it. |
| status disagrees with an earlier row | One customer has rows marked both active and inactive. Pick one status for the customer. |
| One customer became two | The customer name or contact email differs between their rows. Make both identical on every row. |
site_lake matches several lakes | Write the lake's ID from the list in the message, or add the county in parentheses, such as Christmas (Hennepin). |
site_lake matches no lake | Check the spelling against the catalog, or use the lake's ID. Check that site_state is the lake's state. |
site_lake links a lake or pond site | The row is a fountain or other site. Clear site_lake, or fix site_type. |
| A tag is longer than 40 characters, or a site has more than 20 tags | Shorten the tag or move the extra detail to site_notes. |
Frequently asked questions
Can I send an Excel file?
Save it as CSV first. The import reads CSV files, which is what the template is, and PDFs. Any spreadsheet program can save a sheet as CSV, and the column headers carry over unchanged.
What if my file is an export from my old software and does not match the template?
Send it anyway. A CSV with other column names, or a PDF, is read by AI and every value it is unsure of is highlighted for review before anything is created. It is slower and less exact than the template, so copying your data into the template columns is still the better route when you can.
Two of my customers share one email address. Will they be merged?
No. Rows only become one customer when both the customer name and the contact email match. Customers under one property manager can share the manager's email as long as their names differ.
Why import former customers at all?
Their history stays with you. Imported inactive, they are archived from day one, so they stay out of your directory and your campaigns, but you can still find them, see the years they were active, and bring any of them back with one click when they return.
A customer I imported as inactive came back. How do I restore them?
Open Directories → Customers, set Status to Archived, and click Activate customer on their row. Their sites come back with them. For customers imported before October 7, 2026, the sites stay archived; open Directories → Sites, set the status filter to Archived, and click Activate site on each of their sites.
Are imported customers residential or commercial?
Whatever the customer_type column says. When it is blank, the customer is imported as commercial if any of their sites is a commercial or spa site, and as residential otherwise. Change Customer type on the customer's edit form for any that came in wrong.
Can the import link my lake sites to the right lake?
Yes, for aquatic companies. Put the lake's catalog ID (in Minnesota, the DNR lake number) or its name in the site_lake column of each lake or pond row. The site is created linked to that lake. A name that matches more than one lake in the site's state stops the import and lists the lakes, so a site is never linked to the wrong one.
How do I import an offshore lake as a treatment area?
On a lake row, put area in site_lake_sizing and the acres in site_acreage. Blank site_lake_sizing is a shoreline band, or a treatment area when the row has acreage and no approved lakeshore (site_approved_lakeshore_ft) or lakeward (site_approved_offshore_ft).