Developer Tools·Standings
Best Data Transformation Tools in 2026
Data transformation tools change data into usable forms; compare their deployment model, transformation interface, and supported formats first.
Use the signal score out of 10 as a quick comparison, then check the API, open-source, and free-tier marks. Pricing and platform support add practical context.
- 37 platforms
- 1 with a public API on this page
- 25 with a free tier
- Checked 23 Sept 2026
- 1 AH
Apache Hophop.apache.orgOpen-source visual pipelines and workflows connect databases and run locally or on clusters.
- 2 AB
Apache Beambeam.apache.orgApache Beam is an open-source programming model for building batch and streaming data-processing pipelines.
- 3 BF
Bruin for Customer Successgetbruin.comOpen-source customer data tool provides health scores and answers questions in chat apps.
- 4 C
Cubecube.devCube is an agentic analytics platform built on a semantic layer for business users and AI agents.
- 5 Jjqjqlang.org
jq is a lightweight, flexible command-line JSON processor for slicing, filtering, mapping, and transforming structured data.
- 6 B
Bonobobonobo-project.orgOpen-source Python framework builds parallel ETL pipelines from connected components.
- 7 DT
data.tablerdatatable.gitlab.ioAn R package for fast table filtering, grouping, joins, column changes, and file reads and writes.
- 8 IIbisibis-project.org
Ibis is a portable Python dataframe library that provides one API for more than 20 data backends.
- 9 Ddplyrdplyr.tidyverse.org
An R toolkit for filtering, grouping, summarising, arranging, and joining data frames.
- 10 O
OpenRefineopenrefine.orgA free open-source tool for cleaning, transforming, and clustering messy data through a web interface.
- 11 P
Polarspola.rsOpen-source DataFrame library uses a multithreaded engine for single-machine processing.
- 12 MMalloymalloydata.dev
Open-source language defines reusable data logic and turns queries into database-specific SQL.
- 13 Ccsvkitcsvkit.readthedocs.io
Command-line suite converts, cleans, joins, filters, and analyzes CSV files.
- 14 CC
Coalesce Catalogcoalesce.ioData catalog uses AI search to find tables, dashboards, columns and domains, with ownership and definitions.
- 15 AG
AWS Glue DataBrewaws.amazon.comVisual tool cleans and profiles data with 250+ built-in transformations, without writing code.
- 16 DS
dbt Semantic Layergetdbt.comThe Semantic Layer centralizes metric definitions in dbt and generates queries with joins for downstream tools.
- 17 KA
KNIME Analytics Platformknime.comKNIME Analytics Platform creates visual workflows for data access, transformation, analysis, modeling, and visualization.
- 18 Ppandaspandas.pydata.org
An open-source Python library for tabular analysis with DataFrames and support for many file formats.
- 19 D
dbplyrdbplyr.tidyverse.orgAn R backend that sends dplyr work to remote database tables as SQL queries.
- 20 MMillermiller.readthedocs.io
A command-line tool for querying, reshaping, and converting named-field data files in several formats.
- 21 TTableautableau.com
- 22 MT
Matillion Transformmatillion.comA visual, low-code tool for building data transformation pipelines for AI and analytics.
- 23 P
Prophecyprophecy.aiAI-assisted visual workflows prepare data for Databricks, Snowflake, and BigQuery.
- 24 L
LANSAlansa.comLow-code tools build web, mobile, and desktop apps while modernizing IBM i systems.
- 25 D
Daftdaft.aiA Python data engine for multimodal AI workloads that runs locally or across machines.
Places #1, #2, #3, #4, #5 on this board are open to sponsors. Take #1 · Other ways to advertise
How to choose
Which platforms does it need to run on?
Check whether the tool runs on Linux, Windows, macOS, the web, a self-hosted environment, or through an API.
Choose deployment options that fit where your existing data and applications run.
What pricing and trial options should I compare?
Compare the free plan, paid starting price, and any free trial before choosing.
Examples include free tools such as Apache Beam and Apache Hop, Cube with a free plan and paid plans from $40 per month, and Coalesce Catalog with a 30-day trial and paid plans from $150 per user per month annually.
Which transformation interface and data formats fit?
Compare the transformation interface and supported data formats against the way your team prepares data.
These fields show whether a tool matches the inputs and working style you already use.
Does it support version control and workflow orchestration?
Check version-control support and workflow-orchestration features when transformations must be reviewed, scheduled, or coordinated.
Use these comparisons to match the tool to your process.
How does it handle data quality checks?
Review the data-quality checks offered before selecting a tool.
Checks can help you assess whether transformed data meets the conditions your workflow requires.
Questions
Which data transformation tools have a free plan?
Examples with free plans include Apache Beam, Apache Hop, Cube, dbt Semantic Layer, Dataform, Polars, Prophecy, and AWS Glue DataBrew.
Can I use an open-source data transformation tool?
Yes. Apache Beam, Apache Hop, Ibis, and Malloy are listed as open source.
Which platforms can these tools run on?
Platform options represented here include Linux, Windows, macOS, web, self-hosted deployment, and an API.
What are typical paid starting prices?
Examples include Cube from $40 per month, dbt Semantic Layer from $100 per user per month, and Prophecy from $150 per user per month.
Are free trials available for data transformation tools?
Coalesce Catalog and Polars list 30-day free trials.
Some top positions on this board can be paid placements, standing where they were sold. The facts on each platform are not for sale. How we rank · Disclosure