Update records and handle duplicates in an import
When Admins and Team Owners import a CSV (comma-separated values) file, enrola can update records you already have as well as add new ones. Before anything is imported, the Check before importing step shows what each row will do and holds back rows that look like duplicates. It comes after Review, where you fix or leave out rows with errors. For the import itself, see Import records from a CSV file.
Add new records, or update existing ones
On the first Import page, What to do has two choices:
- Add new records (the default). Every row adds a record. A row that names a record already in enrola is skipped.
- Add new records and update matching ones. A row that names a record updates it. A row that names nothing adds a record.
A row names a record by its enrola ID, which an export gives in its Id column, or by its External ID. For Learners, the Unique Learner Number (ULN) works too. To update records, the easiest way is to export them, change the file and import it back.
When a row updates a record:
- Only the columns you import change. An empty cell never clears a value.
- Labels, sectors and Supervisors in the row are added to the ones the record has.
- An Application stays on its Opportunity. A Status column moves it to that status, without sending emails.
- An Opportunity keeps its opportunity type and addresses.
Check before importing

The top line counts the rows, for example "1,240 to add · 32 to update · 6 possible duplicates (6 skipped) · 0 errors". Below it, you can open each group to see its rows by row number. Updated records and possible duplicates link to the record in enrola.
If you left out rows on Review, the line also counts them, for example "2 rows with errors (left out) · 1 more row left out by you". A list shows each row with errors: the column, what is in the file and why it failed. To fix them, or to include rows again, select Back to Review. See Review and fix problems in an import.
A row is a possible duplicate, and is skipped, in these cases:
| Record | Possible duplicate when the row has |
|---|---|
| Application | The same email as an Application on the same Opportunity. |
| Contact | The same email as a Contact at the same employer. |
| Employer | The same company number, or the same name, as an Employer. |
| Any | The same details as an earlier row of the file, by the rules above, or the same External ID (ULN for Learners). |
Opportunities and Learners are matched only by their enrola ID, External ID or ULN.
To add a possible duplicate anyway, tick Add anyway on its row, then select Update the counts. Some rows have no tick box:
- "it is already in enrola": the row names an existing record and you chose Add new records. To change that record, import again and choose Add new records and update matching ones.
- A row that names the same record or External ID as an earlier row.
If the import updates records, tick I understand this changes existing… before you select the import button, which then reads, for example, Import, and update 32 existing applications. Without the tick, enrola asks you to tick it first. If no row adds or updates a record, the button can't be selected. If only possible duplicates are left, tick any you want to add.
Important. Undo can delete records an import added, but it doesn't undo updates: enrola doesn't keep the values an update replaced. Try an update with a few rows first. See See past imports and undo one.