n8n-nodes-excel-splitter

This is an n8n community node that allows you to split Excel files into separate sheets.

Features

• Get Sheet Names: List all sheet names from an Excel file
• Split Sheets: Split an Excel file into separate files (one per sheet)
• Extract Sheet: Extract a specific sheet by name or index

Installation

Follow the installation guide in the n8n community nodes documentation.

npm install n8n-nodes-excel-splitter

Operations

Get Sheet Names

Returns a list of all sheet names in the Excel file.

Output:

{
  "fileName": "workbook.xlsx",
  "sheetCount": 3,
  "sheets": ["Sheet1", "Sheet2", "Sheet3"],
  "sheetList": [
    { "index": 1, "name": "Sheet1" },
    { "index": 2, "name": "Sheet2" },
    { "index": 3, "name": "Sheet3" }
  ]
}

Split Sheets

Splits an Excel file into separate files, one for each sheet.

Options:

• Output Format: XLSX, CSV, or JSON
• Include Empty Sheets: Whether to include sheets with no data
• File Name Prefix: Prefix to add to output file names

Output: Multiple items, each containing one sheet as binary data.

Extract Sheet

Extracts a specific sheet from an Excel file.

Options:

• Sheet Selector: By Name or By Index
• Sheet Name/Index: The sheet to extract
• Output Format: XLSX, CSV, or JSON

Usage Example

Convert Each Sheet to CSV

1. Read Binary File - Read your Excel file
2. Excel Splitter - Operation: "Split Sheets", Output Format: "CSV"
3. CloudConvert (or other converter) - Process each CSV file

Get Sheet Names Then Loop

1. Read Binary File - Read your Excel file
2. Excel Splitter - Operation: "Get Sheet Names"
3. Split In Batches - Iterate over sheetList
4. Excel Splitter - Operation: "Extract Sheet", Sheet Name: {{ $json.name }}

Compatibility

• n8n version 0.5 or later
• Supports XLSX, XLS, and ODS files

License

MIT