Export CSV data grouped in 1 column

[AIZUDDIN_ABD_AZ]

I try to use export CSV action in my apps. however the data exported is grouped under 1 column.

CSV exported data

the original data

How can I use the csv download action that can arrange its column like the original data?

[Marc_Dillon · Accepted solution]

It’s not “grouped under 1 column”. It’s just not comma-delimited. It seems to be semi-colon-delimited, for whatever reason.

When you open the CSV file into Excel (or any other spreadsheet application), you can choose the delimiter to separate the data on.

Perhaps it is using semi-colons instead of commas due to the locale setting that you have on your Action. You can try changing that here:

[AIZUDDIN_ABD_AZ]

Thanks it works, really appreciate your help.

I thought CSV file locale need to be choose to my country.

Thank you.