One way for a campus admin to load their campus's students into ALL In Learning is to upload a CSV file, making class creation easier for teachers. For information on more automatic options, like Google Classroom, Aware, and Clever, which can sync from most Student Management Systems and have more benefits, see this article.
Please Note: If you allow Google Classroom syncing on your campus you will need to include student emails in your CSV import in order to avoid duplicating students. The Google Classroom sync does not share student IDs with ALL In Learning, so we check for duplicated students using the Google Classroom email addresses. If these aren't included in your CSV import, then teachers syncing with Google Classroom will create duplicate students.
Steps to Upload Campus Students via CSV file:
- Obtain a CSV file of your students, with separate columns containing this data: [First Name], [Last Name], and [Student ID]. We encourage all campuses to also include student email addresses. If you allow Google Classroom syncing, you MUST have the email addresses. Column headers (titles) are not necessary.
Note: You must use one file of all of your campus's active students (as opposed to separate files by grade level or new students only, for example), because students from your previous import may be deleted if they are not in any classes yet (see step 9 below for more information on the auto-cleanup component of the CSV import process).
Also Note: Students already in classes in the system will be recognized by Student ID or email address (exact match) and duplicates will not be created during the import, but any edits to their name will be applied.
- Log into your ALL In learning administrator account.
- Go to the Administration tab, click "Student Import," and select "CSV Import."
- If Google Classroom is enabled for your campus, you CSV must contain the students' email addresses. Please be sure that these email addresses match the email addresses your students use to log in to Google Classroom.
- Click "Choose File," navigate to your desired CSV file and click "Open," and then click "Upload File."
- If your file has column titles in the first row, select the “Skip First Row (titles)” check box. This will disregard the first row, so if your first row is student data, do not select this option.
- Map your columns to the correct Student ID, First Name, and Last Name positions, referring to the preview of your file at the bottom of the screen.
- When you are finished mapping the columns, click Next.
- Review the next screen, which shows you a preview of your import results. Make sure your mapping is correct and that everything appears as it should.
Note that any inactive student (not currently in a class) who is not in your imported file will be removed from your campus list in order to keep it uncluttered for everyone. (Past report data for those students will not be deleted.) If any students get deleted unintentionally, you can import another version of your file that includes them (which will "undelete" them) or add them individually (a process that will give you a chance to undelete them).
Capitalization, characters, and order will import exactly as this preview appears. If you wish to make adjustments, click “Back to Step 2” to do so. If the preview looks correct, click “Import Now.” After a few moments of processing, you should see an “Import Complete” confirmation!
NOTE: Duplicate data will be ignored where the Student IDs or emails match exactly. If the Student IDs or emails match exactly, those students' first and last names will be updated with the imported data. Any Student IDs or emails not matching will be uploaded as new student records. If you import using the wrong Student IDs or mismatch the Student ID column during the upload, you would create duplicate records!
ALSO NOTE: If you are using Microsoft Excel For Mac to save your CSV file, be sure to choose the Microsoft CSV format. The Mac CSV format will result in mixed up column information.
"When I try to import my student csv file, there’s one long row with names and other information all in that row or cell, not in columns. The formatting is all messed up."
We have seen this problem happen when a CSV file was saved in Excel for Mac. Open it in Excel and re-save it as "Windows Comma Separated Value" file type.
"When I try to import my student CSV file, the spinner just spins and it never finishes uploading."
This may be a problem with your browser. Restart your computer, and try again. If this doesn't help, please send your csv file to firstname.lastname@example.org and explain what is going wrong so we can help.
"I accidentally imported my csv file with the first name and last name mixed up, with the wrong Student ID, or another problem. What can I do?"
- If the Student ID was imported in the correct place, you can re-import your file, being sure to match the First and Last columns correctly, and we will correct the problem for you automatically.
- If your Student IDs were imported wrongly, and if none of the students have been added to classes, you should be able to import a corrected file, being sure to map the columns correctly, and those wrongly-imported records (being considered inactive because they aren't in any classes) will be removed automatically and the corrected ones added. If the students were in classes and have data which you wish to have assigned to the corrected student ID, we recommend importing your new corrected file and then using the Merge tool to merge them one at a time with the corrected record.
- If you have duplicate students and re-importing your file will not resolve them because both are either in a class or in your file, you may decide to use the "Merge Students" tool in your administration tab to merge the duplicate records one at a time. If you have a high number of duplicates, contact support. We'll be glad to help you find the best solution!
NOTE: No existing academic data can be destroyed by importing a CSV file incorrectly. Also note that depending on the scale and nature of the error, there may be little downside to leaving it there (for example the only time anyone sees it may be when teachers type students into their rosters and the auto-complete box displays those records that may match what they are typing).
Please email email@example.com for assistance and advice on resolving import errors.
Additional keywords: csv comma seperated separated values delimited export