Can anyone think why Export to CSV would output data all on row?

Hi All,

In my old PHP project (now working in NodeJS) i had export to CSV working without a problem.

It would export a large set of data to CSV, with the column headers and would return each new row of data in a new row in excel. I was using comma as the delimiter.

Now, when i set up a similar server action, just running a simple Select * query, then Export to CSV it does the following:

Export to file works fine
Separates data correctly on the delimiter
BUT - all the 100+ rows of data from the query are in 1 single row in excel.

Anyone have any thoughts? or is this possibly a bug with the export function and NodeJS?

Cheers