Best Data Transformation Tools in 2026
Updated
In short: KNIME Analytics Platform is ranked #1 of 36 as of 4 October 2026, ahead of jq and OpenRefine. The best-ranked option with a free plan is jq. The lowest first paid tier on this page is AWS Glue DataBrew at $0.48/mo.
Data transformation tools help turn data into forms that suit downstream work. Compared on supported data formats and transformation interface, these entries also differ in data quality checks, version control and workflow orchestration. Deployment model can help you assess how each fits your environment; free-plan availability and paid-from pricing add cost context. KNIME Analytics Platform, jq and OpenRefine are among the named options to consider. Think about the data you need to reshape, the way you want to build transformations and how you will manage them over time. The listed capabilities offer practical dimensions for comparing tools against those needs.
36 data transformation tools ranked on what their makers publish — plans and prices, free tiers, platforms and the facts on their own pages.
36ranked
15free plans on this page
$0.48/molowest paid tier
4 Oct 2026last checked
Input list Data Transformation Tools 25 channels on this page · 94 of 200 spec lines stated by the makers
Ch Tool Free planPaid fromDeployment modelTransformation interfaceSupported data formatsVersion controlWorkflow orchestrationData quality checks Spec sheet Score
01 KNIME Analytics Platform Free planYesPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 7.5
02 jq Free planYesPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 7.3
03 OpenRefine Free planYesPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 7.2
04 Apache Beam Free plannot statedPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 0/8spec lines stated 7.1
05 Bruin for Customer Success Free planYesPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 7.1
06 Coalesce Catalog Free planYesPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 7.1
07 csvkit Free planYesPaid fromnot statedDeployment modelself hostedTransformation interfacecodeSupported data formatsCSV, DBF, fixed-width, GeoJSON, JSON, NDJSON, XLS, XLSX; gzip, bz2 and xz-compressed CSV inputVersion controlnot statedWorkflow orchestrationYesData quality checksYes 6/8spec lines stated 7.1
08 dbt Semantic Layer Free planYesPaid fromnot statedDeployment modelcloudTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 2/8spec lines stated 7.1
09 Matillion Transform Free plannot statedPaid fromnot statedDeployment modelhybridTransformation interfacevisualSupported data formatsJSON, AVROVersion controlYesWorkflow orchestrationYesData quality checksYes 6/8spec lines stated 7.1
10 Apache Hop Free planYesPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 7.0
11 IRI DarkShield Free planNoPaid fromnot statedDeployment modelhybridTransformation interfacecodeSupported data formatsDelimited, fixed, line sequential, record sequential, variable sequential, blocked, CSV, JSON, LDIF, XML, COBOL, ODBC tables, Excel, Kafka, MQTT, S3, Azure Blob, GCP storage, HDFSVersion controlYesWorkflow orchestrationYesData quality checksYes 7/8spec lines stated 7.0
12 Cube Free planYesPaid from$40/moDeployment modelhybridTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 3/8spec lines stated 6.9
13 Prophecy Free planYesPaid fromnot statedDeployment modelcloudTransformation interfacevisualSupported data formatsCSV, TSV, JSON, text, XLSX, XLS, XML, fixed-width, ParquetVersion controlYesWorkflow orchestrationYesData quality checksYes 7/8spec lines stated 6.9
14 Centerprise Data Integrator Free planNoPaid fromnot statedDeployment modelhybridTransformation interfacevisualSupported data formatsCSV, Excel, fixed-length text, XML, JSON, COBOL, SQL, PDF, database tablesVersion controlYesWorkflow orchestrationYesData quality checksYes 7/8spec lines stated 6.8
15 Dataform Free planYesPaid fromnot statedDeployment modelcloudTransformation interfacesqlSupported data formatsSQLX, JavaScript, JSONVersion controlYesWorkflow orchestrationYesData quality checksYes 7/8spec lines stated 6.7
16 Kedro Free planYesPaid fromnot statedDeployment modelself hostedTransformation interfacecodeSupported data formatsCSV, Excel, Parquet, Feather, HDF5, JSON, SQL tables, SQL queries, Spark DataFrames, XML, Delta tables, PickleVersion controlYesWorkflow orchestrationnot statedData quality checksYes 6/8spec lines stated 6.7
17 Pentaho Data Integration Free planNoPaid fromnot statedDeployment modelhybridTransformation interfacevisualSupported data formatsFlat files, relational databases, Hadoop, NoSQL, cloud storage, JSON, XML, ParquetVersion controlYesWorkflow orchestrationYesData quality checksYes 7/8spec lines stated 6.5
18 Tableau Free planYesPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 6.5
19 Visitran Free planYesPaid fromnot statedDeployment modelcloudTransformation interfacevisualSupported data formatsnot statedVersion controlYesWorkflow orchestrationYesData quality checksYes 6/8spec lines stated 6.5
20 AWS Glue DataBrew Free planNoPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 6.4
21 Datameer Free planNoPaid fromnot statedDeployment modelnot statedTransformation interfacenot statedSupported data formatsnot statedVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 1/8spec lines stated 6.4
22 Rocky Free planYesPaid fromnot statedDeployment modelself hostedTransformation interfacesqlSupported data formatsSQL; TOML; warehouse tables including Delta and Iceberg (adapter support varies)Version controlYesWorkflow orchestrationYesData quality checksYes 7/8spec lines stated 6.2
23 Fugue Free planYesPaid fromnot statedDeployment modelself hostedTransformation interfacecodeSupported data formatsDataFrame-based inputs; Parquet files are shown in examplesVersion controlnot statedWorkflow orchestrationNoData quality checksNo 6/8spec lines stated 6.1
24 dplyr Free planYesPaid fromnot statedDeployment modelself hostedTransformation interfacecodeSupported data formatsdata frames, tibblesVersion controlnot statedWorkflow orchestrationnot statedData quality checksnot stated 4/8spec lines stated 6.0
25 Miller Free plannot statedPaid fromnot statedDeployment modelself hostedTransformation interfacecodeSupported data formatsCSV, TSV, ASV, USV, JSON, JSON Lines, YAML, PPRINT, Markdown, XTAB, DKVP, DKVPX, NIDX, DCF, recutilsVersion controlnot statedWorkflow orchestrationnot statedData quality checksYes 4/8spec lines stated 6.0
Is your tool on this list?
Numbered spots on this list can be sponsored. They are labelled, and the editorial order and scores never change for payment.
Questions about this list
Which data transformation tool is ranked first on Specifiction?
KNIME Analytics Platform is ranked #1 of 36 with a score of 7.5. jq is second and OpenRefine third.
How many of these have a free plan?
15 of the 25 on this page publish a free plan on their own pricing pages.
Which is the cheapest paid option?
On this page, AWS Glue DataBrew has the lowest first paid tier we found: $0.48/mo.
How is this list ranked?
Ranked on what each maker publishes, the fullest spec sheet first: how deeply the product is documented, the platforms it runs on, a free tier or trial to test it, and its standing. Paid placements never change a rank.
More in Developer Tools
All developer tools listsAccessibility Testing Software 168Log Management Software 107AI Coding Assistants 103Package Managers 93AI Agent Platforms 73Reverse Engineering Tools 73Software Composition Analysis Software 65Browser Automation Tools 63Integrated Development Environments 62Artifact repository software 60Code Playground Software 58Network Monitoring 56