Actions80
- Extract Text From Word
- Find And Replace Text
- Convert PDF To Editable PDF Using OCR
- Create Swiss QR Bill
- Split PDF By Barcode
- Split PDF By Swiss QR
- Split PDF By Text
- Split PDF Regular
- Create PDF/A
- Convert HTML To PDF
- Convert Markdown To PDF
- Upload File To PDF4me
- Add Attachment To PDF
- Add Barcode To PDF
- Add Form Fields To PDF
- Fill PDF Form
- Add HTML Header Footer
- Add Image Stamp To PDF
- Add Margin To PDF
- Add Page Number To PDF
- Add Text Stamp To PDF
- AI-Invoice Parser
- AI-Process HealthCard
- AI-Process Contract
- Generate Barcode
- Classify Document
- Parse Document
- Linearize PDF
- Flatten PDF
- Convert To PDF
- Json To Excel
- Convert PDF To Excel
- Convert PDF To Word
- Convert PDF To PowerPoint
- Convert VISIO
- Crop Image
- Delete Blank Pages From PDF
- Delete Unwanted Pages From PDF
- Extract Pages
- Merge Multiple PDFs
- Overlay PDFs
- Rotate Document
- Rotate Page
- Sign PDF
- URL to PDF
- Add Image Watermark To Image
- Add Text Watermark To Image
- Compress Image
- Convert Image Format
- Create Images From PDF
- Flip Image
- Get Image Metadata
- Image Extract Text
- Remove EXIF Tags From Image
- Replace Text With Image
- Replace Text With Image In Word
- Resize Image
- Rotate Image
- Rotate Image By EXIF Data
- Compress PDF
- Get PDF Metadata
- Repair PDF Document
- Get Document From Pdf4me
- Update Hyperlinks Annotation
- Protect Document
- Unlock PDF
- Disable Tracking Changes In Word
- Enable Tracking Changes In Word
- Generate Document Single
- Generate Documents Multiple
- Get Tracking Changes In Word
- Read Barcode From Image
- Read Barcode From PDF
- Read SwissQR Code
- Extract Form Data From PDF
- Extract Pages From PDF
- Extract Attachment From PDF
- Extract Text By Expression
- Extract Table From PDF
- Extract Resources
Overview
The node 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. This flexibility allows users to convert structured JSON data from various sources into a well-formatted Excel document.
Common scenarios where this node is beneficial include:
- Exporting API response data or database query results in JSON format into Excel for reporting or analysis.
- Transforming JSON logs or event data into Excel sheets for easier visualization.
- Converting JSON configuration or data files into Excel for sharing with non-technical stakeholders.
Practical example:
- A user receives JSON data from a webhook and wants to generate an Excel report automatically. They can feed the JSON string directly or use a previous node's binary JSON file as input, specify worksheet and formatting options, and get an Excel file ready for download or further processing.
Properties
| Name | Meaning |
|---|---|
| Input Data Type | Choose how to provide the JSON data to convert. Options: "JSON String", "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 when Input Data Type is "JSON String". |
| Input Binary Field | Name of the binary property that contains the JSON file. Used when Input Data Type is "Binary Data". |
| Base64 JSON Content | Base64 encoded JSON content. Used when 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 (default "Sheet1"). |
| Advanced Options | Collection of optional advanced settings: |
| - Convert Numbers and Dates | Whether to automatically convert numbers and dates in the JSON data. |
| - Custom Profiles | JSON string to set custom profiles for API calls, allowing extra options for conversion. |
| - Date Format | Date format pattern for Excel cells (e.g., "MM/dd/yyyy"). |
| - First Column | Starting column number (1-based) in the Excel sheet. |
| - First Row | Starting row number (1-based) in the Excel sheet. |
| - Ignore Null Values | Whether 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 | Whether to make the title row bold. |
| - Title Wrap Text | Whether to wrap text in title cells. |
Output
The node outputs an Excel file (.xlsx) containing the converted data from the input JSON. The output includes:
- A JSON object with metadata about the generated Excel document.
- A binary property containing the actual Excel file data, named according to the specified output file name.
This Excel file can be downloaded, saved, or passed to subsequent nodes for further processing.
Dependencies
- Requires an API key credential for the PDF4me service or similar backend that performs the JSON to Excel conversion.
- The node relies on external API calls to convert JSON data into Excel format.
- Proper configuration of authentication credentials in n8n is necessary for successful execution.
Troubleshooting
- Invalid JSON input: If the JSON content is malformed or invalid, the node will throw an error. Ensure the JSON string or file is correctly formatted.
- Incorrect binary property name: When using binary data input, specifying the wrong binary field name will cause the node to fail to find the JSON file. Verify the binary property name matches the previous node's output.
- API authentication errors: Missing or incorrect API credentials will result in authorization failures. Check that the API key or token is properly configured.
- Unsupported date or number formats: Using unsupported or incorrect format codes in advanced options may lead to unexpected formatting in Excel. Use documented format codes.
- Large JSON data: Very large JSON inputs might cause timeouts or memory issues depending on the backend service limits.
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.