Actions80
- Add Attachment To PDF
- Add Barcode To PDF
- Add Form Fields To PDF
- Add HTML Header Footer
- Add Image Stamp To PDF
- Add Image Watermark To Image
- Add Margin To PDF
- Add Page Number To PDF
- Add Text Stamp To PDF
- Add Text Watermark To Image
- AI-Invoice Parser
- AI-Process Contract
- AI-Process HealthCard
- Classify Document
- Compress Image
- Compress PDF
- Convert HTML To PDF
- Convert Image Format
- Convert JSON To Excel
- Convert Markdown To PDF
- Convert PDF To Editable PDF Using OCR
- Convert PDF To Excel
- Convert PDF To PowerPoint
- Convert PDF To Word
- Convert To PDF
- Convert URL to PDF
- Convert VISIO
- Convert Word to PDF Form
- Create Images From PDF
- Create PDF/A
- Create Swiss QR Bill
- Crop Image
- Delete Blank Pages From PDF
- Delete Unwanted Pages From PDF
- Split PDF By Barcode
- Disable Tracking Changes In Word
- Enable Tracking Changes In Word
- Extract Attachment From PDF
- Extract Form Data From PDF
- Extract Pages From PDF
- Extract Resources
- Extract Table From PDF
- Extract Text By Expression
- Extract Text From Word
- Fill PDF Form
- Find And Replace Text
- Flip Image
- Flatten PDF
- Generate Barcode
- Generate Document Single
- Generate Documents Multiple
- Get Document From Pdf4me
- Get Image Metadata
- Get PDF Metadata
- Split PDF By Swiss QR
- Get Tracking Changes In Word
- Image Extract Text
- Linearize PDF
- Merge Multiple PDFs
- Overlay PDFs
- Parse Document
- Protect PDF
- Read Barcode From Image
- Read Barcode From PDF
- Read SwissQR Code
- Remove EXIF Tags From Image
- Repair PDF Document
- Replace Text With Image
- Replace Text With Image In Word
- Resize Image
- Rotate Document
- Rotate Image
- Rotate Image By EXIF Data
- Rotate PDF Page
- Sign PDF
- Split PDF By Text
- Split PDF Regular
- Unlock PDF
- Update Hyperlinks Annotation
- Upload File To PDF4me
Overview
This node operation converts JSON data into an Excel spreadsheet file. It supports multiple input formats for the JSON data, including raw JSON strings, binary files containing JSON, and base64-encoded JSON strings. The output is a downloadable Excel file (.xlsx) with customizable worksheet and document names.
This node is useful when you want to transform structured JSON data into a tabular Excel format for reporting, sharing, or further analysis in spreadsheet software. For example, converting API response data or database query results into Excel sheets automatically within an n8n workflow.
Properties
| Name | Meaning |
|---|---|
| Input Data Type | Choose how to provide the JSON data to convert. Options: "JSON String" (direct JSON content), "Binary Data" (JSON file from previous node), "Base64 String" (base64 encoded JSON content). |
| JSON Content | The JSON data to convert to Excel, provided as a JSON string. Used only if Input Data Type is "JSON String". |
| Input Binary Field | Name of the binary property that contains the JSON file. Used only if Input Data Type is "Binary Data". |
| Base64 JSON Content | Base64 encoded JSON content. Used only if Input Data Type is "Base64 String". |
| Output File Name | Name for the output Excel file, e.g., "converted_data.xlsx". |
| Document Name | Name of the output document for reference purposes. |
| Worksheet Name | Name of the Excel worksheet inside the file, e.g., "Sheet1". |
| Advanced Options | Collection of optional advanced settings: |
| - Convert Numbers and Dates | Boolean flag to automatically convert numbers and dates in the JSON data. |
| - Custom Profiles | JSON string to specify custom profiles for API calls to adjust extra options (refer to external API documentation). |
| - Date Format | Pattern string defining date format for Excel cells, e.g., "MM/dd/yyyy". |
| - First Column | Starting column number (1-based) in the Excel sheet where data will be placed. |
| - First Row | Starting row number (1-based) in the Excel sheet where data will be placed. |
| - Ignore Null Values | Boolean flag to ignore null values in the JSON data during conversion. |
| - Number Format | Number format code for Excel cells. Options include General, Number with decimals, Currency, Percentage, Scientific, Date/Time formats, etc. |
| - Title Bold | Boolean flag to make the title row bold. |
| - Title Wrap Text | Boolean flag to wrap text in title cells. |
| Binary Data Output Name | Custom name for the binary data output in n8n, e.g., "data". |
Output
The node outputs a single item containing:
- A
jsonfield with metadata about the conversion (not detailed here). - A
binaryfield containing the generated Excel file data under the specified binary data output name (default "data"). This binary data represents the.xlsxfile ready for download or further processing.
Dependencies
- Requires an API key credential for the PDF4me service or similar backend service that performs the JSON to Excel conversion.
- The node relies on external API calls to perform the actual conversion; thus, internet connectivity and valid authentication are necessary.
- No additional environment variables are explicitly required beyond the API credentials.
Troubleshooting
- Invalid JSON Input: If the JSON content is malformed or invalid, the node may throw errors. Ensure the JSON string or file is correctly formatted.
- Incorrect Binary Property Name: When using binary input, specifying the wrong binary property name will cause the node to fail to find the JSON file.
- API Authentication Errors: Missing or invalid API keys will result in authentication failures.
- Unsupported Number or Date Formats: Using unsupported or incorrect format codes in advanced options may cause formatting issues in the Excel output.
- Large JSON Data: Very large JSON inputs might lead to timeouts or memory issues depending on the backend service limits.
To resolve these:
- Validate JSON before input.
- Double-check binary property names.
- Verify API credentials.
- Use supported format codes.
- Split large datasets if needed.
Links and References
- PDF4me API Profiles Documentation — for customizing conversion profiles and advanced options.
- Excel Number Format Codes — reference for number format codes used in Excel cells.