Grades: Export to CSV File from Grades
Show me Exporting Grades.
Grade items and final grades can be exported in a .csv (comma separated values) format that can be imported into other applications. The file as exported from Carmen may need to be manipulated in various ways to make it useful in other applications.
If you will be importing your document into an application that uses the Org Defined ID as the identifying field, be sure to work with your file in a way that will preserve the leading zeros in ID numbers that have them. Applications that use this field include the Faculty Center Grade Roster for posting final grades. See Prepare Exported Grades File... for more information.
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 (see Import into Grades from CSV), avoid exporting grade items that will cause errors when you import your grades. Non-importable items will be marked with a gray exclamation point in the list.
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. Use a .csv-compatible application, such as Excel, to view the file or to add and edit data.
6. To import the saved .csv file into Excel:
- Open Excel
- Start the process to import the .csv file. The exact option will depend on your version of Excel; the path might be Data > Import External Data > Import Data. Other options might be Data > Get External Data > From Text, or Data > Get External Data > Import Text File. After you have chosen the import command, locate your .csv file
- A wizard will walk you through the process of formatting the file.
- Select Delimited then click the Next button.
- Choose Comma as your Delimiter. Choose {None} as your Text Qualifier.
- Choose Text as the field type for the Org Defined ID, if you are using that field
- Click the Finish button. If prompted, place the data in a blank spreadsheet.
7. Save your data.
- If you will be using the file as a template for importing grades, save it as a .csv file. Choose File > Save As… and change the Save as type dropdown box to .csv format. Click Save.
- If you are exporting your grades to save as a personal back-up copy, you can save the file in Excel format, which will allow you to add formatting.
Some versions of Excel may be able to correctly import the file without using the import wizard. You will still need to save the file in .csv or Excel format.
