Types of columns in the downloaded CSV

[Emily]

Hello.

I'm creating an AppSheet using a database in Cloud SQL on GCP.
I created a CSV export action from a table created with SQL VIEW.
When I checked the downloaded CSV in Excel, only the Decimal column in AppSheet's column setting is "Currency". The other columns are "Normal".

I want to set all columns to "Normal", but what is the cause?

[TeeSee1 · Accepted solution]

By definition, CSV does not contain any types. All data are textual. (CSV files are text files)

Types are assigned when you open a CSV file in Excel. So it is an Excel 'issue' rather than an AppSheet issue.

Having said that one other possibility is to use a bot to create files rather than using an action to export CSV. See this Q&A.

I have not tried this but enclosing fields with quotations (or any other appropriate format) might force Excel to behave in the way you want.

[Emily]

@TeeSee1 

Thank you for your advice!

Probably, Excel made a judgment on its own because the thousands separator was included in the number.
It was okay because I was able to import by specifying Unicode in cooperation with another application.