How to update learners in bulk

How to update learners in bulk


How to update learner details in bulk

There are two ways to update several learners at once. For a quick change to primary or secondary tutors, use the learner table. For other details, or lots of different changes at once, use the update export.

​

Changing tutors in the learner table
  1. Go to Users and open the learner table.
  2. Filter or select the learners you want to change, for example by filtering to one tutor’s caseload.
  3. Tick the learners, then select Bulk actions.
  4. Choose Edit primary tutor or Edit secondary tutor, and select the new tutor.
  5. Select Update. All the selected learners are updated at once.

​

Updating learners with the update export
  1. Go to Users and open the learner table.
  2. Filter to the learners you want to update. Turn on Include learners past course end date if you need them.
  3. Click Export and choose the update export.
  4. Open the file and make your changes, for example end dates, tutors or provision.
  5. Save the file as a CSV.
  6. Go to Upload learners and choose Bulk update.
  7. Upload your file and confirm.

​

Changing tutors in the CSV file
The file has a column for the primary tutor and a column for secondary tutors.

To reassign one tutor’s learners to another, use find and replace in your spreadsheet. Search for the current tutor’s name or email in the tutor column and replace it with the new tutor’s. This updates every row for that tutor at once. Check the replacement only affects the tutor column you meant to change.

To change tutors for individual learners, overwrite the name or email in that learner’s row.

Only change the rows you need to. You can delete rows for learners you aren’t updating, which makes the file easier to check before uploading. 

 multiple secondary tutors are entered in one cell,  separated by a semicolon

​

Tips
  • Don’t change the column headings or the Learner ID column. The platform uses Learner ID to match each row to the right learner.
  • Keep staff names or emails exactly as they appear on the platform. A small difference, such as a spelling or extra space, will stop the row from updating.
  • The tutor must already have a staff account on the platform before you can assign them.
  • The Tags column is left empty on purpose. Tags you add are added to the learner. Existing tags aren’t removed.
  • Save as CSV, not Excel format, or the file won’t upload.
  • Check Import history afterwards for any rows that couldn’t be updated.