Excel to DAX Converter

About the Excel to DAX Converter

This tool converts Excel tables into DAX DATATABLE expressions that you can paste into Power BI, Analysis Services, or Power Pivot to create static tables directly in your data model.

Key Features

• Excel file support: Works with .xlsx and .xls files.
• Header row handling: Use the first row as column names or auto-generate generic column labels.
• DAX DATATABLE syntax: Generates a valid DATATABLE expression wrapped in EVALUATE for quick testing.
• String-safe encoding: Escapes double quotes in text values to keep DAX syntax valid.
• One-click copy and download: Copy the generated DAX or download it as a .dax file.
• Local processing: All conversions run in your browser for maximum privacy.

How to Convert Excel to DAX

1. Upload your Excel file: Drop a .xlsx / .xls file into the upload area or click to browse.
2. Confirm header usage: If the first row contains column names, leave "First row is header" enabled so they become DAX column names.
3. Let the tool generate DAX: The converter reads the first worksheet and builds a DATATABLE expression with all rows.
4. Copy the DAX expression: Paste it into Power BI Desktop (Modeling → New table) or into a query window that accepts DAX.

Example: Excel Table to DAX DATATABLE

Sample Excel data:

• Row 1: Country, Sales
• Row 2: USA, 1000
• Row 3: UK, 750

The generated DAX will look similar to:

EVALUATE
DATATABLE(
    "Country", STRING,
    "Sales", STRING,
    {
        { "USA", 1000 },
        { "UK", 750 }
    }
)

You can paste this directly into Power BI to create a calculated table from your Excel data.

When to Use Excel to DAX

• Static lookup tables: Convert small Excel lookups (e.g. statuses, categories, mappings) to DAX tables.
• Demo & training models: Quickly build sample data tables for Power BI demos or tutorials.
• What-if scenarios: Define scenario tables in DAX instead of maintaining external Excel files.
• Migrating from Excel models: Move hard-coded reference data from spreadsheets into the Power BI model layer.

FAQ – Excel to DAX Converter

Which worksheet is used?

The converter uses the first worksheet in your Excel file. If your data is on another sheet, move it to first position before uploading.

Why are all columns typed as STRING?

For safety and simplicity, the tool outputs all columns as STRING. You can manually adjust data types in Power BI (e.g. to Whole Number, Decimal, Date) after creating the table.

Is there a data size limit?

The limiting factor is your browser's memory and performance. The tool is best suited to small to medium-sized lookup tables and reference data, not millions of rows.

Is my Excel file uploaded anywhere?

No. All processing happens client-side in your browser. Your spreadsheets are not sent to a server.