Download to CSV removes leading zeroes

[Lepidoptera]

I am having a problem with the download as csv by tabular datapage. I have lot numbers and zipcodes that leads with zeroes example: 0025, 05907, and empty lot numbers/zipcodes should contain 0000 but after downloading to CSV the zeroes dissapers.

[Queso]

Hi @Lepidoptera,

I am having this issue as well when I open the downloaded file with Excel. It seems that Excel drops leading zeros.

Since CSV files are file formats that contain plain text values separated by commas, I open the file with Notepad so I can see the values along with their leading zeros.



 

[Kurumi]

Hi @Lepidoptera - is it the same with Excel (XML). What is your datatype for Zip Codes?

[Lepidoptera]

Hey @Meekeee, I never tried with XML. The datatype of the Zipcodes are in Text(255).

[Kurumi]

@Lepidoptera - can you try using the XML format? What will be the result?

[futurist]

Hi @Lepidoptera,

This is an expected behavior when opening CSVs, but you can bypass this by doing a couple of things on Excel and keep the leading zeroes on the Excel:

1.      Open the Excel application itself.

2.      On the Data tab, select “From text/CSV”

 

3.      Select your CSV file, and Import.

4.      The Import Wizard will show up. Click “Transform Data”

 

5.      On the next screen, select the field in question, and change the data type to Text.

 

 

6.      Choose “Replace current”

 

7.      Click on Close & Load.

 

Output:

 

Hope this helps!