Step 1: Go to Course Admin
Step 2: Go to Grades
Step 3: Select Export
Step 4: Export grade items for All Users

Select 'both' in Key Field

Select 'Last Name', 'First Name', and 'Email' in User Details

Get rid of Points in Grade Values

Step 5: Select Export to Excel


Select Download and it will upload onto your computer as an excel spreadsheet
Step 6: Open up the file, it's time to clean up any unwanted information.

If there's any unwanted information, just delete it. Just highlight the column, right select, and delete it.