What types of operations can I perform on my CSV?

You can rename columns, add new calculated columns, remove columns, convert data types, perform complex calculations, and filter rows based on specific conditions.

How do I define the transformation rules?

Transformation rules are defined using a JSON array format in the 'Transformations' field, where each object specifies the operation type and relevant parameters.

Can I output the result in a format other than CSV?

Yes, the tool supports exporting your processed data as CSV, JSON, or a summary report.

How does the tool handle errors during processing?

You can configure error handling to either skip the problematic row, keep the original value, set it to empty, or throw an error to stop the process.

Is there a limit to the number of transformations I can apply?

You can chain multiple operations within the JSON array to perform complex data manipulation in a single pass.

Elysia Tools

Navigation

Data Processing

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

Execution

Run this tool

Fill in the form, run the tool, and review the result in one place.

Result

Ready for a run

Run the tool to preview files, text, structured data, or streamed output here.

Samples

CSV Transformer

Run this tool

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

Inputs

Result

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Overview

When to use

How it works

Use cases

Examples

1. Calculate Order Totals

2. Filter Active Customers

FAQ

CSV Samples

Python Samples

WebRTC Real-Time Communication Samples

Apache Arrow Samples

BOM Character Remover

Data Range Limiter

CSV File Merger

PDF Table Extractor to CSV/JSON

CSV Cleanup and Table Reshaping Tools

JSON Interchange and Format Translation Tools

CSV Export and Table Conversion Tools

JSON Inspection, Diff, and Transformation Tools