Help Center › Getting started
Import customers, sites and contacts
Bring customers, sites and contacts in from a CSV or Excel file, review matches and errors first, and undo an import if needed.
You'll bring customers, sites and contacts in from a spreadsheet, check everything before it's saved, and undo the import if needed.
Who can do this: Owners and Admins, with two-step verification. A custom role needs both Import data and Change leads, customers and opportunities. Once you've verified, Imports is in the sidebar under Admin.
What you can import
Choose one kind per file:
- Customers: one row per customer, optionally with its main contact.
- Sites: one row per service location, with the customer it belongs to and a site contact.
- Contacts: one row per person, with the customer they work for.
Sites and contacts files can include the customer's columns; Oprilio finds or creates that customer.
Use a CSV file or an Excel workbook (.xlsx); from Excel, only the first sheet's values are read. A file can have up to 20,000 rows and 10 MB.
Upload and match the columns
- Open Imports and choose what the file contains.
- Drop the file on the page or choose it, then select Upload and preview.
- For each column, keep the suggested field, choose another, or choose Ignore this column.
- Select Check the rows.
A customers file needs Customer name, a sites file needs Site street and Site city, and a contacts file needs a name. If your old system has its own IDs, map them, so a later import finds the same records again. To reuse your choices, select Save changes if it shows, then name the mapping and select Save mapping; later files with the same columns get it on their own.
Review before importing
Nothing is saved yet. The review counts lines ready, with errors and with warnings, and records that are new, matched or still to decide.
- Exact matches, such as the same customer name and billing address or the same contact e-mail, update the existing record. Under Matched records, choose fill in empty fields only or replace with the file's values.
- Possible duplicates, such as the same customer name with another address, wait for you. Choose to update the existing record, Different · create new or Skip line. Undecided: create new and Undecided: skip settle the rest at once.
- Lines with errors, such as a site without a street or city, aren't imported; lines with warnings, such as an invalid phone number kept as written, are. Download as CSV gives you the lines with errors to fix and import as a new file.
Once every possible duplicate is decided, select the import button, for example Import 120 lines. It runs in the background; you can leave the page. Only one import or undo runs at a time.
Results
Results counts the lines processed, created, updated, skipped and failed. If someone edits a matched record after the check, that line fails instead of overwriting their edit.
Undo an import
On the finished import, select Preview undo to see what will be reversed and what will be kept because it changed or came into use since. Then select Undo the import: it removes the records the import created and restores the fields it changed.
Undo has no time limit. Oprilio removes the uploaded file and the values read from it 30 days after the import finishes, but the results stay and Undo still works.
On a phone you can follow progress and results; uploading, matching and reviewing need a computer.
Related
Updated October 6, 2026