Built-in Download as CSV function

Ask the community
,
1

Hi.

I have a table that I’d like to export as a csv-file. The values sometimes includes commas and newlines, so when I use the download as csv option at the table, my table is broken when I import it to Excel.

I’m aware I could use the “Export data” action node, but it seems redundant considering I just want to wrap strings in quotes (and omit newlines) in the csv-file. Which probably should be default behaviour for table export, right?

2

Hi Tobias, and welcome to our Community!

When you use the inbuilt export functionality on a table, there are other fields that then become available underneath.
image

You can change the delimiter to a semicolon and enable the “Strings in Quotes” checkbox, which will solve these problems that you are encountering.

Thanks
Rhys
Appfarm

3

Thank you!
This was really helpful.
I’m ashamed I managed to overlook this.