Importing Students from a CSV File

In addition to adding student names to your classroom one at a time, you can also create a new classroom from a CSV (comma separated value) file.  If you are working from Microsoft Excel or another spreadsheet software, you can choose .csv when saving your file to create a csv file.  

To use this tool, login to the Teacher Control Center and click the Manage -> Classrooms.  At the bottom of this page click the "Create New Classroom" button and choose "Import from CSV".

Step 1) Select the CSV file to upload.  If your CSV file contains column headers, check the box to skip the first row of the file.  In most cases your CSV file columns will be separated by commas, but if you know that a different delimiter has been used, you can specify this here.  When you are done, click the blue "Next" button.

Step 2) The first few lines from the CSV file are displayed here as a preview, and the columns are labeled "A", "B", "C", etc.  

If you want to use your own student ids, change the setting to "Yes" to choose which column contains the student id.  When you check "Yes", the "Choose" button is revealed.  Click this button to enable the column selector buttons, then click the column header to mark this column as the student id column.  Next, click the blue "Done" button.  If you don't want to use your own student ids, they will be automatically generated.  

Next you will select the columns that contain the students first and last names.  The process is the same: first click the "Choose" button, then click the column button that maps to this column.  First name is required, last name is optional.

When you've finished mapping columns, click the blue "Next" button to continue.

Step 3) In this step you'll give your classroom a name (required) and review the entire list of students that will be created.  The classroom name defaults to the name of the CSV file but you can edit it here.  If you need to make changes, click the "Back" button (beside Finish).  When you're ready to create the class, click the "Finish" button.


Potential Problems:

If you are using custom student ids, they must be unique among all students in your entire group - including students in archived classrooms.  If the student id is already used, the classroom will not be able to be created.

If the file you upload cannot be parsed, it may not be a CSV file or may be improperly formatted.  You cannot upload an Excel (xls, xlsx) file using this tool.

Have more questions? Submit a request


  • 0
    Doug Moody

    Please provide a graphic of a sample CSV file. This will help a lot. Thanks

  • 0
    Jody Mickey

    Hi Doug, I'm afraid a picture of a CSV file will be confusing.  You can't open MS Word for example and type what you would see in the graphic and end up with a CSV file - it will include all kinds of metadata and formatting data.

    Here's a great article on how to create a CSV file.  In most cases you'll already have your student list in an Excel spreadsheet, so the part about saving from Excel will be particularly useful.

    Hope this helps!

    Edited by Jody Mickey
Please sign in to leave a comment.
Powered by Zendesk