When opening a csv file in excel, leading zero’s are displaced as below:
if the CSV file has “010101”, when opened in excel, it becomes “10101”.
To overcome this issue, store data in CSV file as =”010101″ (add ‘equals’ sign before the first quote.). If now you would open this file in excel, the leading zeros will stay as is.