Steps
To stop excel dropping zeros.
- Get xlsx setup completely before export
- Save as CSV (DO NOT OPEN CSV and RESAVE.
- This should drop leading zeros
For more information regarding leading zeros, see the link below
Link - https://www.extendoffice.com/documents/excel/1778-excel-delete-keep-leading-zeros.html