Problems with data in a CSV file.

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.

Yesenia_Leon_0-1697582535389.png

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 .

1 Like

You can open the CSV file

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

Close and Reopen the file.

1 Like