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. 1
    AH
    Apache Hophop.apache.org

    Open-source visual pipelines and workflows connect databases and run locally or on clusters.

    7.7 APIOpenFree Free tier
  2. 2
    AB
    Apache Beambeam.apache.org

    Apache Beam is an open-source programming model for building batch and streaming data-processing pipelines.

    7.7 APIOpenFree Free tier
  3. 3
    BF
    Bruin for Customer Successgetbruin.com

    Open-source customer data tool provides health scores and answers questions in chat apps.

    7.7 APIOpenFree Free tier · $0.01 usage-based
  4. 4
    C
    Cubecube.dev

    Cube is an agentic analytics platform built on a semantic layer for business users and AI agents.

    7.4 APIOpenFree Free tier · from $40/mo
  5. 5
    J
    jqjqlang.org

    jq is a lightweight, flexible command-line JSON processor for slicing, filtering, mapping, and transforming structured data.

    6.7 APIOpenFree Free tier
  6. 6
    B
    Bonobobonobo-project.org

    Open-source Python framework builds parallel ETL pipelines from connected components.

    6.6 APIOpenFree Free tier
  7. 7
    DT
    data.tablerdatatable.gitlab.io

    An R package for fast table filtering, grouping, joins, column changes, and file reads and writes.

    6.6 APIOpenFree Free tier
  8. 8
    I
    Ibisibis-project.org

    Ibis is a portable Python dataframe library that provides one API for more than 20 data backends.

    6.6 APIOpenFree Free tier
  9. 9
    D
    dplyrdplyr.tidyverse.org

    An R toolkit for filtering, grouping, summarising, arranging, and joining data frames.

    6.6 APIOpenFree Free tier
  10. 10
    O
    OpenRefineopenrefine.org

    A free open-source tool for cleaning, transforming, and clustering messy data through a web interface.

    6.5 APIOpenFree Free tier
  11. 11
    P
    Polarspola.rs

    Open-source DataFrame library uses a multithreaded engine for single-machine processing.

    6.5 APIOpenFree Free tier
  12. 12
    M
    Malloymalloydata.dev

    Open-source language defines reusable data logic and turns queries into database-specific SQL.

    6.4 APIOpenFree Free tier
  13. 13
    C
    csvkitcsvkit.readthedocs.io

    Command-line suite converts, cleans, joins, filters, and analyzes CSV files.

    6.4 APIOpenFree Free tier
  14. 14
    CC
    Coalesce Catalogcoalesce.io

    Data catalog uses AI search to find tables, dashboards, columns and domains, with ownership and definitions.

    6.3 APIOpenFree Free tier · from $150/mo
  15. 15
    AG
    AWS Glue DataBrewaws.amazon.com

    Visual tool cleans and profiles data with 250+ built-in transformations, without writing code.

    6.3 APIOpenFree Free tier
  16. 16
    DS
    dbt Semantic Layergetdbt.com

    The Semantic Layer centralizes metric definitions in dbt and generates queries with joins for downstream tools.

    6.3 APIOpenFree Free tier · from $100/mo
  17. 17
    KA
    KNIME Analytics Platformknime.com

    KNIME Analytics Platform creates visual workflows for data access, transformation, analysis, modeling, and visualization.

    6.3 APIOpenFree Free tier · from $19/mo
  18. 18
    P
    pandaspandas.pydata.org

    An open-source Python library for tabular analysis with DataFrames and support for many file formats.

    6.3 APIOpenFree Free tier
  19. 19
    D
    dbplyrdbplyr.tidyverse.org

    An R backend that sends dplyr work to remote database tables as SQL queries.

    6.2 APIOpenFree Free tier
  20. 20
    M
    Millermiller.readthedocs.io

    A command-line tool for querying, reshaping, and converting named-field data files in several formats.

    6.2 APIOpenFree Free tier
  21. 21
    T
    Tableautableau.com
    6.1 APIOpenFree Free tier · from $15/mo
  22. 22
    MT
    Matillion Transformmatillion.com

    A visual, low-code tool for building data transformation pipelines for AI and analytics.

    6.0 APIOpenFree Free tier
  23. 23
    P
    Prophecyprophecy.ai

    AI-assisted visual workflows prepare data for Databricks, Snowflake, and BigQuery.

    6.0 APIOpenFree Free tier · from $150/mo
  24. 24
    L
    LANSAlansa.com

    Low-code tools build web, mobile, and desktop apps while modernizing IBM i systems.

    6.0 APIOpenFree Free tier
  25. 25
    D
    Daftdaft.ai

    A Python data engine for multimodal AI workloads that runs locally or across machines.

    5.9 APIOpenFree Free tier

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