OLAP for Modern Data
Big Data meets Excel. Reinvented with XLTable.
Connect Excel to ClickHouse, BigQuery, Snowflake, Trino, StarRocks, and Databricks through an XMLA-compatible OLAP server. Power PivotTables with large datasets — without SQL and without rewriting reports.
Architecture
Excel
PivotTables powered by MDX/XMLA.
XLTable OLAP Server
- • Semantic layer: metrics & dimensions
- • Translates MDX into SQL
- • Provides XMLA endpoint
- • Aggregates big datasets
Model once in XLTable. Explore everywhere in Excel.
What is XLTable?
XLTable is an OLAP server built for modern data warehouses — a drop-in replacement for Microsoft Analysis Services. It exposes your data through the XMLA protocol, so Excel sees it as a familiar OLAP cube: MDX queries, PivotTables, named sets — everything works as expected. Define your metrics and dimensions once as a semantic layer, and analysts explore them freely without SQL or data duplication. Backends include ClickHouse, BigQuery, Snowflake, Trino, StarRocks, and Databricks.
How XLTable works
XLTable sits between Excel and your analytical databases, translating MDX into SQL and returning aggregated results directly to PivotTables.
- 1. Define data sources. Connect ClickHouse, BigQuery, Snowflake, StarRocks, Databricks or other SQL engines.
- 2. Model measures & dimensions. Use SQL to define cubes.
- 3. Connect Excel via XMLA. No plugins, no extensions — Excel connects natively.
- 4. Explore data in PivotTables. Users drag-and-drop; XLTable handles SQL.
Data Flow
Excel
XLTable
Snowflake
Features & benefits
Excel-native analytics
Users stay in Excel. No retraining.
Big Data backends
ClickHouse, BigQuery, Snowflake, StarRocks, Databricks and others.
No SQL for end-users
Model once; explore everywhere.
XMLA compatible
Works like Microsoft Analysis Services.
Flexible cube modeling
Define measures, hierarchies, and attributes.
Secure by design
Keep data inside your infrastructure.
Multiple measure groups, hierarchies, and dimensions
Combine multiple fact and reference tables into a unified analytical model.
LDAP / Active Directory integration
Manage authorization through enterprise AD groups with seamless role mapping.
Fine-grained access control
Restrict user access to specific measures, dimensions, or individual members.
Supported databases
Any SQL backend that supports aggregation can be used as a data source.
ClickHouse
BigQuery
Snowflake
Trino
StarRocks
Databricks
Pricing
Annual subscription. Includes updates and support for the duration of the license.
Trial
30 days to evaluate in your own environment.
- 1 data source
- Up to 3 users
- 1 environment
- No support
- No SLA
Pilot
Team validation before production rollout.
- 2 data sources
- Up to 10 users
- 1 environment
- Email support
- No SLA
Business
Production-grade deployment for a department.
- Up to 5 data sources
- Up to 50 users
- Dev + prod environments
- Priority support
- SLA + LDAP / AD
Enterprise
Large deployments, multiple environments, dedicated support.
- Unlimited data sources
- Unlimited users
- Multiple environments
- Dedicated support + SLA
- On-prem / air-gap option
What our customers say
"Before XLTable, our users hit serious limits working with large datasets in Excel. XLTable let us connect Excel directly to ClickHouse — no data duplication, no change to the familiar Pivot Table experience. We cut total cost of ownership by eliminating extra servers and simplifying development for analysts. Deployment took one working day with no lengthy training. The ClickHouse integration removes the need for additional BI servers, and the vendor support has been responsive and practical — exactly what you want when rolling out new tooling."
Stanislav Vilkov
Head of Analytics Tools · Lenta
Documentation
Full documentation is available on Read the Docs, including installation, configuration, cube modeling, and Excel integration.
- • Installation & deployment
- • Data source configuration
- • Cube modeling (measures & dimensions)
- • Jinja templates
- • Security & permissions
Blog
Latest articles
XLTable + Snowflake: From Zero to Pivot Table in 15 Minutes
A step-by-step guide to connecting Excel to Snowflake with XLTable using ready-made sample data — no custom setup required.
Snowflake to Excel: Pivot Tables Without BI Tools
Learn how to connect Snowflake to Excel Pivot Tables without CSV exports or BI tools using an OLAP semantic layer.
Ready to bring Big Data into Excel?
Contact us for a demo, integration guidance, or support.