Adding Students via CSV Uploader
Updated over a week ago

The following information will help you add students through the CSV uploader within the Manage Users area of the Learning A-Z Account Management site.

The CSV Upload process is separated into 4 steps: Preparing, Uploading, Reviewing, and Importing. You can also find frequently asked questions in the blue box on the right and receive chat support by clicking on the button at the bottom right of your screen.

The CSV Import/bulk import process can be used for adding, removing, and updating students, but it should primarily be used for adding large numbers of students at one time. Editing existing students, removing students no longer at your school, or changing a student's grade will likely be easier to complete within the Student table in Manage Users.

In order to assign students to classroom rosters, you will need to update the teacher roster first.

To add a new student:

  1. Click the Manage Users tab and select the Students tab.

3. On the right, find and click the blue button, Add Student, and click on it.

4. To bulk upload, click the blue button to Add Multiple via CSV Import.

Preparing

As you think about preparing your file, you’ll want to have access to your student data. We recommend you have your student data downloaded or available to cross-reference from your own Student Information System (SIS).

  1. Download Current Data:

    a. If you’re coming in for the first time, you’ll see the button “Download Template”. This will give you the proper format and column headers to get started with the CSV file.

b. If you’re a returning user, you will see the button “Download Current Students” to see the latest version of your rostered students.

Regardless of which button is available, download the file so you can make all your additions or edits in the proper format.

2. Start making additions and edits to the file. The file and the number of fields to complete will vary depending on the number of products you have access to. To learn more about the fields, you can click on CSV File Structure Details and read a description for each of the columns in the table.

To complete the file, you’ll need to enter information in each of the required fields: Teacher Username, Classroom Name, Student Username, Password, Grade, and Deleted y/n (last column). Depending on the products the students will have access to, you’ll complete the Reading Level or grade span appropriate for each student per product. The LAZ Student ID is generated by Learning A-Z when a new student is created.

Uploading

3. Once you have made the required edits or additions, you’ll want to save the file, still using the CSV format. Make sure to save it to a place on your computer where you can find it easily in the next step.

4. Click Next at the bottom right of the page, then click Upload CSV to upload the student CSV. You’ll need to find and add the CSV file you saved, and then you’ll see it processing the upload.

Reviewing

5. Click Next or the review link to review the data from your file.

If your file is not accepted, it will show the error message below. You can try to re-upload the file after ensuring that the file has a .csv extension and includes a header row.

If the upload is successful, it will show the notification below.

From the review area, you can see a small tab on the left that indicates whether it’s a user who has been updated, added, or removed.

This step also allows you to see the issues in your data, as indicated by the little red triangle. You can see exactly which user is affected and what the issue is. To get more detail, you can hover over the issue and see what the error statement is.

You’ll need to cross-reference the issues listed here on the screen with your CSV file so you can make the necessary revisions to the proper fields for the proper students. Again, save any changes with a new file name so it can be re-uploaded.

Of note, you can also change the view of this page, whether you want to see only the issues (the default selection) or you want to see all the data from your file to review something else that may not be an issue.

If you don’t have any issues in the file or you’ve cleaned up the issues, you’ll see a screen that says “Great Job. No issues were found.”

Importing

6. From this point, you can click “Complete Import”, Re-upload a new file, or of course you can “Cancel” if you aren’t ready to continue the process.

If you are ready to complete the import, you have the choice of whether you want to send the teacher emails about the changes to their rosters. If you do, select this check box.

Click Complete Import.

You can watch the progress of your import.

Congratulations. You have completed the student import process.

Did this answer your question?