CSV Tools

to-json: Convert CSV to JSON

string

required

CSV string to convert.

boolean

default:"true"

First row is headers.

string

default:","

Field delimiter.

boolean

default:"true"

Skip empty lines.

Example request:

{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle"
}

Example response:

{
  "items": [
    { "name": "Alice", "age": 30, "city": "Portland" },
    { "name": "Bob", "age": 25, "city": "Seattle" }
  ],
  "count": 2
}

from-json: Convert JSON to CSV

object[]

required

Array of objects to convert.

string[]

Specific columns to include.

string

default:","

Field delimiter.

boolean

default:"true"

Include header row.

boolean

default:"false"

Quote all fields.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "data": [
    { "name": "Alice", "age": 30, "city": "Portland" },
    { "name": "Bob", "age": 25, "city": "Seattle" }
  ],
  "columns": ["name", "city"]
}

Example response:

{
  "csv": "name,city\nAlice,Portland\nBob,Seattle",
  "rows": 2
}

parse: Parse CSV with options

Parse CSV with detailed configuration.

string

required

CSV string to parse.

string

Field delimiter.

string

Newline character.

string

default:"\""

Quote character.

string

default:"\""

Escape character.

boolean

default:"true"

First row is headers.

boolean

default:"true"

Auto-convert values to numbers.

boolean

default:"true"

Skip empty lines.

number

Only parse the first N rows.

Example request:

{
  "csv": "product;price;stock\nWidget;9.99;150\nGadget;24.50;75\nDoohickey;4.99;300",
  "delimiter": ";",
  "preview": 2
}

Example response:

{
  "items": [
    { "product": "Widget", "price": 9.99, "stock": 150 },
    { "product": "Gadget", "price": 24.5, "stock": 75 }
  ],
  "count": 2,
  "meta": {
    "delimiter": ";",
    "linebreak": "\n",
    "fields": ["product", "price", "stock"]
  }
}

filter: Filter rows by condition

string

required

CSV string.

string

required

Column name to filter on.

string

required

Operator: equals, not_equals, contains, not_contains, gt, gte, lt, lte, or regex.

string | number

required

Value to compare.

string

default:","

Field delimiter.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland",
  "column": "city",
  "operator": "equals",
  "value": "Portland"
}

Example response:

{
  "csv": "name,age,city\nAlice,30,Portland\nCarol,35,Portland",
  "rows": 2
}

sort: Sort rows

string

required

CSV string.

string[]

required

Columns to sort by.

string[]

Sort order for each column: asc or desc.

string

default:","

Field delimiter.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland",
  "columns": ["city", "age"],
  "orders": ["asc", "desc"]
}

Example response:

{
  "csv": "name,age,city\nCarol,35,Portland\nAlice,30,Portland\nBob,25,Seattle",
  "rows": 3
}

dedupe: Remove duplicate rows

string

required

CSV string.

string[]

Columns to check for uniqueness (all columns if omitted).

boolean

default:"true"

Keep the first occurrence (or last if false).

string

default:","

Field delimiter.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "csv": "name,department\nAlice,Engineering\nBob,Sales\nCarol,Engineering\nDave,Sales",
  "columns": ["department"]
}

Example response:

{
  "csv": "name,department\nAlice,Engineering\nBob,Sales",
  "rows": 2
}

transform: Rename, reorder, or select columns

string

required

CSV string.

string[]

Columns to include.

object

Rename mapping (e.g., {"old_name": "new_name"}).

string

default:","

Field delimiter.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "csv": "first_name,last_name,email\nAlice,Smith,alice@example.com\nBob,Jones,bob@example.com",
  "rename": { "first_name": "firstName", "last_name": "lastName" },
  "select": ["firstName", "email"]
}

Example response:

{
  "csv": "firstName,email\nAlice,alice@example.com\nBob,bob@example.com",
  "rows": 2
}

merge: Merge multiple CSVs

string[]

required

Array of CSV strings to merge.

string

default:","

Field delimiter.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "csvs": [
    "name,role\nAlice,Admin",
    "name,role\nBob,User\nCarol,Editor"
  ]
}

Example response:

{
  "csv": "name,role\nAlice,Admin\nBob,User\nCarol,Editor",
  "rows": 3
}

info: Get CSV statistics

string

required

CSV string.

string

default:","

Field delimiter.

number

default:"3"

Number of sample rows to include.

Example request:

{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland\nDave,28,Denver",
  "sampleSize": 2
}

Example response:

{
  "rowCount": 4,
  "columnCount": 3,
  "columns": ["name", "age", "city"],
  "delimiter": ",",
  "sample": [
    { "name": "Alice", "age": 30, "city": "Portland" },
    { "name": "Bob", "age": 25, "city": "Seattle" }
  ]
}

add-column: Add a new column

string

required

CSV string.

string

required

New column name.

string | number | boolean

required

Fixed value or column reference (e.g., $existingColumn).

string

default:","

Field delimiter.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "csv": "name,age\nAlice,30\nBob,25",
  "columnName": "status",
  "value": "active"
}

Example response:

{
  "csv": "name,age,status\nAlice,30,active\nBob,25,active",
  "rows": 2
}

slice: Get a range of rows

string

required

CSV string.

number

default:"0"

Start index.

number

End index (exclusive).

string

default:","

Field delimiter.

enum

default:"utf8"

Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.

Example request:

{
  "csv": "name,age\nAlice,30\nBob,25\nCarol,35\nDave,28",
  "start": 1,
  "end": 3
}

Example response:

{
  "csv": "name,age\nBob,25\nCarol,35",
  "rows": 2
}

Overview

Integrations

Remote MCP Servers

Databases

Data Processing

Text and Strings

Numbers and Dates

Files and Media

Encoding and Validation

Developer Tools

Tools

​Tools

Tools