I am working with our SIS, Tyler SIS, and the data we pull comes with leading zeros for our teacher IDs. After I export it, manipulate it in Excel or Google Sheets, then create the CSV file and re-open that CSV file I find that the user_id leading zeros are missing. This is very annoying.
I found a solution by creating the CSV file and never opening it but go straight to importing it into Canvas. It will work.
I am asking if there is a better solution than what I am doing?