Data Processing
Select specific columns from CSV data by column names or indices. Perfect for extracting relevant data from large CSV files with many columns.
Call this tool from your code in three languages.
curl -X POST 'https://api.elysiatools.com/en/api/tools/csv-column-selector' \
-H 'Content-Type: application/json' \
-d '{"csvInput":"Enter your CSV data (first row should contain headers)...","delimiter":",","columnSelectionMethod":"by_name","selectedColumns":"Enter column names, indices, or ranges depending on selection method","outputDelimiter":",","includeHeader":true,"skipEmptyColumns":false,"trimValues":true}'Send a POST request with your inputs as JSON. File parameters require a separate upload first.
POST https://api.elysiatools.com/en/api/tools/csv-column-selector| Name | Type | Required | Description |
|---|---|---|---|
| csvInput | textarea | Yes | — |
| delimiter | select | Yes | — |
| columnSelectionMethod | select | Yes | — |
| selectedColumns | text | Yes | For "By Name": column1,column2,column3 For "By Index": 1,3,5 For "By Range": 1-3,5,7-9 |
| outputDelimiter | select | Yes |
Add this tool to your Model Context Protocol server so AI agents can list and call it.
Add this block to your MCP client configuration:
{
"mcpServers": {
"elysiatools-csv-column-selector": {
"name": "csv-column-selector",
"description": "Select specific columns from CSV data by column names or indices. Perfect for extracting relevant data from large CSV files with many columns.",
"baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=csv-column-selector",
"command": "",
"args": [],
"env": {},
"isActive": true,
"type": "sse"
}
}
}After connecting to the SSE endpoint, list the exposed tools:
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/list"
}Invoke the tool by its id, passing arguments built from its parameters:
{
"jsonrpc": "2.0",
"id": 2,
"method": "tools/call",
"params": {
"name": "csv-column-selector",
"arguments": {
"csvInput": "Enter your CSV data (first row should contain headers)...",
"delimiter": ",",
"columnSelectionMethod": "by_name",
"selectedColumns": "Enter column names, indices, or ranges depending on selection method",
"outputDelimiter": ",",
"includeHeader": true,
"skipEmptyColumns": false,
"trimValues": true
}
}
}| — |
| includeHeader | checkbox | No | — |
| skipEmptyColumns | checkbox | No | Remove columns that are completely empty in the data |
| trimValues | checkbox | No | Remove whitespace from beginning and end of cell values |
Text result
{
"result": "Processed text content",
"error": "Error message (optional)",
"message": "Notification message (optional)",
"metadata": {
"key": "value"
}
}Questions or issues? Contact [email protected]