...
Select Grades from the course navbar.
Select Enter Grades.
Select Export.
From the list of grade items, select the grade item to be populated with the attendance marks and click Export to csv.
Copy the column title for the grade item (for the example above, Participation Points Grade <Numeric MaxPoints:100 Weight:5>) from this newly generated .csv file.
Open the Attendance .csv file from the previous export and replace the %Attendance column title with this new title copied from the gradebook export.
Save the Attendance csv file.
Return to the Enter Grades area of the Grades.
Select Import and select Choose File.
Locate and select the Attendance csv file containing the new column title.
Import the Attendance csv file containing the new column title. See Importing Grades from an Excel File for detailed information.
...