---
title: "Uploading Grades with a CSV File"
canonical: "https://kb.uconn.edu/space/SAS/10828449459/Uploading%20Grades%20with%20a%20CSV%20File"
format: markdown
---
> Macro (section)
> 
> Instructors can upload grades to the Student Administration System <span style="color: #333333">as an alternative to entering the grades manually. </span>
> 
> > ℹ️ For additional information, refer to the following articles: 
> > ℹ️ 
> > ℹ️ - [Downloading Class Rosters as Excel Documents](https://uconn.atlassian.net/wiki/spaces/SAS/pages/10776805465)
> > ℹ️ - [Editing a Class Roster File in Excel ](https://uconn.atlassian.net/wiki/spaces/SAS/pages/10834411511)
> 
> > ⚠️ <span style="color: #333333">If you maintain grades in HuskyCT, you can opt to push your grades using </span><span style="color: #0747a6">[Grade Journey to Student Admin](https://kb.uconn.edu/space/TL/10782474474)</span><span style="color: #333333">.  If you would like assistance, contact Educational Technologies at edtech@uconn.edu or 860-486-5052.</span>

## Formatting your CSV File

### File Upload Specifications

- For PC users, the file must be in **CSV (Comma delimited) format**. For Mac users, the file must be in Excel's **CSV (Windows) "Save as..."** format.
- It must consist of four columns in this order: **Term, Class Number, ID (Student ID or NetID), **and **Grade**.
- Column header names can vary but must contain the required data.
- Grades must be in letter grade format and capitalized.   
> Macro (inline-media-image)

## File Upload Specifications - Additional Tips

- The Term and Class Number columns require data in the first row only.
- Your Class Number can be found on your Faculty Center Class Roster or Grade Roster page in the Student Administration System.
- If you are submitting a batch upload with multiple sections, you should list the lecture class number. You do not need to know which graded class number is associated with each student.
- The Term Codes are as shown in the image below:

- The ID can be either a student's NetID OR the 7-digit Student Administration System ID.
- Additional columns may be present, such as **Name**, as long as they appear to the right of the required four columns and do not contain any commas in the column headers or rows.
- You can save the file with a name of your choosing; there is no naming convention.

## <span style="color: #000000">Uploading Grades with a CSV File</span>

1. [Log ](https://confluence.uconn.edu/ikb/student-administration-system/instructors-and-advisors/getting-started-instructors-and-advisors/logging-in-and-out-of-the-student-administration-system-instructors-and-advisors)in to the Student Administration System.
2. Click the **NavBar** icon in the top right-hand corner.
3. Click the **Navigator** button from the menu.
4. Click the **Self Service** tab.
5. Click the **Faculty Center** tab.
6. Click the** My Schedule **tab.
7. The **My Schedule** page will then display.
  1. Confirm the Term before proceeding. If the term needs to be changed, click the **Change Term **button to select the appropriate term.
    - If you are entering grades for sections individually, Select the **Grade Roster icon** displayed in Step 8.
    - If you are entering grades for multiple sections in a batch, Select **UPLOAD GRADES** button on the **My Schedule Page **and proceed to Step 12.
8. Select the **Grade Roster **icon to the left of the class for which you want to upload grades.
9. <span style="color: #333333">The </span><span style="color: #333333">**Grade Roster**</span><span style="color: #333333"> will display within the browser.</span>
10. <span style="color: #000000">Navigate to the </span><span style="color: #000000">**Grade Roster Action **</span><span style="color: #000000">section.</span>
11. <span style="color: #000000">Click </span><span style="color: #000000">**Upload Grades**</span><span style="color: #000000">. </span>
12. Click **Browse** to locate the file you just created, and select it.
13. Click **Open**.
14. Click **Upload**.
15. The file will then be processed. If errors display, you should review the errors and:
  1. Correct and upload the CSV file (overlaying previous grades, or
  2. Click **Return** and correct the grades(s) in the Grade Roster itself. For more information on how to record final grades, see [Recording Final Grades](https://confluence.uconn.edu/ikb/student-administration-system/instructors-and-advisors/instructors/recording-final-grades).
16. If no errors are present, the **Grade Roster** page displays. Verify that all of the uploaded grades are correct.
17. Click **Save **at the bottom.
18. After all the grades have been populated and saved, change the **Approval Status** at the top of the page to ***Approved*** on each roster.
19. A confirmation screen will display. Click **OK**.

## <span style="color: #000000">Uploading Grades with a CSV File - Additional Tips </span>

- Grade rosters can be updated as many times as desired as long as the Approval Status is **Not Reviewed**. However, once the Approval Status has been changed to either **Ready for Review** or **Approved** the Upload button will no longer appear.
- Midterm rosters do not need to be approved.

## Related Articles

> Macro (contentbylabel)