> ## Documentation Index
> Fetch the complete documentation index at: https://docs.spojit.com/llms.txt
> Use this file to discover all available pages before exploring further.
# CSV Tools
> Parse, convert, filter, sort, and transform CSV data.
The CSV Tools connector provides operations for working with CSV data: parsing, converting to and from JSON, filtering rows, and transforming columns.
No connection required; this utility connector works out of the box.
## Tools
CSV string to convert.
First row is headers.
Field delimiter.
Skip empty lines.
**Example request:**
```json theme={null}
{
"csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle"
}
```
**Example response:**
```json theme={null}
{
"items": [
{ "name": "Alice", "age": 30, "city": "Portland" },
{ "name": "Bob", "age": 25, "city": "Seattle" }
],
"count": 2
}
```
Array of objects to convert.
Specific columns to include.
Field delimiter.
Include header row.
Quote all fields.
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:**
```json theme={null}
{
"data": [
{ "name": "Alice", "age": 30, "city": "Portland" },
{ "name": "Bob", "age": 25, "city": "Seattle" }
],
"columns": ["name", "city"]
}
```
**Example response:**
```json theme={null}
{
"csv": "name,city\nAlice,Portland\nBob,Seattle",
"rows": 2
}
```
Parse CSV with detailed configuration.
CSV string to parse.
Field delimiter.
Newline character.
Quote character.
Escape character.
First row is headers.
Auto-convert values to numbers.
Skip empty lines.
Only parse the first N rows.
**Example request:**
```json theme={null}
{
"csv": "product;price;stock\nWidget;9.99;150\nGadget;24.50;75\nDoohickey;4.99;300",
"delimiter": ";",
"preview": 2
}
```
**Example response:**
```json theme={null}
{
"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"]
}
}
```
CSV string.
Column name to filter on.
Operator: `equals`, `not_equals`, `contains`, `not_contains`, `gt`, `gte`, `lt`, `lte`, or `regex`.
Value to compare.
Field delimiter.
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:**
```json theme={null}
{
"csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland",
"column": "city",
"operator": "equals",
"value": "Portland"
}
```
**Example response:**
```json theme={null}
{
"csv": "name,age,city\nAlice,30,Portland\nCarol,35,Portland",
"rows": 2
}
```
CSV string.
Columns to sort by.
Sort order for each column: `asc` or `desc`.
Field delimiter.
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:**
```json theme={null}
{
"csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland",
"columns": ["city", "age"],
"orders": ["asc", "desc"]
}
```
**Example response:**
```json theme={null}
{
"csv": "name,age,city\nCarol,35,Portland\nAlice,30,Portland\nBob,25,Seattle",
"rows": 3
}
```
CSV string.
Columns to check for uniqueness (all columns if omitted).
Keep the first occurrence (or last if false).
Field delimiter.
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:**
```json theme={null}
{
"csv": "name,department\nAlice,Engineering\nBob,Sales\nCarol,Engineering\nDave,Sales",
"columns": ["department"]
}
```
**Example response:**
```json theme={null}
{
"csv": "name,department\nAlice,Engineering\nBob,Sales",
"rows": 2
}
```
CSV string.
Columns to include.
Rename mapping (e.g., `{"old_name": "new_name"}`).
Field delimiter.
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:**
```json theme={null}
{
"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:**
```json theme={null}
{
"csv": "firstName,email\nAlice,alice@example.com\nBob,bob@example.com",
"rows": 2
}
```
Array of CSV strings to merge.
Field delimiter.
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:**
```json theme={null}
{
"csvs": [
"name,role\nAlice,Admin",
"name,role\nBob,User\nCarol,Editor"
]
}
```
**Example response:**
```json theme={null}
{
"csv": "name,role\nAlice,Admin\nBob,User\nCarol,Editor",
"rows": 3
}
```
CSV string.
Field delimiter.
Number of sample rows to include.
**Example request:**
```json theme={null}
{
"csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland\nDave,28,Denver",
"sampleSize": 2
}
```
**Example response:**
```json theme={null}
{
"rowCount": 4,
"columnCount": 3,
"columns": ["name", "age", "city"],
"delimiter": ",",
"sample": [
{ "name": "Alice", "age": 30, "city": "Portland" },
{ "name": "Bob", "age": 25, "city": "Seattle" }
]
}
```
CSV string.
New column name.
Fixed value or column reference (e.g., `$existingColumn`).
Field delimiter.
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:**
```json theme={null}
{
"csv": "name,age\nAlice,30\nBob,25",
"columnName": "status",
"value": "active"
}
```
**Example response:**
```json theme={null}
{
"csv": "name,age,status\nAlice,30,active\nBob,25,active",
"rows": 2
}
```
CSV string.
Start index.
End index (exclusive).
Field delimiter.
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:**
```json theme={null}
{
"csv": "name,age\nAlice,30\nBob,25\nCarol,35\nDave,28",
"start": 1,
"end": 3
}
```
**Example response:**
```json theme={null}
{
"csv": "name,age\nBob,25\nCarol,35",
"rows": 2
}
```