CSV join | agent view
The same page content and links, with explicit tool capabilities. Tools marked with an API can run directly through HTTP. Other tools require the browser interface or are not connected yet.
Tool capabilities
{
"id": "csv-join",
"category": "spreadsheet-tools",
"built": true,
"requirements": "Inner/left/full joins on explicit keys; duplicate-key cardinality warning and preview.",
"implementation": {
"fields": [
{
"key": "delimiter",
"label": "CSV separator",
"value": ",",
"type": "select",
"values": [
",",
";",
"\t"
]
},
{
"key": "key",
"label": "Join column",
"value": "id",
"type": "text"
},
{
"key": "type",
"label": "Join",
"value": "Inner",
"type": "select",
"values": [
"Inner",
"Left"
]
},
{
"key": "other",
"label": "Second CSV",
"value": "",
"type": "textarea"
}
],
"experience": {
"automatic": true,
"single": false,
"label": "CSV",
"placeholder": "name,score\nAda,98\nSam,92",
"help": "Include a header row. Quote cells that contain commas or new lines. Results update as you type. Up to 1,000,000 characters.",
"action": null
},
"mode": "automatic",
"interactive": false
},
"execution": "POST /api/v1/tools/csv-join/run",
"api": {
"id": "csv-join",
"name": "CSV join",
"category": "spreadsheet-tools",
"description": "Inner/left/full joins on explicit keys.",
"notes": "",
"human_path": "/en/spreadsheet-tools/csv-join/",
"method": "POST",
"endpoint": "/api/v1/tools/csv-join/run",
"schema_url": "/api/v1/tools/csv-join",
"input_schema": {
"type": "object",
"additionalProperties": false,
"properties": {
"input": {
"type": "string",
"maxLength": 1000000,
"default": "",
"description": "Plain text input. File tools use files instead unless otherwise documented."
},
"options": {
"type": "object",
"additionalProperties": false,
"properties": {
"delimiter": {
"type": "string",
"description": "CSV separator",
"default": ",",
"enum": [
",",
";",
"\t"
]
},
"key": {
"type": "string",
"description": "Join column",
"default": "id"
},
"type": {
"type": "string",
"description": "Join",
"default": "Inner",
"enum": [
"Inner",
"Left"
]
},
"other": {
"type": "string",
"description": "Second CSV",
"default": ""
}
}
}
}
},
"output_schema": {
"type": "object",
"required": [
"tool",
"result"
],
"properties": {
"tool": {
"type": "string"
},
"result": {
"type": "object",
"required": [
"text",
"files"
],
"properties": {
"text": {
"type": [
"string",
"null"
]
},
"data": {
"description": "Parsed JSON when the textual result is JSON."
},
"name": {
"type": "string"
},
"mime": {
"type": "string"
},
"files": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"mime",
"bytes",
"base64"
],
"properties": {
"name": {
"type": "string"
},
"mime": {
"type": "string"
},
"bytes": {
"type": "integer"
},
"base64": {
"type": "string",
"contentEncoding": "base64"
}
}
}
}
}
}
}
},
"processing": "Server; same transformation code as browser tools",
"limits": {
"request_bytes": 8388608,
"input_characters": 1000000,
"files_bytes": 5242880,
"max_files": 0,
"timeout_seconds": 12
}
},
"agent_processing": "Server; same transformation code as browser tools",
"browser_agent": {
"supported": true,
"name": "run_current_tool",
"discovery": "WebMCP on the human page in a supporting browser",
"verification": "See audit/API-AUDIT.md; availability is not verification"
}
}Page guide
Inner/left/full joins on explicit keys.
Useful next steps
How to use CSV join
- Enter csv in the input field.
- The result updates as you type. Adjust the available settings if needed.
- Review the result, then use Copy result or a download link when available.
Working with csv join
Spreadsheet tasks involve values, formulas, data types and presentation. A conversion may preserve the displayed value without preserving the formula that produced it. Identifiers, dates and locale-specific decimal separators deserve special attention.
Common questions
Why do identifiers lose leading zeros?
A spreadsheet can interpret a text identifier as a number. Once 00123 is treated as 123, formatting may be needed to display zeros again. Preserve the original value as text when its exact representation matters.
Does CSV keep formulas and multiple sheets?
CSV represents one flat table. It does not retain a workbook’s sheets, formatting or full formula behavior. Treat it as an exchange format for values and review how the receiving application interprets them.
Continue your workflow: Compare CSV, Merge CSV, CSV pivot.