How to open CSV file in Excel without deleting leading zeros?
01
Navigate to File -> New
02
Navigate to Data -> Get External Data -> Import Text File…
03
Select the CSV file and click Get Data In case you’re opening a Gridoc export file, the file name will be in the format gridoc-export-date-time.csv
04
05
06
07
08
Values in the Order Number column retain leading zeroes.