Generate Formatted Excel Spreadsheets in n8n

📰 Dev.to · Iteration Layer

Generate formatted Excel spreadsheets in n8n using a custom solution, as n8n lacks native support for generating XLSX files.

intermediate Published 30 Apr 2026

Action Steps

Install the ExcelJS library in your n8n workflow using a Function node
Use the ExcelJS library to create a new XLSX file and add formatted headers, currency columns, and formulas
Add multiple sheets to the XLSX file using the ExcelJS library
Use the File node to save the generated XLSX file
Test the workflow to ensure the generated XLSX file is correct and formatted as expected

Who Needs to Know This

This solution benefits developers and automation specialists who use n8n for workflow automation and need to generate formatted Excel spreadsheets as part of their workflows.

Key Insight

💡 n8n lacks native support for generating formatted Excel spreadsheets, but using ExcelJS in a Function node provides a custom solution.