File format for importing grades

The import file must follow a standard format. We recommend that you set up your grade book in Connect even if you want to enter grades in a CSV or TXT file. That way, you can use the Export Grades option to create an appropriately structured file.
The file format is as follows:

Field	Description	Example
Username	A unique name for identifying a user in Connect. You must provide a username or org defined ID (or both).	Frank.Catcher
Org Defined ID	A unique number for identifying a user in Connect. You must provide a username or org defined ID (or both).	20067930
<Item> Points Grade	Numeric and Pass/Fail grade items should be labeled the grade item name followed by Points Grade. Users' grades should be the Points Grade the learner received. For example, 44 points out of a possible 50 points.	44
<Item> Grade Symbol	Select box grade items should be labeled the grade item name followed by Grade Symbol. Users' grades should be a pre-existing grade scheme symbol. For example, Very Good, Merit, or 3.5.	Very Good
<Item> Text Grade	Text grade items should be labeled the grade item name followed by Text Grade. Users' grades can be any text value. Text grade items do not count towards users' final grades.	Perfect Attendance!
Adjusted Final Grade Numerator	The total points a user achieved in a unit. You can enter a user's percentage grade (without the % sign) if you enter the denominator as 100. For example, 84 points out of 100 points or 230 points out of 285 points.	84
Adjusted Final Grade Denominator	The total possible points available in a unit. Enter 100 if you want to record users' percentage grades. For example, _ / 100 points available or _ / 285 points available.	100
End-of-Line Indicator	The last column must be labeled End-of-Line Indicator so the system knows when the next set of data begins. The end of each users' line should be indicated with the pound key #.	#

NOTES

If you enter a grade value that is greater than the value for the grade item, the grade is capped at the value unless you select the Can Exceed check box when setting up the grade item.
Do not import other options, such as a user's first name, email, or weighted grade.
To improve performance when importing grades for large classes, only import grade items that have changed and import by group when possible.