SkyPrep provides multiple bulk actions that can be used to manage your users en masse.

To access the bulk actions, click on Users & Groups, then on Users. Click on the Bulk User Management button.

Use the radio buttons to select the action you want to perform.

The following actions are available, and you can click on the links to jump to the relevant sections.

Add Users: Allows you to add multiple users to your platform at once.

Edit Users: Allows you to modify the information of existing users, as well as import previous course records in bulk.

Deactivate Users: Allows you to deactivate multiple users at once, preventing them from logging into the platform.

Reactivate Users: Allows you to reactivate multiple users at once, granting them access to the platform.

Delete Users: Allows you to permanently delete users from the platform, including all of their respective course records.

Recover Users: Allows you to recover deleted users and their course records, as long as they were deleted within the last 30 days.

To add users in bulk, click on the Download CSV Bulk Add Template button. This will download a CSV file that can be opened in Excel or another similar program. After filling it in click on the Select a file to upload button to upload it into SkyPrep, or drag-and-drop the file into the upload area. You can click on the V button for instructions at any time.

This is what the CSV document will look like:

Important: The first three columns: first_name, last_name, and email are mandatory. The user will not be added unless these columns are filled in.

email_notifications: Enter Yes/No or True/False — Determines whether a user will have Email Notifications turned on. Email notifications do not include the user's login information — they must be turned on separately.

send_login_info: Enter Yes/No or True/False — If enabled, the New Account Email will be sent upon user creation. This will include the users' usernames and passwords. If you do not enable Send Login Info, your user will not receive their login credentials and you will have to manually notify them. Enabling this option will automatically generate a password for the user unless a password is specified in the password column.

Everything else is optional:

You can add additional columns from your Custom Labels area by entering the Default Value for the field you want to include, while following the same column formatting. For example, if you want to add the Ca 1 field, enter it as ca_1.

The expected format for the columns is all lowercase, with underscores replacing spaces.

Once the file is uploaded, your platform will run a check to ensure that all rows are valid. If any are invalid, such as missing an email or an entered email is already in use, you'll be notified of both the error and the row in which it's found.

If all rows are valid, click on the OK button to continue the process.

Click Next to proceed to the next screen.

The following screen will allow you to double check your imported information prior to the users being added. If a user was added accidentally, you can click the Actions button to remove the row prior to the file being uploaded.

Once checked, click the Add Users button.

Double check that the number of users pending upload is what you expect, and if it is, click the Confirm button to finalize the file upload and begin the user creation process.

To edit your existing users, click on the Download CSV Bulk Edit Template button to download the pre-filled CSV that contains all of your existing users and their information. If you enable the Include courses in template button, the CSV will also include their enrolled courses and course-related statuses and dates, such as completion dates, which can be used to edit progresses in bulk.

The edited CSV can be uploaded into the platform using the Select a file to upload button, or by dragging-and-dropping the file into the area. Clicking on the V button will display instructions.

When editing the file, ensure that the skyprep_internal_id column is not edited or deleted — this column is mandatory and your edits will not work if it is changed or removed.

If necessary, you can add additional columns from your Custom Labels area by entering the Default Value for the field you want to include, while following the same column formatting. For example, if you want to add the Ca 1 field, enter it as ca_1.

The CSV can also be used to import course data for your users.

In empty columns, enter Course 1, Course 1 Status, Course 1 Date Started, iCourse 1 Date Finished, and Course 1 Expiration Date. If downloading the CSV with the Include courses in template option enabled, change the number accordingly, ensuring that the hasn't yet been used.

Note: The headers must use the "Course 1", "Course 2", etc. format. Do not substitute "Course X" with the actual name of the course in the headers or the import will not work.

If the course does not already exist in the platform, you will need to create the course first. You can simply go to the navigation bar and click Teaching, then Courses, then click Create Course and enter the name of the course. You do not need to add any items to the course if you do not plan to use it, as this can just serve as a placeholder.

If you do not intend to use this course, you can make the course inactive.

After verifying that all the courses from your users' historical records have already been added to the platform, you can return to the spreadsheet.

In the Course X column, enter the names of the course, exactly the way it's spelled in your platform.

