Docs Navigation

Blocks

CSV Processor

Process and transform CSV data

Parse, transform, filter, and generate CSV data with support for various operations like sorting, filtering, and aggregation.

Back to Catalog

Toolscsv_processor

Block Preview

CSV Processor

Process and transform CSV data

Usage

Add the block to your workflow and connect it to the upstream step.
Configure any required credentials or tokens in the inputs.
Fill in required inputs and optional parameters for the run.
Run a test execution, inspect outputs, and iterate before deploying.
Deploy the csv_processor block with monitoring enabled in production.

Inputs (UI)

Operation

dropdown

Layout: full

Options: Parse CSV to JSON, Convert JSON to CSV, Filter CSV Data, Sort CSV Data

CSV Input

long-input

Placeholder: name,age,city John,30,New York Jane,25,Los Angeles

Layout: full

Condition: operation = ["parse","filter","sort","aggregate","transform","stats"]

JSON Input (Array of Objects)

code

Placeholder: [ { "name": "John", "age": 30, "city": "New York" }, { "name": "Jane", "age": 25, "city": "Los Angeles" } ]

Layout: full

Condition: operation = ["stringify"]

Delimiter

short-input

Placeholder: ,

Layout: half

Condition: operation = ["parse","stringify"]

Has Header

switch

Layout: half

Condition: operation = ["parse","filter","sort","aggregate","transform"]

Filter Expression (JavaScript)

code

Placeholder: // Return true to keep the row, false to filter it out // Example: Filter rows where age > 25 row.age > 25

Layout: full

Condition: operation = ["filter"]

Sort Column

short-input

Placeholder: age

Layout: half

Condition: operation = ["sort"]

Sort Direction

dropdown

Layout: half

Condition: operation = ["sort"]

Options: Ascending, Descending

Aggregate Column

short-input

Placeholder: age

Layout: half

Condition: operation = ["aggregate"]

Aggregate Function

dropdown

Layout: half

Condition: operation = ["aggregate"]

Options: Sum, Average, Min, Max

Group By Column

short-input

Placeholder: city

Layout: full

Condition: operation = ["aggregate"]

Transform Expression (JavaScript)

code

Placeholder: // Transform each row // Example: Convert age to dog years return { ...row, age: row.age * 7 };

Layout: full

Condition: operation = ["transform"]

Inputs (API)

operation

string

Required

csvInput

string

Optional

jsonInput

json

Optional

delimiter

string

Optional

header

boolean

Optional

filterExpression

string

Optional

sortColumn

string

Optional

sortDirection

string

Optional

aggregateColumn

string

Optional

aggregateFunction

string

Optional

groupByColumn

string

Optional

transformExpression

string

Optional

Outputs

Primary response type:

{
  "success": "boolean",
  "data": "json",
  "csv": "string",
  "error": "string",
  "stats": "json"
}

Tool Access

csv_processor