XLTable
OLAP server connecting Excel Pivot Tables to modern analytical databases.
Navigation
Documentation
About XLTable
What is XLTable
How it works (Architecture)
Comparison with SSAS
Deployment steps
System requirements
Testing and purchasing
Quickstart
Prerequisites
Step 1: Install XLTable
Step 2: Configure database connection
Step 3: Create a minimal OLAP cube
Step 4: Start the service
Step 5: Connect Excel
Next steps
Installation
Linux
Windows
Authentication
Admin panel
Database connections
OLAP cube definition
Concept
Cube definition storage
Unified example
Cube definition rules
Calculated fields
CTE
User roles
SQL generation logic
Jinja scripts
Best practices for cube design
Connecting Excel
Adding an Analysis Services data source
Authentication modes
Connection string (advanced)
Refreshing data
Troubleshooting connection issues
Reference
SQL tags
Unified example
Jinja context variables
settings.json schema
ClickHouse Sample Data
What the script creates
Data model
Prerequisites
Step 1: Run the SQL script
Step 2: Configure XLTable
Step 3: Restart XLTable
Step 4: Connect Excel
Customising the script
Troubleshooting
Full script
Support
Troubleshooting
Version History
Version 2.0.10 — 2026-03-19
Backlog
Quick search
Index
