AcademyWorkflowsData and reporting

Convert JSON to an Excel file

Operations and data teams that need to turn JSON output from other systems into spreadsheets.

  • Recommendedour rating
  • 41,974views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

convert-json-to-an-excel-file.json

Loading the file...

What it does

A small n8n workflow that receives a JSON array through an HTTP POST request and returns an Excel file. The file is named Export.xlsx by default, and you can set another name with the optional filename query parameter. Remember to change the webhook path before using it.

Use cases

  1. 01Turn an API response into a spreadsheet for colleagues
  2. 02Export records from a script as an Excel file
  3. 03Add a JSON to Excel step to another automation

Questions about
Convert JSON to an Excel file.

What is Convert JSON to an Excel file used for?

Operations and data teams that need to turn JSON output from other systems into spreadsheets. A small n8n workflow that receives a JSON array through an HTTP POST request and returns an Excel file. The file is named Export.xlsx by default, and you can set another name with the optional filename query parameter. Remember to change the webhook path before using it.

How do I import Convert JSON to an Excel file into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Convert JSON to an Excel file safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.