Migrate from Spreadsheets in Minutes, Not Months

Import Customers (businesses, with their contacts and addresses handled as part of the same workbook), Addresses (service sites), Products, Assets (equipment), Jobs (historical work), and Service Contracts. Each entity has dedicated import handling with field mapping and validation rules.

Your CSV has "Company Name"? Opscel maps it to "Business Name". "Tel" maps to "Phone Number". "Postcode" maps to "Postal Code". Smart matching detects common variations—no manual column renaming required.

Uploading 500 customers but 50 already exist? System detects duplicates by email or business name, shows conflicts, lets you skip or update. No accidental duplicate customers clogging your database.

Importing addresses or historical jobs that belong to a business? System links each row to an existing customer by business name or email — no manual ID mapping spreadsheets. Contacts import as part of the same customer workbook, alongside the business and its addresses. Asset imports don't use address matching — you select the site once in the UI before uploading, and every row imports to it.

Upload CSV, system validates all rows, shows errors (missing required fields, invalid email format, unmatched parent references). Fix errors in CSV, re-upload. Import succeeds only when all rows valid.

Importing 1200 assets? Progress bar shows import status—"Processing row 487 of 1200". Large imports run in background. Get notified when complete. No browser tab freezing for 10 minutes.

Each row imports as its own transaction, so one bad row doesn't block the rest of the file. A dedicated error report lists exactly which rows failed and why, so you can fix just those and re-upload rather than starting over.

Download a CSV template for customers, addresses, products, assets, jobs, or service contracts. Template includes all supported columns, example data, field descriptions. Fill template, upload—guaranteed column match.

Have custom columns that don't auto-match? Manual mapping interface lets you drag "Client Name" to "Business Name", "Mobile" to "Phone Number". For asset imports specifically, the device-type mapping you build is saved as a reusable profile tied to the customer, so it's offered again on their next import.

Data import is a role permission, not a tier gate — Admins, Contract Managers and Super Admins can import customers, addresses, products, jobs and service contracts on any plan. Asset import is the one exception: it specifically requires the Business (or higher) plan, alongside the rest of Asset Management.