Trouble converting JSON to CSV or Excel doc

[ericgr]

I have read through the “related” questions but my exact issue is not addressed.

I am able to generate JSON and, somewhat, convert it to a CSV or XLSX file, but all of the data is on a single row across a gazillion columns. See screenshot. I have tried using various “options” in the Convert to File node, but the result is always the same.

wrong output - no error

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

• n8n version: 1.77.3
• Database (default: SQLite): default
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• **Operating system: Ubuntu **

[ericgr]

Thought it might be helpful to see a screenshot of the last node:

[hubschrauber]

Add a Split Out node after the HTTP Request node with Fields To Split Out: set to data (which maps to the actual array of result items).

Then, each object/item feeding into the Convert to File will be distributed in the cells of a single row, and the attribute names will be in the row-1 header cells.