Excel/CSV Processor (csv-parse) icon

Excel/CSV Processor (csv-parse)

Process Excel and CSV files with configurable row and column offsets using csv-parse

Excel/CSV Processor (csv-parse)

AI-generated

Summary

Parse and process Excel or CSV files from binary input using configurable sheet, row, column, and CSV delimiter settings, outputting the data as JSON, CSV, Excel file, or both.

Inputs

  • Binary Property (required) — Name of the binary property containing the Excel (.xls, .xlsx) or CSV file to process.
  • Sheet Settings — Specify which Excel sheet to read by index (only applicable to Excel files). Default is the first sheet (index 0).
  • Row Settings — Configure how many rows to skip before headers, how many header rows to use, the offset between headers and data, and how many footer rows to remove.
  • CSV Settings — Set the delimiter character for CSV parsing. Defaults to comma (,). Supports special characters like tab (\t) and newline (\n).
  • Column Settings — Configure how many columns to skip from the start and how many to skip from the end of each row.
  • Output Format — Choose whether to output JSON data, CSV or Excel file binaries, or both JSON and file formats.

Output shape

a list of items containing processed data rows as JSON objects and/or binary data with processed CSV/Excel file depending on output format

If output includes files (CSV or Excel), a single item with binary data is returned per input item, while JSON output produces one item per data row. When both JSON and file output are selected, JSON items include a reference to the binary file item. Errors on processing individual items are handled based on node settings (continue on fail or error out). This node works with input items containing a binary property holding the file.

Links

Discussion