Data Processing
Transform and process CSV data with column operations, calculations, and data type conversions. Supports renaming columns, adding calculated columns, removing columns, converting data types, calculating values, and filtering rows. Operation examples: • Rename column: [{"type": "rename", "column": "old_name", "new_name": "new_name"}] • Add calculated column: [{"type": "add_column", "new_column": "total", "formula": "price * quantity"}] • Remove column: [{"type": "remove_column", "remove_column": "column_to_remove"}] • Convert data type: [{"type": "convert_type", "convert_column": "age", "target_type": "number"}] • Calculate values: [{"type": "calculate", "target_column": "total", "expression": "price * tax + shipping"}] • Filter rows: [{"type": "filter_values", "filter_column": "status", "operator": "equals", "value": "active"}]
Call this tool from your code in three languages.
# 1) Upload each file first → returns { filePath }
curl -X POST 'https://api.elysiatools.com/upload/csv-transformer' \
-F 'file=@/path/to/csvFile.ext'
# 2) Call the tool with the returned filePath values
curl -X POST 'https://api.elysiatools.com/en/api/tools/csv-transformer' \
-F 'csvFile=/path/to/file.ext' \
-F 'transformations=Enter transformation operations in JSON format' \
-F 'outputFormat=csv' \
-F 'includeHeader=true' \
-F 'handleErrors=keep_original' \
-F 'errorHandling=log'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-transformer| Name | Type | Required | Description |
|---|---|---|---|
| csvFile | fileupload required | Yes | — |
| transformations | textarea | Yes | — |
| outputFormat | select | No | — |
| includeHeader | checkbox | No | — |
| handleErrors | select | No | — |
| errorHandling | select | No | — |
File result
{
"filePath": "/public/processing/randomid.ext",
"fileName": "output.ext",
"contentType": "application/octet-stream",
"size": 1024,
"metadata": {
"key": "value"
},
"error": "Error message (optional)",
"message": "Notification message (optional)"
}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-transformer": {
"name": "csv-transformer",
"description": "Transform and process CSV data with column operations, calculations, and data type conversions. Supports renaming columns, adding calculated columns, removing columns, converting data types, calculating values, and filtering rows.\n\nOperation examples:\n• Rename column: [{\"type\": \"rename\", \"column\": \"old_name\", \"new_name\": \"new_name\"}]\n• Add calculated column: [{\"type\": \"add_column\", \"new_column\": \"total\", \"formula\": \"price * quantity\"}]\n• Remove column: [{\"type\": \"remove_column\", \"remove_column\": \"column_to_remove\"}]\n• Convert data type: [{\"type\": \"convert_type\", \"convert_column\": \"age\", \"target_type\": \"number\"}]\n• Calculate values: [{\"type\": \"calculate\", \"target_column\": \"total\", \"expression\": \"price * tax + shipping\"}]\n• Filter rows: [{\"type\": \"filter_values\", \"filter_column\": \"status\", \"operator\": \"equals\", \"value\": \"active\"}]",
"baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=csv-transformer",
"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-transformer",
"arguments": {
"csvFile": "https://example.com/file.ext",
"transformations": "Enter transformation operations in JSON format",
"outputFormat": "csv",
"includeHeader": true,
"handleErrors": "keep_original",
"errorHandling": "log"
}
}
}Questions or issues? Contact [email protected]