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
- 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.)