Importing to Excel with Student IDs Beginning in 0

Importing to Excel with Student IDs Beginning in 0

The following instructions are illustrated using Excel 2016, but a similar process should work in other versions of Excel.

This process only needs to be completed once. After the data has been imported and you have been working on the file in Excel, just save the file as normal. The next time you will be able to open it properly in Excel by double clicking.

  1. Open Excel. From the Data tab, choose Get External Data from Text.


  1. In the file selection window, change the file type to “All Files” and then browse to find the file you saved at the end of step 5.


  1. Click Import. You will be presented with the Text Import Wizard. In Step 1, ensure that the file type is Delimited (default). Click Next.


  1. In step 2, select either Tab or Comma, depending on how you downloaded the file. If you didn’t change any defaults, then the file will be Tab-delimited. Click Next.


  1. In step 3, select the Username column and change the Column Data Format to Text.

Select the Student ID column and change the Column Data Format to Text. Click Finish.


  1. You will be asked where you want to put the data. Click OK. You should now see that the data from the Grade Centre has been properly imported, retaining the student numbers in the correct format.