Description

n8n-nodes-excel-csv-processor

This is an n8n community node that provides advanced Excel and CSV file processing capabilities with configurable row and column offsets.

n8n is a fair-code licensed workflow automation platform.

Features

The Excel/CSV Processor node allows you to:

• Process both Excel (.xlsx, .xls) and CSV files
• Select specific sheets from Excel workbooks
• Skip rows before headers (useful for files with title rows)
• Handle multiple header rows
• Skip rows between header and data
• Remove footer rows
• Skip columns from the beginning or end
• Customize CSV delimiters (including tab, newline)
• Handle UTF-16 encoded CSV files
• Output data in multiple formats:
  • JSON only
  • CSV only
  • Excel only
  • Both JSON and CSV/Excel

Installation

Follow the installation guide in the n8n community nodes documentation.

Option 1: Via n8n UI (Recommended)

1. Go to Settings → Community Nodes
2. Click Install
3. Enter n8n-nodes-excel-csv-processor
4. Click Install

Option 2: Via npm

npm install n8n-nodes-excel-csv-processor

Operations

Process Excel/CSV File

Process Excel or CSV files with advanced configuration options.

Parameters

Binary Property (required)

• Name of the binary property containing the Excel or CSV file
• Default: data

Sheet Settings (for Excel files)

• Sheet Index: Which sheet to read (0 = first sheet)
• Default: 0

Row Settings

• Skip Rows (Before Headers): Number of rows to skip before the header row(s)
• Header Rows: Number of rows used for headers
• Header Offset: Number of rows between header and data start
• Footer Rows: Number of rows to remove from the end

CSV Settings

• Delimiter: CSV delimiter character
  • Use \t for tab
  • Use \n for newline
  • Default: , (comma)

Column Settings

• Skip Columns (From Start): Number of columns to skip from the beginning
• End Columns: Number of columns to skip from the end

Output Format

• Both (JSON + CSV): Output data as JSON and create a processed CSV/Excel file
• JSON Only: Output only the parsed JSON data
• CSV Only: Output only a processed CSV file
• Excel Only: Output only a processed Excel file

Usage Examples

Example 1: Process Excel with Title Rows

If your Excel file has 2 title rows before the header:

• Set Skip Rows (Before Headers) to 2
• Set Header Rows to 1

Example 2: Process Tab-Delimited CSV

For tab-separated files:

• Set Delimiter to \t

Example 3: Remove Summary Rows

If your file has 3 summary rows at the bottom:

• Set Footer Rows to 3

Example 4: Skip First Column

To ignore the first column (e.g., row numbers):

• Set Skip Columns (From Start) to 1

Compatibility

This node was developed and tested with:

• n8n version: 1.0+
• Node.js: >=20.15

Resources

• n8n community nodes documentation
• GitHub repository

License

MIT

Author

Ohad Cohen – ohad.cohen@ryzebeyond.com