# Enrollment File

<span class="rvts53">The **enrollment file** is used to assign students to their respective classes. Below are the requirements and formatting details for creating a valid enrollment file.</span>

#### **<span class="rvts0"><span class="rvts165">Required Columns</span></span>**

- **<span class="rvts184">StudentID</span>**<span class="rvts53"> - Identifies the student; must match the StudentID in the student file.</span>
- **<span class="rvts184">ClassID</span>**<span class="rvts53"> - Identifies the class; must match the ClassID in the class file.</span>

<p class="callout info"><span class="rvts184">Important:</span><span class="rvts53"> Ensure the column titles exactly match those listed above.</span></p>

#### **<span class="rvts0"><span class="rvts165">File Format</span></span>**

- <span class="rvts184">File Type:</span><span class="rvts53"> Tab-delimited text file (</span><span class="rvts183">\*.txt</span><span class="rvts53"> or </span><span class="rvts183">\*.tsv</span><span class="rvts53">).</span>
- <span class="rvts184">First Row:</span><span class="rvts53"> Must contain column headers.</span>
- <span class="rvts184">Example Tools:</span><span class="rvts53"> Export from Excel or Google Sheets as Tab-delimited Text.</span>

#### **<span class="rvts0"><span class="rvts165">Import Options</span></span>**

##### **<span class="rvts0"><span class="rvts165">Option 1: Multiple Rows per Student</span></span>**

<span class="rvts53">Each row lists a single </span><span class="rvts184">StudentID</span><span class="rvts53"> and one </span><span class="rvts184">ClassID</span><span class="rvts53">. If a student is enrolled in multiple classes, they will have multiple rows.</span>

##### **<span class="rvts0"><span class="rvts165">TEMPLATE:</span></span>**

<div class="rvps208" id="bkmrk-studentid-classid-12"><table><tbody><tr><td>**<span class="rvts21">StudentID</span>**

</td><td>**<span class="rvts21">ClassID</span>**

</td></tr><tr><td><span class="rvts20">123</span>

</td><td><span class="rvts20">Math</span>

</td></tr><tr><td><span class="rvts20">123</span>

</td><td><span class="rvts20">English</span>

</td></tr><tr><td><span class="rvts20">124</span>

</td><td><span class="rvts20">Science</span>

</td></tr></tbody></table>

</div>##### **<span class="rvts0"><span class="rvts165">Option 2: One Row per Student</span></span>**

<span class="rvts53">Each student has one row, and their classes are listed in separate columns (ClassID1, ClassID2, etc.).</span>

##### <span class="rvts0"><span class="rvts165">**TEMPLATE**:</span></span>

<div class="rvps208" id="bkmrk-studentid-classid-cl"><table><tbody><tr><td>**<span class="rvts21">StudentID</span>**

</td><td>**<span class="rvts21">ClassID</span>**

</td><td>**<span class="rvts21">ClassID</span>**

</td><td>**<span class="rvts21">ClassID</span>**

</td></tr><tr><td><span class="rvts20">123</span>

</td><td><span class="rvts20">Math</span>

</td><td><span class="rvts20">English</span>

</td><td><span class="rvts20">History</span>

</td></tr><tr><td><span class="rvts20">124</span>

</td><td><span class="rvts20">Science</span>

</td><td><span class="rvts20">Math</span>

</td><td><span class="rvts14">  
</span>

</td></tr></tbody></table>

</div><p class="callout success"><span class="rvts53">The </span>**<span class="rvts184">Enrollment File</span>**<span class="rvts53"> assigns students to classes within a specific event. The students and classes referenced must already exist in the system from the Student and Class files.</span></p>

#### **<span class="rvts0"><span class="rvts165">Where to Check Imported Enrollment Data in the Admin UI</span></span>**

- <span class="rvts53">Open the event in the Admin UI.</span>
- <span class="rvts53">Go to the </span><span class="rvts184">Class Editor</span><span class="rvts53"> tab.</span>
- <span class="rvts53">Select a class to view the enrolled students.</span>
- <span class="rvts53">Ensure that all expected students are assigned to their correct classes.</span>