How to write a proper CSV file using the Spreasheet File node

Questions
1

I have a workflow which generates a nice array with json objects.
When I want to write this to a CSV file with the Spreasheet File node I get a file with everything on a single line.
What am I doing wrong?

The input is like:

[
  { columnA: 'value 1', columnB: 'value 2' },
  { columnA: 'value 3', columnB: 'value 4' },
]

The output of the file is
value 1, value 2, value 3, value 4

p.s. Is it also possible to change the separator from a , to a ;
Or do I just need to create the CSV in a complete different way?

2

Welcome to the community @RConen !

Guess there is nothing wrong. Please check out another similar post here:

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.