Categories

← View All Tools

CSV Transformer

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"}]

Click to upload file or drag and drop file here

Maximum file size: 10MB

Key Facts

Category
Data Processing
Input Types
file, textarea, select, checkbox
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

CSV Transformer is an online data processing tool for 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"}]. It is especially useful when working with json, csv content.

When to Use

  • •Use it when you need to convert json, csv content quickly in the browser.
  • •Helpful for data processing workflows that need repeatable inputs and fast results.
  • •A good fit when you want to test with real files before running the same workflow in code or API calls.

How It Works

  • •Provide CSV File, Transformations (JSON), Output Format, Include Header Row as input to the tool.
  • •The tool processes the request and returns a file result.
  • •For file workflows, start with representative samples such as json, csv test files to verify edge cases and output quality.

Use Cases

Convert json, csv data during debugging or QA.
Validate expected output before using the API or automation flows.
Test the workflow with representative sample files and edge cases.

Try with Samples

json, csv, video
CSV Samples
Sample CSV files with various data types, sizes, and complexity levels
title token csv
json
WebRTC Real-Time Communication Samples
Comprehensive WebRTC samples for peer-to-peer audio/video communication, data channels, screen sharing, and signaling server implementation
preferred input family json
json
Python Samples
Essential Python code examples and Hello World demonstrations
preferred input family json
json
Hex/Unicode Encoding Format Samples
Examples of hex (\xXX) and unicode (\uXXXX) escape sequence encoding formats
preferred input family json
json

Related Hubs

Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Csv Convert Tools
Explore 37 csv tools for convert workflows and compare closely related utilities quickly.
Video Convert Tools
Explore 36 video tools for convert workflows and compare closely related utilities quickly.
Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.

FAQ

What does CSV Transformer do?

CSV Transformer helps you convert json, csv content online without setting up a separate local script or app.

When should I use this tool?

Use it when you need a quick convert workflow, want to verify output, or need a browser-based utility for data processing tasks.

Can I try this tool with sample data?

Yes. This page can recommend related sample files so you can test the workflow immediately.

What inputs does CSV Transformer accept?

CSV Transformer accepts CSV File, Transformations (JSON), Output Format, Include Header Row and supports file uploads for 1 field.

Is there an API for CSV Transformer?

Yes. The tool page includes an API endpoint so you can move from manual testing to scripted usage.

API Documentation

Request Endpoint

POST /en/api/tools/csv-transformer

Request Parameters

Parameter Name Type Required Description
csvFile file (Upload required) Yes -
transformations textarea Yes -
outputFormat select No -
includeHeader checkbox No -
handleErrors select No -
errorHandling select No -

File type parameters need to be uploaded first via POST /upload/csv-transformer to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "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)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server 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.

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\"}]",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=csv-transformer",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]