In the Course X Status column, you will need to enter either not-enrolled for users that should not be enrolled in the course, not-started for users that are enrolled but have not started the course, passed for users that have passed, and failed for users that have failed the course.

In the Course X Date Started and the Course X Date Finished columns, enter the corresponding dates in dd/mm/yyyy format. For example, September 15th, 2025 would be entered as 15/09/2025.

If a user has not been enrolled in a course, leave these two columns blank, if they are enrolled but have not completed the course, only fill in the Course X Date Started column, and fill in both the Course X Date Started and the Course X Date Finished columns if they have finished the course.

Do the same for Course X Expiration Date if required. This will be used to calculate the date that users are re-enrolled into the course. For more information about re-enrollment, click here.

Once the file is uploaded, your platform will run a check to ensure that all rows are valid. If any are invalid, such as missing an email, you'll be notified of both the error and the row in which it's found.

If all rows are valid, click on the OK button to continue the process, then click on Next.

On the following screen, you'll see a preview of the users with the new information. You can click on Actions to remove any users that you do not want to update.

Once the data has been confirmed to be correct, click on Edit Users.

Confirm that the number shown matches the number of users that you are expecting to be edited, then click on Confirm.

You can deactivate accounts for users who should no longer be able to log into the platform whose information you want to retain.

Click on the Download CSV Bulk Deactivate Template button to download a CSV file. In the file, enter the emails or usernames of the accounts you want to disable.

The edited CSV can be uploaded into the platform using the Select a file to upload button, or by dragging-and-dropping the file into the area. Clicking on the V button will display instructions.

Alternatively, you can simply enter the emails of the users you want to disable in the text field, separated with commas, spaces, or new lines. Please note that you can only use this method with emails — non-email usernames are not supported and must be done via CSV instead.

After uploading the CSV, the platform will check to ensure that all rows are valid. If any are invalid, such as attempting to deactivate an account that does not exist, you'll be notified of both the error and the row in which it is found.

The same check will be performed for the text field after clicking outside of the text field after the emails have been entered.

Click on OK, then on Next.

On the next screen, you'll be able to confirm the users that are set to be disabled. You can use the Actions button to remove users from the list to prevent them from being disabled.

Click on Deactivate Users to proceed.

Ensure that the number of users set to be disabled matches the expected number, then click on Confirm to finalize the deactivation process.

You can reactivate users in bulk by using the checkboxes beside their name, or at the top to select all users.

Reactivated users will be granted access to the platform and will be able to log in.

After selecting the users, click on the Next button.

On the next page, confirm the list of users that will be reactivated. You can remove users from this list by clicking on the Actions button.

Once confirmed, click on the Reactivate Users button.

Confirm that the number shown matches the expected number of users you want to reactivate, then click on Confirm.

Users can be deleted from your platform in bulk. Please keep in mind that this process will also delete their course history. Deleting a user is permanent and cannot be undone after 30 days have passed since their deletion.

To delete users, click on the Download CSV Bulk Delete Template button to download a CSV file. In the file, enter the emails or usernames of the accounts you want to disable.

The edited CSV can be uploaded into the platform using the Select a file to upload button, or by dragging-and-dropping the file into the area. Clicking on the V button will display instructions.

Alternatively, you can simply enter the emails of the users you want to delete in the text field, separated with commas, spaces, or new lines. Please note that you can only use this method with emails — non-email usernames are not supported and must be done via CSV instead.

Click on the Next button to continue the deletion process.

The following page will display all of the users that are going to be deleted. You can click on the Actions button to remove users who should not be deleted.

Once you've checked the users, click on Delete Users.

Confirm that the number of pending deletions matches the expected number of users. If it does, enter delete X users in the text field, replacing X with the specified number of users. Click on Confirm Delete to delete the users.

If you need to recover users deleted within the past 30 days, select the users using the checkboxes beside their names. You can use the top checkbox to select all users.

Click on Next to continue.

The next page will display the users that are set to be recovered. Confirm that it is correct — users that should not be recovered can be removed by clicking on the Actions button.

Click Recover Users to continue.

Confirm that the displayed number of users matches the number of users you want to recover. If it does, click on Confirm to finalize the recovery process.