For detailed changes across many users at once, export your enrolments to a spreadsheet, edit them, and import the file back. Unlike the other methods, this lets you make mixed changes in one go — enrol some users, unenrol others, all in the same file.
Step-by-step instructions
⚠ The steps below depend on how you log in — check yours before you start.
Look at the web address you use to log in:
Log in at atlas-hub.co.uk? Open the atlas-hub.co.uk section below.
Log in at app.ihasco.co.uk? Open the app.ihasco.co.uk section below.
If you log in at atlas-hub.co.uk
If you log in at atlas-hub.co.uk
Step 1: Export your enrolments (in Atlas)
Go to Enrolments.
Click Export enrolments in the top-right corner and select For bulk user management.
Click Export to download the enrolment data file.
Note: Depending on how much enrolment data you have, the file can take a little while to generate. When it's ready, a link will be sent to your email and you'll find it under Jobs complete at the top. For more on exporting a CSV of enrolment statuses, see the full guide.
Step 2: Update the spreadsheet
The spreadsheet is laid out as a grid: users are listed down the side, with courses running across the top. Each cell where a user and course meet shows that user's enrolment status for that course:
n = not enrolled
y = enrolled
To update enrolments, change n to y (to enrol) or y to n (to unenrol) as needed. When you're done, save the file and close it.
Note: Don't make any other changes in this file — it isn't suitable for adding new users or updating user information.
Step 3: Import the file back (in Atlas)
Go to Enrolments.
Click Add/update.
On the Spreadsheet tab, click Select CSV file to upload and choose the file you updated.
Click Start upload.
On the Map columns to fields page, you don't need to change anything — scroll to the bottom and click Confirm column mapping to finish.
Interactive walkthrough
If you log in at app.ihasco.co.uk
If you log in at app.ihasco.co.uk
Step 1: Export your enrolments (in Atlas)
Click Users in the menu.
Click Export enrolments in the top-right corner and select For bulk user management.
Click Export to download the enrolment data file.
Note: Depending on how much enrolment data you have, the file can take a little while to generate. When it's ready, a link will be sent to your email and you'll find it under Jobs complete at the top. For more on exporting a CSV of enrolment statuses, see the full guide.
Step 2: Update the spreadsheet
The spreadsheet is laid out as a grid: users are listed down the side, with courses running across the top. Each cell where a user and course meet shows that user's enrolment status for that course:
n = not enrolled
y = enrolled
To update enrolments, change n to y (to enrol) or y to n (to unenrol) as needed. When you're done, save the file and close it.
Note: Don't make any other changes in this file — it isn't suitable for adding new users or updating user information.
Step 3: Import the file back (in Atlas)
Go to Users and click Add/update.
On the Spreadsheet tab, click Select CSV file to upload and choose the file you updated.
Click Start upload.
On the Map columns to fields page, you don't need to change anything — scroll to the bottom and click Confirm column mapping to finish.
Other ways to change enrolments
To apply one action to a group, see How do I enrol or unenrol a group of users at once?
To change the enrolments of a single person, see How do I enrol or unenrol an individual user?
FAQ
When should I use the spreadsheet instead of the on-screen options?
When should I use the spreadsheet instead of the on-screen options?
Use it when you need to make different changes for different users at the same time, or you're updating a large number of enrolments at once.
Which export type should I choose?
Which export type should I choose?
Choose For bulk user management. The "For offline analysis" option has extra columns for reporting and isn't designed for importing back.
What do "y" and "n" mean in the file?
What do "y" and "n" mean in the file?
"y" means the user is enrolled on that course, and "n" means they're not. Change the letter to update the enrolment.
Do I need to adjust the column mapping when I import?
Do I need to adjust the column mapping when I import?
No. If you exported the file from Atlas, the columns already match — just scroll down and click Confirm column mapping.