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.pngYesenia_Leon_1-1697582576997.png

 

Solved Solved
0 2 123
2 ACCEPTED SOLUTIONS

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

TeeSee1_0-1697618285738.png

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 .

 

View solution in original post

You can open the CSV file

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

Close and Reopen the file.

Uncheck Conversion.jpg

View solution in original post

2 REPLIES 2

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

TeeSee1_0-1697618285738.png

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 .

 

You can open the CSV file

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

Close and Reopen the file.

Uncheck Conversion.jpg

Top Labels in this Space