How do I create a Student via CSV?

Overview

You will often need to create student records via CSV.

Step 1: Create an Enrollments Spreadsheet file

Create a spreadsheet with a spreadsheet program like Google Sheets, Excel, LibreOffice, etc.

Column headers in the sheet must be the following. See this page for full CSV file documentation.

Each row in this file represents two things, a user and an enrollment. Set the Role column in the file to student to enroll the user in the course as a student.

Unique Course/Section Identifier,Term,Role,Unique User Identifier,First Name,Last Name,Email,Status 202105-6038,202105,student,500098543,Lauren,Arts,l_arts@example.com,Active 202105-6038,202105,student,500043903,Cassidy,Blombin,s_bloombin@example.edu,Active

Step 2: Export the sheet as a .csv file

Export the sheet with the enrollments/student data as a CSV file. The process for doing this will vary according to the program you use but this is typically under File > Export or something similar.

Step 3: Import the CSV into CircleIn

Visit CircleIn’s siteadmin at somelink and navigate to SIS Imports where you can upload the file. It will be processed and imported shortly.