Once you’ve downloaded your Grade Center, it’s time to edit it. If you open the file normally in Excel, it will remove the leading zeros on student ID’s. To prevent this, follow these steps.
Open a new document in Excel. From the Data ribbon, choose From Text. You may have to use the Get External Data dropdown to see it.
Select your file, and you’ll be brought to a screen that allows you to begin selecting import information. Choose Delimited for the data type and check “My data has headers”. Then click Next.
On the next screen, make sure only the Comma box is checked and click Next.
On the final screen, click on the box for Username, and change the data format to Text. If you don’t, the leading zeros will be removed from the student ID’s, and you won’t be able to import them into the Grade Center.
Click Finish, and you can edit the Grade Center. Do
Do not change the column headers, or the file won’t import correctly.