Best Data Transformation Tools in 2026
Updated
Preparing data for downstream use means choosing a way to define, manage, and run transformations that suits your workflow. Compared on supported data formats and transformation interface, these tools also vary in data quality checks, version control, and workflow orchestration. Deployment model can matter when fitting a tool into an existing stack, while free-plan availability and paid-from pricing help frame the cost. Prophecy, Coalesce Catalog, and Cube are among the named options to consider. Look at how each handles the data you work with and the way your team builds and coordinates transformation tasks.
Data Transformation Tools, one module each.A lit port is something its maker publishes; 16 of 16 with a known API signal have a public API.
- 01 Ibis API yesFREE yesDOCS 7.3Free
- 02 Prophecy API yesFREE yesDOCS 7.3$150/mo
- 03 Coalesce Catalog API yesFREE yesDOCS 7.2$150/mo
- 04 Cube API yesFREE yesDOCS 7.2$40/mo
- 05 Dataform API yesFREE yesDOCS 7.2Free
- 06 dbt Semantic Layer API yesFREE yesDOCS 7.2$100/mo
- 07 Polars API yesFREE yesDOCS 7.2Free
- 08 Apache Beam API yesFREE yesDOCS 7.1Free
- 09 Bruin for Customer Success API yesFREE yesDOCS 7.1Free
- 10 Malloy API yesDOCS 6.8
- 11 Alteryx Designer API yesFREE noDOCS 6.7$250/mo
- 12 IRI DarkShield API yesDOCS 6.7
- 13 LANSA API yesDOCS 6.7
- 14 AWS Glue DataBrew API yesFREE noDOCS 6.6$0.48/mo
- 15 Centerprise Data Integrator API yesDOCS 6.6
- 16 Datameer API yesDOCS 6.6
- 17 Bonobo FREE yesDOCS 5.9Free
- 18 data.table FREE yesDOCS 5.9Free
- 19 dplyr FREE yesDOCS 5.9Free
- 20 jq FREE yesDOCS 5.9Free
- 21 csvkit FREE yesDOCS 5.8Free
- 22 dbplyr FREE yesDOCS 5.8Free
- 23 Kedro FREE yesDOCS 5.8Free
- 24 KNIME Analytics Platform FREE yesDOCS 5.8Free
- 25 Matillion Transform FREE yesDOCS 5.8Free
Compare all 25 in a table
| # | Platform | Score | Free plan | From | Free plan | Paid from | Deployment model | Transformation interface |
|---|---|---|---|---|---|---|---|---|
| 1 | Ibis | 7.3 | Free plan | Free | self_hosted | code | ||
| 2 | Prophecy | 7.3 | Free plan | $150/mo | Yes | cloud | visual | |
| 3 | Coalesce Catalog | 7.2 | Free plan | $150/mo | Yes | |||
| 4 | Cube | 7.2 | Free plan | $40/mo | Yes | 40 /mo | hybrid | |
| 5 | Dataform | 7.2 | Free plan | Free | Yes | cloud | sql | |
| 6 | dbt Semantic Layer | 7.2 | Free plan | $100/mo | Yes | cloud | ||
| 7 | Polars | 7.2 | Free plan | Free | Yes | hybrid | code | |
| 8 | Apache Beam | 7.1 | Free plan | Free | ||||
| 9 | Bruin for Customer Success | 7.1 | Free plan | Free | Yes | |||
| 10 | Malloy | 6.8 | self_hosted | |||||
| 11 | Alteryx Designer | 6.7 | No | $250/mo | No | |||
| 12 | IRI DarkShield | 6.7 | No | hybrid | code | |||
| 13 | LANSA | 6.7 | ||||||
| 14 | AWS Glue DataBrew | 6.6 | No | $0.48/mo | No | |||
| 15 | Centerprise Data Integrator | 6.6 | No | hybrid | visual | |||
| 16 | Datameer | 6.6 | No | |||||
| 17 | Bonobo | 5.9 | Free plan | Free | self_hosted | code | ||
| 18 | data.table | 5.9 | Free plan | Free | Yes | self_hosted | code | |
| 19 | dplyr | 5.9 | Free plan | Free | Yes | self_hosted | code | |
| 20 | jq | 5.9 | Free plan | Free | Yes | |||
| 21 | csvkit | 5.8 | Free plan | Free | Yes | self_hosted | code | |
| 22 | dbplyr | 5.8 | Free plan | Free | Yes | code | ||
| 23 | Kedro | 5.8 | Free plan | Free | Yes | self_hosted | code | |
| 24 | KNIME Analytics Platform | 5.8 | Free plan | Yes | ||||
| 25 | Matillion Transform | 5.8 | Free plan | Free | hybrid | visual |
Is your platform on this list?
Numbered spots on this list can be sponsored, and a sponsored row is labelled as paid.