Keep Leading Zero in Student ID – School Data Solutions

Overview: The ‘Other’ Student ID is a seven digit number which usually begins with a zero. When working in Excel the leading zero is dropped. In order to properly upload scores in Homeroom Admin, the leading zero MUST be kept when saving your Excel score file to a .csv file.

Use To: keep the leading zero in the Student Id in a .csv file for uploading student scores to Homeroom

Instructions

Highlight the column with the Other ID
Right click on the column and choose Format Cells
Select Custom (in the category area)
In the Type box, enter seven zeros: 0000000. Click OK.
Save the Excel file as .csv

Note: After saving as .csv, if you reopen the file using excel, the leading zero may not appear in the spreadsheet. However, when using the Homeroom Admin Manual Uploader, the leading zero will be retained and you will be able to see it in the preview in Step 6 of the upload process.)

For more information on the leading zeros, visit this information page provided by Microsoft: https://support.office.com/en-ca/article/Keep-leading-zeros-in-number-codes-1bf7b935-36e1-4985-842f-5dfa51f85fe7

Instructions

Related articles