ElyxAI

10 Data Transformation Tools in 2026

ThomasCoget
27 min
Non classé
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

ToolWhere it runsPrice
Power QueryInside ExcelIncluded with Excel.
dbtIn the warehouseFree to run locally. The hosted product is paid.
Alteryx DesignerA workflow outside ExcelPaid plans.
FivetranA pipeline into a warehousePaid plans.
AirbyteA pipeline into a destinationFree offer and paid plans.
ElyxInside Excel7-day trial, no card. Then Plus at €12/month or Pro at €29/month.
Azure Data FactoryA pipeline in AzurePaid Azure service. You pay for what the pipeline runs.
AWS GlueA job in AWSPaid AWS service. You pay for what the job uses.
Talend by QlikA data-integration productFree offer and paid plans.
InformaticaEnterprise data softwarePaid 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