10 Data Transformation Tools in 2026
These ten tools reshape data. Some refresh steps inside Excel. Others model tables in a warehouse, or load data there first. Elyx belongs on this list only when the job stays in the workbook.
The 10 best AI tools for Excel in 2026. Start the 7-day free trial, no credit card. Plus is €12/month and Pro is €29/month.
Elyx, an AI agent inside Excel.
Spending too much time on Excel?
Elyx AI generates your formulas and automates your tasks in seconds.
Sign up →Summary
| Tool | Where it runs | Price |
|---|---|---|
| Power Query | Inside Excel | Included with Excel. |
| dbt | In the warehouse | Free to run locally. The hosted product is paid. |
| Alteryx Designer | A workflow outside Excel | Paid plans. |
| Fivetran | A pipeline into a warehouse | Paid plans. |
| Airbyte | A pipeline into a destination | Free offer and paid plans. |
| Elyx | Inside Excel | 7-day trial, no card. Then Plus at €12/month or Pro at €29/month. |
| Azure Data Factory | A pipeline in Azure | Paid Azure service. You pay for what the pipeline runs. |
| AWS Glue | A job in AWS | Paid AWS service. You pay for what the job uses. |
| Talend by Qlik | A data-integration product | Free offer and paid plans. |
| Informatica | Enterprise data software | Paid plans. |
1. Power Query
- Get Data saves the steps: split, filter, change types, merge, and append.
- Refresh runs those steps again when the source file changes.
- The query stays in the workbook. It is not a warehouse job.
2. dbt
- dbt builds SQL models on data that is already in a warehouse, then you rerun them.
- You can run it on your own machine. dbt Labs also sells a hosted product.
- It does not open inside Excel. A sheet is an export, not where dbt runs.
3. Alteryx Designer
- Designer is a visual workflow. It reads and writes .xlsx with its own Excel driver.
- You rerun the workflow when the file changes, outside the Excel window.
- The published price is on Alteryx's site.
4. Fivetran
- Fivetran copies data from source applications into a warehouse.
- The reshape usually happens after that load, often in a tool such as dbt.
- Check the current offer on Fivetran's site before you buy.
5. Airbyte
- Airbyte copies data from sources into a destination you choose.
- It publishes a self-hosted edition and a cloud offer. Transformation is usually a later step.
- Check the license and the current price on Airbyte's site. This page does not state them.
6. Elyx
- You describe the change. Elyx applies it in the open workbook: formulas, cleanup, or a new layout.
- It fits a file you already have. It does not load a database and it does not schedule a pipeline.
- There is no permanent free plan. When the 7 days end, Elyx is blocked until you subscribe.
7. Azure Data Factory
- Azure Data Factory builds cloud pipelines that copy data and can transform it between sources.
- You build the pipeline in Azure, not in the Excel ribbon.
- The price depends on the activities you run. Check Azure for the current rates.
8. AWS Glue
- AWS Glue is Amazon's serverless ETL service. A job reads a source, transforms it, and writes a destination.
- You run it in AWS, not inside Excel.
- Check AWS for the current price. This page does not state a rate.
9. Talend by Qlik
- Talend, now part of Qlik, publishes products that move and transform data between systems.
- Excel can be a file you read or write. The product does not run in the Excel window.
- Check the current offer on Qlik's site. This page does not state a price.
10. Informatica
- Informatica sells enterprise software that integrates and transforms data between systems.
- It is aimed at a central data team, not at a button in Excel.
- Check Informatica's site for the current offer.
Questions
What is a data transformation tool?
Software that reshapes data: split columns, change types, join sources, or rebuild tables in a warehouse. The result is data you can analyze.
Is Elyx a data transformation platform?
No. Elyx is an AI agent inside Excel. It can reshape a range in the open workbook. It does not run a warehouse pipeline.
Where do you check a price this page does not state?
On the vendor page. When the current amount is not certain, the table says "Free offer and paid plans" and does not invent a figure.
Start the 7-day free trial. Plus is €12/month and Pro is €29/month.
Reading Excel tutorials to save time?
What if an AI did the work for you?
Describe what you need, Elyx executes it in Excel.
Sign up