Open and Analyze Excel (.xlsx) Files Locally in Your Browser

When standard spreadsheets hit a wall on analysis

Finance leads, operations managers, and founders receive .xlsx exports from accounting software, ERP systems, and CRM reports every day. When you want to explore that spreadsheet without buying desktop Microsoft Excel or setting up a Windows BI environment, standard options force compromises:

• Google Sheets: Requires uploading the .xlsx file to Google Drive first and enforces a limit of 20 million cells or 100 MB for spreadsheets created in or converted to Google Sheets (as of October 2026).
• Power BI Desktop: Free to download, but only runs on Windows (Windows 10 or Windows Server 2016 or later). Mac and Linux users cannot install it natively without a virtual machine.
• Manual cell formulas: Writing fragile VLOOKUP, INDEX/MATCH, or nested SUMIFS across 200,000 rows locks up your spreadsheet window whenever a filter changes.

Analyzing spreadsheet data in your browser with Tableau's visual grammar

Instead of relying on fragile cell coordinates ($C$2:$C$95000), xmetric uses named dimensions, measures, and Level of Detail calculations:

1. Import your .xlsx file in the xmetric app. (To chart a CSV export right here, drop it into the box above.)
2. xmetric reads the rows locally in your browser without uploading the file.
3. Drag dimensions (such as Department, Account, Month) and measures (Actual Spend, Budget) onto Rows, Columns, and Color.
4. Add Level of Detail (FIXED, INCLUDE, EXCLUDE) expressions and table calculations that keep working when new rows are added. Test a single formula in the formula playground.

Example: replacing nested SUMIFS with a FIXED LOD expression

In Excel, computing each transaction's share of its department's annual spend requires dividing a cell by a SUMIFS($D:$D, $A:$A, A2, $B:$B, B2) range formula copied down 100,000 rows. With Tableau's formula syntax in xmetric, you write one expression once:

// Tableau Calculated Field: Share of Department Annual Spend
SUM([Actual Spend]) / SUM({ FIXED [Department], YEAR([Transaction Date]) : SUM([Actual Spend]) })

Equivalent SQL query:

SELECT
  department,
  EXTRACT(YEAR FROM transaction_date) AS fiscal_year,
  SUM(actual_spend)
    / SUM(SUM(actual_spend)) OVER (
        PARTITION BY department, EXTRACT(YEAR FROM transaction_date)
      ) AS share_of_dept_annual_spend
FROM ledger_sheet
GROUP BY department, EXTRACT(YEAR FROM transaction_date), account_category;

Comparing ways to analyze an .xlsx file in 2026

Where Microsoft Excel or Power BI is the better choice today

• Cell-by-cell financial models. Choose desktop Microsoft Excel if your .xlsx file is full of cell-by-cell assumptions, VBA macros, or custom print formatting that must be edited and emailed back as an .xlsx workbook.
• Governed Windows BI. Choose Power BI if your team runs on Windows and publishes governed .pbix or .pbip models to the Power BI service (Pro is $14.00 user/month, paid yearly and Premium Per User is $24.00 user/month, paid yearly).

Where xmetric fits

• Spreadsheets you can't upload. Excel, CSV and Parquet files are read in your browser; nothing leaves it unless you save a workbook online.
• Pivots without cell ranges. Drag fields onto shelves and write LOD expressions in the xmetric app, free on any operating system.
• BI files too. Open .twbx and .twb workbooks, and inspect .pbix and .pbip files in the workbook inspector.
• Coming. An MCP server for AI agents, and live Postgres and BigQuery connections.