An Administrator can import training history by default. For a Manager or Training Coordinator, Import CSV is off by default. An Administrator must grant it, and the role must also have Assign & schedule and Record completions. To create missing people or courses, they also need Manage employees or Manage courses, respectively. Staff assigned to specific locations can import only within those locations.
Choose a sheet
Use a .xlsx workbook or a .csv file up to 10 MB. Choose one sheet per import, with at most 2,000 data rows, 300 columns and 300 distinct courses. In a log, each completion takes one row, so a log can hold at most 2,000 completions. A matrix can contain up to 5,000 training records across its rows.
The data sent for matching and saving must each fit within 900 KiB. A batch matched to existing people and courses can reach that limit before 5,000 records. Notes also increase the size of each record. One import can create up to 500 people and 200 courses, with up to 50 new departments. Split a larger sheet into smaller files. If you only have a roster, use the employee CSV import.
A matrix has one row per person and one column per course. These fictional rows use the dates the training took place.
| Employee name | Bench setup | Gauge care |
|---|---|---|
| Nell Vale | 2026-10-05 | 2026-10-08 |
| Remy Pike | 2026-10-06 | 2026-10-09 |
A training log has one row per completion. A person can appear on several rows.
| Employee name | Course | Completion date |
|---|---|---|
| Nell Vale | Bench setup | 2026-10-05 |
| Nell Vale | Gauge care | 2026-10-08 |
Set course timing before importing
In the course catalog, turn on Repeats to show Repeat every (days) and enter the interval. For certificates that expire, turn on Requires certificate to show Valid for (days) and enter the validity period. If you import a course list first, the course CSV template calls these columns recur_interval_days and certificate_valid_days.
When creating a course during the history import, you can set the same rules at Match. Both start off. If you set certificate validity after saving the import, earlier imported completions keep their original expiry, including a blank expiry. Turning on recurrence later does not create a renewal for those completions.
Match and preview the records
- Open Import in the sidebar. On Spreadsheet imports, choose Import a spreadsheet. From Training Matrix, the shortcut is Import from a spreadsheet.
- Select Choose a spreadsheet, pick the sheet, then select Continue. Check the heading row and the sheet shape. Answer Yes to Is each row one person? for both a matrix with one person per row and a log with one completion per row. For a matrix, indicate whether the cells hold dates or statuses.
- At Map columns, check which columns identify people, courses and completion dates. At Dates, confirm the date order for each ambiguous column. To continue, enter the actual completion date for every column you keep mapped as Training status. Every completion marked by a symbol in that column uses that date. If people trained on different days, use their individual dates in a date matrix or log. If a column has no training to import, such as a column containing only
N/A, go back to Map columns and set it to Ignore. When you return to Dates, check the dates for the columns you kept. - At Match, check people by employee number, email or name. Choose the right person if names match more than once. Check each course against its code or title. Choose an existing match, create a missing entry or skip it. For a status matrix, confirm what symbols such as a check mark mean.
- Select Continue to preview. Use Only problems or Only warnings to inspect individual cells. You can go back to change a match or download the preview report. The preview saves no records.
If a completion date is missing, invalid or in the future, check it against the original record. An expiry date alone cannot establish when training took place. Duplicate completions are skipped. A calculated status such as “overdue” is ignored. For an existing open assignment, use Record Completion to mark it complete.
Save the import
Select Continue to confirm. Check the counts and acknowledge any warnings, then select the Import button showing the number of records. The import saves the accepted records and any new people and courses they need. A qualifying latest completion on a recurring course can create the next assignment. If the renewal date has already passed, the assignment is due on the Catch-up date, initially 30 days from today. To keep the original due date, at Match set Renewals that are already overdue to Due on the date the rule gives. Select Open the matrix to check the result, or download the result report as CSV.
The import does not attach evidence files or sign off competency assessments. It sends no email when you save. Due or expired training can appear in the next scheduled alerts.
Undo an import
For 30 days after saving, an Administrator can open Import, choose Undo this import for the batch and review what will be removed or kept. Select Confirm undo to remove eligible records. Undo keeps edited records, records with attachments or other links, completed renewals and records whose course has a newly activated version. New people with other history or portal access are kept too. Courses created by the import stay in the catalog.