How to Upload User Details in Bulk to Classroom


With ProProfs Training Maker, you can upload the details of multiple users to your classroom at the single click of a button. You can upload an entire class or employee roster list in one go into the system. This is an easy way to create hundreds of user accounts in a single step.


As shown in the image below, you can quickly upload user details such as their Email addresses, Names, Phone Numbers, IDs, Addresses, State, City, Country, and ZipCode using a sample spreadsheet we provide. You can also set up user Passwords, Status, and Expiration Dates and assign them to Groups.


User details Sheet


Note: Please make sure you do not delete any fields. You can leave them empty if you want because deleting a field will corrupt the document.


Most fields, such as name, email, password, etc., are self-explanatory. Below is an explanation of some advanced fields:


  • Status: In this field, you can add the status of users such as "active" (these users will be able to log in to Training Maker, access the courses, and view their reports) or "inactive" (users can no longer log in and do not have access to the account/content anymore. However, all their previous data & records remain intact for the instructor to view. This status can be used for past employees or students whose data is still needed). The third option is "delete." This is for users whose records you want to delete permanently.


  • Expiration Date: Keeping in mind the high churn of employees in construction companies or retail environments, we added the "expiration date." You can set a specific date for a user; on that date, the user's status will automatically change to inactive.


  • Groups: You can quickly assign the user to 5 groups from the sheet. 


Follow the steps below to bulk-upload user details to your classroom.


Step 1: On your ProProfs Training Maker dashboard, click Users.


Go to Users on the dashboard


Step 2: Click the + New User button to add users or learners to your classroom.


Go to New User


Step 3: In the following pop-up window, you can add multiple users and their details in bulk by using any of the three options - Gmail, Microsoft Live, and Microsoft Excel. Let's upload user details through Microsoft Excel.


Click Microsoft Excel to choose the excel sheet with user details to upload


Step 4: Download the sample file to see all the required fields to be filled as user details. In case you have your own excel file, make sure that it has the same fields/columns in the same order as in the downloaded sample file. For convenience, we recommend that you fill in the downloaded sample file, rename it as you like, and upload the same by clicking on the Upload button.


Click Upload User Button


Step 5: Click Done to finish uploading the file.


Click Done to finish adding users in bulk


That is all about uploading user details in bulk to ProProfs Training Maker.



Was this information helpful?
© 2005 - 2024 ProProfs
add chat to your website