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 column(s) that contain the student name.  If you need to combine two columns (for example, if the first name is in column A and the last name is in column B), you can select them in the order that they should appear.  First, click the "Choose" button to enable the column selector buttons.  Next, click the first column that should be used for the student name.  Columns will be appended (with a space) for each column that was selected, in order.  To choose "<First Name> <Last Name>" in our example, you would first choose column A, then B.  When you've finished choosing the columns, click the blue "Done" button.

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.  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

2 Comments

  • 0
    Avatar
    Doug Moody

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

  • 0
    Avatar
    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!

Please sign in to leave a comment.
Powered by Zendesk