🚀 XLTable News

Technical updates on XLTable — an OLAP server that connects Excel PivotTables to ClickHouse, BigQuery, and Snowflake via XMLA.

Here we’ll share:
• Release notes and architecture changes
• Performance benchmarks
• Integration tips
• New connectors and data engine improvements

Learn more: https://xltable.com

Support: https://t.me/XLTable

🚀 XLTable now supports multiple high-performance databases

One of our core principles at XLTable is flexibility.
That’s why the OLAP engine works seamlessly with several modern analytical databases — giving you full freedom to choose the best backend for your workloads.

🔌 Supported databases

• ClickHouse — ultra-fast columnar engine for real-time analytics
• Google BigQuery — fully managed serverless data warehouse with massive scalability
• Snowflake — cloud data platform with elastic compute and secure data sharing
• Trino — distributed SQL query engine for federated analytics

You can plug any of them into XLTable and explore your data directly from Excel using pivot tables — with no additional configuration complexity.

More backends are coming soon.

🚀 XLTable Blog is live!

We’ve launched an official XLTable blog 🎉
Now we’ll regularly share practical content about:

- OLAP & analytics architecture
- Connecting Big Data platforms to Excel
- ClickHouse, BigQuery, Snowflake & BI tooling
- Real-world use cases, performance tips, and integrations

📍 Where to read:
Blog on our website — in-depth articles and product updates
dev.to — technical posts for developers
Medium — broader analytics & data engineering topics

If you work with Excel, OLAP, or Big Data, this blog is for you.
Follow, read, and stay tuned — more technical deep dives are coming soon.

🚀 New Article in the XLTable Blog

We’ve just published a new article explaining the idea and philosophy behind XLTable.

👉 How we combine Excel + OLAP approach + modern data warehouses
👉 Why classic OLAP was right — and why it needs a modern reboot
👉 How business users can work with Big Data without SQL or Python

If you work with Excel, analytics, or cloud data warehouses — this is for you.

📖 Read the article: https://xltable.com/blog/xltable-olap-excel-modern-data-warehouses

🚀 XLTable Documentation Update

We have completely redesigned the structure and content of the documentation.

What’s new:

— OLAP cube architecture and design
— SQL tags reference
— Jinja context and SQL generation logic
— full cube definition examples
— best practices for cube design
— settings.json schema and configuration

The documentation now covers the full workflow — from installation to production deployment — and is much clearer for developers and integrators.

Explore the updated docs here:
https://xltable-olap.readthedocs.io/en/latest/index.html

🚀 XLTable now supports StarRocks

We’ve added a new connector for StarRocks — a high-performance MPP database designed for real-time analytics on large-scale data.

With this integration you can:
• connect StarRocks directly to Excel Pivot Tables
• use the XLTable OLAP semantic layer
• build reports without CSV exports or BI tools
• analyze big data in the familiar Excel interface

Perfect for teams already running modern columnar analytics stacks who need fast, self-service analytics for business users.

Want to try the connector or run a pilot? Message us directly.

🎥 XLTable Webinar Recording Is Now Available on YouTube!

🔗 Watch here:
https://youtu.be/gVvIf2ycxgM

In this session we cover:
🔹 How XLTable connects Excel to modern data warehouses
🔹 Architecture overview (Excel → XLTable → Database)
🔹 Working with Snowflake / BigQuery / ClickHouse
🔹 OLAP semantic layer concepts
🔹 Live demo with Excel Pivot Tables
🔹 Q&A and practical use cases

If you’re building analytics infrastructure and want to keep Excel as a front-end while using Big Data storage — this recording is for you.
As always, XLTable helps you keep what users love (Excel) and connect it to what IT loves (scalable cloud databases).

🚀 XLTable 2.0.10 — Released (March 19, 2026)

We’ve shipped a new version of XLTable with major improvements across connectivity, configuration, and developer experience.

📦 What’s new:

— StarRocks Connector
Added support for StarRocks as a data source

— Admin Panel
New web-based interface for managing server configuration

— Part-source parameter
New part-source attribute for defining tag relationships in cube configuration

— Jinja context variables
Cube definitions now support Jinja templating with dynamic context variables

— Improved logging
Enhanced diagnostics across all connectors for easier troubleshooting

👉 Full changelog:
https://xltable-olap.readthedocs.io/en/latest/changelog.html

💡 XLTable lets you connect Excel Pivot Tables directly to modern data warehouses (ClickHouse, BigQuery, Snowflake, StarRocks) via XMLA — no BI tools required.

🔥 Upgrade now or try XLTable if you haven’t yet

#XLTable #Release #OLAP #Excel #BigData #StarRocks

🚀 XLTable for Local Windows Is Now Available

We’re excited to announce that an XLTable distribution for running on a local Windows machine is now available.

✅ Fast evaluation
✅ Local use
✅ Quick setup without deploying to a separate server

This is a simple way to explore XLTable in your own environment and see how Excel PivotTables can work with large-scale data through a familiar interface.

📊 Enterprise-grade analytical access to Excel
🖥 Now available for local Windows deployment

🌐 To request the distribution, please leave a request on our website.

#XLTable #Excel #OLAP #Windows #DataAnalytics #BusinessIntelligence

🚀 XLTable now supports Databricks

We’re excited to announce that Databricks is now supported as a data source in XLTable.

You can now connect Excel PivotTables directly to data in Databricks and keep working in the interface your business users already know.

No CSV exports. No extra BI layer for everyday analysis. Just Excel + big data.

With XLTable, teams can use Excel as a familiar analytics front end while data remains in a modern cloud platform.

Databricks is now part of the XLTable connector ecosystem, helping enterprises bring large-scale analytics into Excel faster and more easily.

Request a trial or contact us via xltable.com

#XLTable #Databricks

🚀 XLTable + Snowflake: From Zero to Pivot Table in 15 Minutes

We just published a step-by-step quickstart guide — connect Excel directly to Snowflake via XLTable and get a live Pivot Table with no CSV exports, no BI tools, no plugins.
What's inside:
— A ready-to-run SQL script that creates a realistic data model (sales, inventory, regions, managers)
— XLTable setup in minutes — the OLAP cube is defined straight in the database, no YAML or GUI
— Native Excel connection via Analysis Services
— Year-over-year comparisons and inventory turnover work out of the box
Everything runs on a free Snowflake trial account. No custom data required.

👉 Read the guide
👉 Start your 30-day XLTable trial
#XLTable #Snowflake

🚀 One of our clients has shared a public review about XLTable on LinkedIn.

It is always especially valuable to see feedback from real users who apply XLTable in practice to connect Excel with modern data platforms and work with large datasets in a familiar interface.

We truly appreciate this trust and kind words.
Thank you for supporting XLTable and sharing your experience with others. 🙏❤️

Such feedback inspires us to keep improving the product and building new features.

#XLTable #Excel #BigQuery #Snowflake