n8n-nodes-csv-normalizer

Smart CSV/Excel normalizer for n8n workflows.

Features

• Auto-detect file encoding (UTF-8, Latin-1, UTF-16)
• Normalize headers to snake_case
• Remove empty rows and columns
• Trim whitespace from all fields
• Convert dates to ISO format (YYYY-MM-DD)
• Coerce numeric strings to numbers
• Custom column name mappings
• Support for both CSV and Excel files

Installation

In n8n (Community Nodes)

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

Manual Installation

npm install n8n-nodes-csv-normalizer

Usage

Basic CSV Normalization

1. Add "CSV Normalizer" node to your workflow
2. Choose operation: Normalize CSV
3. Paste or use expression for CSV data
4. Configure options:
   • ✅ Normalize Headers
   • ✅ Trim Whitespace
   • ✅ Remove Empty Rows

Excel Normalization

1. Add "CSV Normalizer" node
2. Choose operation: Normalize Excel
3. Connect a binary file input
4. Configure normalization options

Example

Input CSV:

First Name,Last Name,  Email
  John  ,  Doe  ,john@example.com
  Jane  ,  Smith  ,jane@example.com

Output JSON:

[
  {
    "first_name": "John",
    "last_name": "Doe",
    "email": "john@example.com"
  },
  {
    "first_name": "Jane",
    "last_name": "Smith",
    "email": "jane@example.com"
  }
]

Options

License

MIT

Support

For issues and feature requests, please open an issue.