Problems with data in a CSV file.

[Yesenia_Leon]

Dear Sirs:

I have an application that has the download option, but when we download it it omits the zeros from a text type column.

Do they know if we can use some sentence to make it download correctly.

[TeeSee1 · Accepted solution]

Appsheet csv downloads data as is with quotations like shown here.

When you import the data into a spreadsheet application, it is treating the col as numeric and deleting the leading zeros.

You have to configure your spreadsheet to prevent this and you cannot correct this within AppSheet .

[TeeSee1 · Accepted solution]

Appsheet csv downloads data as is with quotations like shown here.

When you import the data into a spreadsheet application, it is treating the col as numeric and deleting the leading zeros.

You have to configure your spreadsheet to prevent this and you cannot correct this within AppSheet .

[T_I_Phong · Accepted solution]

You can open the CSV file

File => Options => Data => Uncheck as shown in the picture => OK.

Close and Reopen the file.