Free and open first
Best Data Transformation Tools in 2026
Preparing data for another system or stage of work can involve reshaping, checking, and coordinating transformations. Compare supported data formats and transformation interfaces, then look at data quality checks, version control, and workflow orchestration to see which parts of that work are covered. Deployment model can help you assess fit with your environment; free-plan availability and paid-from pricing add cost context. jq, Apache Beam, and Bruin for Customer Success are among the tools represented. Consider the data you handle and how you need to build and manage its transformation workflow.
- 37 apps
- Research read 23 Sept 2026
- How the order is worked out
- 1
Apache Beam
Free plan Open source APILinuxMac+3Apache Beam provides a common programming model for batch and streaming pipelines across several runners. The model is free, though the chosen runner and infrastructure can carry execution costs.
- 2
Apache Hop
Free plan Open source APILinuxMac+3Apache Hop offers a broad set of pipeline and workflow components with multiple execution options.
- 3
Bruin for Customer Success
Free plan Open source APIExtensionLinux+4Bruin for Customer Success brings multi-source customer analysis and natural-language questions to customer success workflows.
- 4
Cube
Free plan Open source APILinuxSelf-hosted+1Cube centers analytics on a governed semantic model, with options for business intelligence, embedded use, and AI agents.
- 5
Bonobo
Free plan LinuxMacSelf-hosted+1Bonobo offers Python-based pipeline construction with graph execution, built-in format support, and extensions for SQL and Docker.
- 6
Coalesce Catalog
Free plan APIExtensionWebChoose Coalesce Catalog if your team needs discovery, documentation, lineage, and governance across a connected data stack.
- 7
csvkit
Free plan LinuxMacWindowscsvkit offers a broad set of command-line operations for CSV conversion, processing and analysis without a paid tier.
- 8
AWS Glue DataBrew
Free plan APIWebDataBrew brings visual preparation, profiling, lineage, and reusable transformations into a cloud service.
- 9
Ibis
Free plan APILinuxMac+2Ibis offers a portable dataframe interface and a local-to-remote workflow, with backend coverage that varies.
- 10
Daft
Free plan LinuxMacChoose Daft if you need a free, code-driven engine for AI workloads across structured data and media, with local execution and distributed scaling options.
- 11
data.table
Free plan LinuxMacWindowsdata.table combines tabular transformations and delimited-file handling in an R package with memory-conscious column updates.
- 12
dbplyr
Free plan LinuxMacWindowsdbplyr lets users apply dplyr operations to remote database tables while deferring execution to the database.
- 13
dbt Semantic Layer
Free plan APIExtensionWebdbt Semantic Layer gives teams a shared, code-managed way to define and query metrics across supported tools.
- 14
dplyr
Free plan LinuxMacWindowsdplyr provides a focused set of code-based operations for transforming and grouping data, with additional verbs for multiple tables.
- 15
jq
Free plan LinuxMacSelf-hosted+2jq provides a flexible filter model for selecting and transforming JSON, with options for output formatting and large inputs.
- 16
LANSA
Free plan AndroidAPIiPhone+2Choose LANSA if your team needs tools for IBM i modernization, enterprise application development, or business data integration.
- 17
Dataform
Free plan APIWebDataform combines SQL workflow development, versioning, quality checks, and scheduling for BigQuery teams.
- 18
Miller
Free plan LinuxMacSelf-hosted+1Choose Miller if you want a free, open-source command-line tool for querying, reshaping, and converting structured data across many formats.
- 19
OpenRefine
Free plan LinuxMacSelf-hosted+2OpenRefine offers local data cleaning and enrichment with a wide range of import formats and an operation history.
- 20
pandas
Free plan LinuxMacSelf-hosted+1pandas offers a broad set of data manipulation, analysis, and time-series tools as a free Python library. Check its required and optional dependencies for the operations you need.
- 21
KNIME Analytics Platform
by KNIME Analytics PlatformFree plan LinuxMacWindowsKNIME Analytics Platform offers a broad, extensible environment for data workflows without a software charge. Downloading requires an email address and acceptance of terms and the Privacy Policy.
- 22
Polars
Free plan APILinuxMac+3Polars offers a free library for data manipulation, with cloud and on-premises options for broader deployment needs.
- 23
Kedro
Free plan LinuxSelf-hostedKedro offers a structured Python workflow with a broad Data Catalog and pipeline visualization. Teams should be comfortable authoring code and managing deployment in their own environment.
- 24
Malloy
Free plan APIExtensionLinux+4Malloy combines semantic modeling with database-specific SQL generation and several authoring options.
- 25
Matillion Transform
Free plan Self-hostedWebMatillion Transform offers both visual and code-based approaches to data transformation, alongside collaboration and pipeline debugging features.
#1Places #1, #2, #3, #4, #5 on this list can be bought by the makers of the software on it. See the price
More in Developer Tools
- Data Version Control Tools36
- Data Virtualization Software25
- Data Warehouse Software27
- Debuggers27
- Decompiler Software24
- Dependency Management Software27
- Deployment Automation Software34
- Developer Documentation Software27
- Development Environment Management Tools26
- Development Environment Managers50
- Device Farm Software26
- DevOps analytics software48