Best Data Transformation Tools in 2026
Updated
In short: jq is ranked #1 of 36 as of 4 October 2026, ahead of Apache Beam and Bruin for Customer Success. The best-ranked option with a free plan is Apache Beam. The lowest first paid tier on this page is AWS Glue DataBrew at $0.48/mo.
Data transformation tools help prepare data by reshaping it for use in later steps of a workflow. Compare supported data formats and transformation interface with the data you work with, and consider data quality checks and version control for how you manage changes. Workflow orchestration and deployment model can help you judge how an option fits into a broader process. Free plan availability and paid-from pricing add cost context. KNIME Analytics Platform, Apache Beam, and Dataform lead the ranked entries, with Prophecy and Polars also among the first shown. Weigh the listed capabilities against how you need to build, check, and run transformations.
36 data transformation tools ranked on what their makers publish — plans and prices, free tiers, platforms and the facts on their own pages.
#1 jq Top pick · 7.2 Free plan · Free
#2 Apache Beam Runner-up · 7.0 Free plan · Free
#3 Bruin for Customer Success Also great · 7.0 Free plan · Free
- Free plan LinuxmacOSself-hostedWebWindows
- Free plan
- Yes
RecognisedDocumentedFree planPlatformsFree About jqVisit site - Free plan apiLinuxmacOSself-hostedWebWindowsRecognisedDocumentedFree planPlatforms
- Free plan apiLinuxmacOSself-hostedWebWindows
- Free plan
- Yes
RecognisedDocumentedFree planPlatforms - Free plan LinuxmacOSWindows
- Free plan
- Yes
- Deployment model
- self_hosted
- Transformation interface
- code
- Supported data formats
- CSV, DBF, fixed-width, GeoJSON, JSON, NDJSON, XLS, XLSX; gzip, bz2 and xz-compressed CSV input
RecognisedDocumentedFree planPlatforms - Free planFree trial LinuxmacOSWindows
- Free plan
- Yes
RecognisedDocumentedFree planPlatforms - Free plan LinuxmacOSself-hostedWebWindows
- Free plan
- Yes
RecognisedDocumentedFree planPlatforms - Free plan LinuxmacOSself-hostedWindows
- Free plan
- Yes
RecognisedDocumentedFree planPlatforms - Free plan apiLinuxself-hostedWeb
- Free plan
- Yes
- Paid from
- 40 /mo
- Deployment model
- hybrid
RecognisedDocumentedFree planPlatforms$40/mofirst paid tier About CubeVisit site - Free plan apiWeb
- Free plan
- Yes
- Deployment model
- cloud
- Transformation interface
- visual
- Supported data formats
- CSV, TSV, JSON, text, XLSX, XLS, XML, fixed-width, Parquet
- Version control
- Yes
RecognisedDocumentedFree planPlatforms$150/mofirst paid tier About ProphecyVisit site - Free planFree trial apiWeb
- Free plan
- Yes
RecognisedDocumentedFree planPlatforms$150/mofirst paid tier About Coalesce CatalogVisit site - Free planFree trial apiWeb
- Free plan
- Yes
- Deployment model
- cloud
RecognisedDocumentedFree planPlatforms$100/mofirst paid tier About dbt Semantic LayerVisit site - Free planFree trial self-hostedWeb
- Deployment model
- hybrid
- Transformation interface
- visual
- Supported data formats
- JSON, AVRO
- Version control
- Yes
RecognisedDocumentedFree planPlatforms - Free plan apiWeb
- Free plan
- Yes
- Deployment model
- cloud
- Transformation interface
- sql
- Supported data formats
- SQLX, JavaScript, JSON
- Version control
- Yes
RecognisedDocumentedFree planPlatforms - Free plan Linuxself-hosted
- Free plan
- Yes
- Deployment model
- self_hosted
- Transformation interface
- code
- Supported data formats
- CSV, Excel, Parquet, Feather, HDF5, JSON, SQL tables, SQL queries, Spark DataFrames, XML, Delta tables, Pickle
- Version control
- Yes
RecognisedDocumentedFree planPlatforms - Free plan Web
- Free plan
- Yes
- Deployment model
- cloud
- Transformation interface
- visual
- Version control
- Yes
RecognisedDocumentedFree planPlatforms$29/mofirst paid tier About VisitranVisit site - Free trial apiLinuxmacOSself-hostedWindows
- Free plan
- No
- Deployment model
- hybrid
- Transformation interface
- code
- Supported data formats
- Delimited, fixed, line sequential, record sequential, variable sequential, blocked, CSV, JSON, LDIF, XML, COBOL, ODBC tables, Excel, Kafka, MQTT, S3, Azure Blob, GCP storage, HDFS
- Version control
- Yes
RecognisedDocumentedFree planPlatforms - self-hosted
- Free plan
- Yes
RecognisedDocumentedFree planPlatforms$15/mofirst paid tier About TableauVisit site - Free trial apimacOSself-hostedWebWindows
- Free plan
- No
- Deployment model
- hybrid
- Transformation interface
- visual
- Supported data formats
- CSV, Excel, fixed-length text, XML, JSON, COBOL, SQL, PDF, database tables
- Version control
- Yes
RecognisedDocumentedFree planPlatforms - LinuxmacOSWebWindows
- Free plan
- No
- Deployment model
- hybrid
- Transformation interface
- visual
- Supported data formats
- Flat files, relational databases, Hadoop, NoSQL, cloud storage, JSON, XML, Parquet
- Version control
- Yes
RecognisedDocumentedFree planPlatforms - LinuxmacOSWindows
- Free plan
- Yes
- Deployment model
- self_hosted
- Transformation interface
- sql
- Supported data formats
- SQL; TOML; warehouse tables including Delta and Iceberg (adapter support varies)
- Version control
- Yes
RecognisedDocumentedFree planPlatforms - LinuxmacOSWindows
- Free plan
- Yes
- Deployment model
- self_hosted
- Transformation interface
- code
- Supported data formats
- DataFrame-based inputs; Parquet files are shown in examples
RecognisedDocumentedFree planPlatforms - WindowsmacOSLinux
- Deployment model
- self_hosted
- Transformation interface
- code
- Supported data formats
- CSV, delimited text, fixed-width text, clipboard, Excel, OpenDocument, JSON, HTML, XML, LaTeX, HDF5, Feather, Parquet, Apache Iceberg, ORC, SQL, Google BigQuery, Stata, SAS, SPSS, Python Pickle
RecognisedDocumentedFree planPlatforms - Free trial apiWeb
- Free plan
- No
RecognisedDocumentedFree planPlatforms$0.48/mofirst paid tier About AWS Glue DataBrewVisit site - Free trial apiWeb
- Free plan
- No
RecognisedDocumentedFree planPlatforms - WindowsmacOSLinux
- Free plan
- Yes
- Deployment model
- self_hosted
- Transformation interface
- code
- Supported data formats
- data frames, tibbles
RecognisedDocumentedFree planPlatforms
Is your app 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 Everything Xiaomi?
jq is ranked #1 of 36 with a score of 7.2. Apache Beam is second and Bruin for Customer Success 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: documentation depth, a free tier and the platforms it runs on. Paid placements never change a rank.