If you want Excel to keep a field’s leading zeros when opening a CSV file using Excel, you can change it to =”value”.
For example, if you have a row with 4 values that looks like this:
test,00016102,test,test
Change it to:
test,="00016102",test,test