XLTable Documentation¶
Excel meets Big Data.
XLTable is an OLAP server that connects native Excel Pivot Tables directly to modern analytical databases — no CSV exports, no add-ins, no BI tools in between. It acts as a semantic and security layer between Excel and your data platform: IT defines models, access rights and performance centrally, while business users keep working in the tool they know best.
Deploy XLTable, connect a database and open your first Pivot Table — in under an hour.
Architecture, comparison with SSAS, deployment steps and system requirements.
Installation on Linux and Windows, authentication, Active Directory and database connections.
Measures, dimensions, hierarchies, security roles and drillthrough — all defined in plain SQL.
Adapt the generated SQL dynamically: row-level security, relative dates, conditional logic.
Connect Pivot Tables over XMLA, authentication modes, data refresh and drill through.
Supported data sources¶
All heavy computation runs inside your database — XLTable translates Excel requests into optimized SQL. A read-only service account is all it needs.
Database |
Ready-to-run sample |
|---|---|
ClickHouse (22.5+) |
|
BigQuery |
|
Snowflake |
|
Trino |
|
Greenplum |
|
StarRocks |
|
Databricks |
|
DuckDB |
Why XLTable?¶
Native Excel Pivot Tables on big data — the standard SSAS/XMLA workflow
Centralized semantic layer: dimensions, measures, hierarchies, calculated fields
Fine-grained access control, row-level security and Active Directory integration
Query result caching for a fast Excel experience
Self-hosted on Linux or Windows, on-premise or in the cloud
Getting help¶
Product overview, pricing and trial requests.
News, releases and quick answers from the team.
help@xltable.com — support and licensing.
Working with ChatGPT, Claude or another AI assistant? Give it the whole documentation as a single file — see AI assistants.