How to Upload Multiple User Details to an Online Classroom

ProProfs Quiz Maker allows you to upload multiple users to your classroom in one go using a spreadsheet. This helps you quickly create user accounts, assign groups, and manage large batches efficiently.

As shown in the image below, you can quickly upload user details such as their Emails, Names, Phone Numbers, Ids, Addresses, State, City, Country, and Zip codes using a sample spreadsheet we provide. Along with this, you can also set up user Passwords, Statuses, and Expiration Dates and assign them to Groups.

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 Quiz Maker, access the quizzes, 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, and on that date, the user's status will automatically be changed to inactive.

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

Benefits:

• Bulk User Creation: Add hundreds of users at once using a single file.

• Saves Time: Eliminates the need to add users manually.

• Flexible Data Management: Include user details, assign groups, and set account settings in one step.

Example:

An HR team receives a spreadsheet of new hires from recruitment and directly uploads it to the classroom. During the upload, they assign users to departments (groups), set login credentials, and define expiration dates for probation training—completing the entire onboarding setup in one step.

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

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

Step 2: Click + Add User to add users or learners to your classroom.

Step 3: In the Add Users dialog, switch to Import (1). You can add multiple users and their details in bulk by using any of the following options - Gmail and Microsoft Excel. Let's upload user details through Microsoft Excel.

• Click the radio button next to Microsoft Excel (2) and download the respective sample file (3) 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.

• After adding user details to the sample file, rename it as you like, and upload the same file by clicking the Upload (4) button.

Step 4: Click Done to finish uploading the file.

Below is the sample updated user list.