Skip navigation, view page content

Carmen Login | Carmen Info | Request Help

Grades: Export to CSV File from Grades

Grade items and final grades can be exported in a .csv (comma separated values) format that can be imported into other applications, including Excel.

Grades are considered sensitive data. Exported grade files should only be stored on an encrypted device. If you are unsure whether your computer or storage media is secure, check with your local computer support staff for more information.

1. Access the Gradebook, click on Enter Grades in the Menu, and click Export to File in the toolbar.

2. Select Export Options.

• Choose whether to export your entire student list or a subgroup based on defined groups and sections.
• Which key field should be exported for each user: The option you select will be listed first for each student. (The username is the student's OSU internet username, lastname.#.)
• Which grade values would you like to export for each user: Your options will vary based on the grading system you selected.
• What user detail fields should be included in the export: The option(s) you select will be listed immediately after the key field(s) you selected above.

3. Check boxes for grade items and categories under Choose Grades to Export.

If you are exporting your Gradebook to use as a template for importing grades, avoid exporting grade items that should not be part of your template.  Only Numeric, Pass/Fail, Selectbox, and Text grade items, and the Final Adjusted Grade can be imported. 

4. Click Export to CSV File. When your file is processed, a link to the file appears in a popup window.

5. Save the .csv file to your computer. The file can be viewed and edited in a .csv-compatible application, such as Excel.

6. Open or import the saved .csv file with Excel.