Add students from a spreadsheet

1. 1Open the Roster Manager (select Settings in a planner, then Manage rosters) and add or find the roster.
2. 2Select Upload a spreadsheet and choose your file: CSV, tab-separated text or Excel (.xlsx). It says Reading roster… while it works.
3. 3Check the names. If they're wrong, select Undo after Not right? to take them all back, or remove one with the x beside it. Then select Save changes at the bottom of the window.

Your spreadsheet can have any columns. The app finds your students by the heading above their names, such as Name, Student, or First Name and Last Name, in any of the app's languages, and joins first and last names into one name. Without a heading, it uses the first column that looks like names. Heading rows, empty rows and numbers in front of names are skipped, names already on the roster aren't added again, and new names go at the end of the list.

Not sure how to lay out the file? Download our sample, as CSV or Excel, type your students' first and last names under its two headings, and upload it. You'll also find it under What should the file look like?

If the names come out wrong

Select What should the file look like? beside the upload button. A file works best with one student per row, and the names in one column, or first and last names in two, under a heading such as Name. If you see Couldn't find any student names in that file, add a heading such as Name above the names and upload it again, or type the names in.