TalentLMS lets you import historical data into your current portal. This allows you to bring in past training records for courses and learning paths that may have been completed externally or update existing completion information. You can do this for one user or in bulk for multiple users and courses using a single upload.

Here’s how in three easy steps:

1. Sign in to your TalentLMS account as an Administrator, and if they don’t already exist, create the users and the courses or learning paths that correspond to the data you want to import.

2. Go to Account & Settings > Import - Export (1).

3. Browse your files to locate and select the import file, or drag and drop the file into the upload area (2).

Supported file types are: XLS, XLSX, and CSV. Maximum file size is 1MB.

How to create your import file:

A. Historical course completion data

The available columns are:
Usertocourses, Course, EnrolledOnDate, CompletionDate, Status, Score. The mandatory ones for the import to work are Usertocourses and Course, in which case, users will be simply added to the courses.

• The Usertocourses column corresponds to the Username. From a system perspective, the Username serves as the primary identifier for users on the platform, so if a user with the same login exists, their information will be updated. Make sure that the login is the first column in your import file. 
• The Course column corresponds to the course title.
• The EnrolledOnDate and CompletionDate columns correspond to the date of enrollment and the date of completion for your user. The date must be written according to the date format of your portal as defined under Account & Settings > Portal, below the Locale section. The cells in these columns need to follow a “text” format in Excel, not “date” or other. Check this Microsoft resource on cell formats to learn more.
• The Status column corresponds to the completion status of the course for your user. It can be set to not_attempted or completed.
• The Score column corresponds to the course score of the course for your user. It can be given any whole number value between 0 and 100.

B. Historical learning path completion data

The available columns are:
Usertolearningpaths, Learningpath, EnrolledOnDate, CompletionDate, Status, Score. The mandatory ones for the import to work are Usertolearningpaths and Learningpath, in which case, users will simply be added to the learning paths.

• The Usertolearningpaths column corresponds to the Username. From a system perspective, the Username serves as the primary identifier for users on the platform, so if a user with the same login exists, their information will be updated. Make sure that the login is the first column in your import file.

• The Learningpath column corresponds to the learning path title.

• The EnrolledOnDate and CompletionDate columns correspond to the date of enrollment and the date of completion for your user. 

• The Status column corresponds to the completion status of the learning path for your user. It can be set to not_attempted or completed.

• The Score column corresponds to the learning path score for your user. It can be given any whole number value between 0 and 100.