Query Multiple ClickHouse Tables Into a Single Excel workbook Report

The Scenario

Your analytics engineering team is three weeks into a new reporting cadence. The ask from the VP of Finance: one workbook showing Q1 revenue broken down two ways: by product category in one worksheet, by country in another, with a combined top-10 summary in a third.

The data lives in two separate ClickHouse tables. You know how to query both. What you don't want to do is run two queries, export two CSVs, import them into two worksheets, and then build the summary worksheet by hand — especially since this report will run again at end of Q2.

The bad version:

• Query the orders table for revenue by product_category, export CSV, import to Sheet1.
• Query the same table filtered by country, export a second CSV, import to Sheet2.
• Write the combined top-10 summary in Sheet3 by hand, pulling figures from the other two worksheets with cell references that will break the moment someone renames a column.

That's four separate operations, and none of them talk to each other. The summary worksheet is fragile from the moment you build it.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook structure, connects to ClickHouse, and executes multi-query workflows across multiple worksheets from a single instruction.

Query my ClickHouse 'orders' table for total revenue and order count grouped by product_category for Q1 2025 and write the results into Sheet1 starting at A1 with headers.

Then, for the combined layout:

Query my ClickHouse 'orders' table for revenue by country for Q1 2025 and write into Sheet2, then create a combined summary in Sheet3 showing top-10 categories and top-10 countries side by side.

What You Get

• Sheet1: product_category, total_revenue, order_count — with header row, one row per category.
• Sheet2: country, total_revenue — sorted descending by revenue.
• Sheet3: a side-by-side summary table with the top 10 in each dimension, labeled and ready for presentation.
• No import wizards. No intermediate CSVs. No manually typed formulas in the summary worksheet.

What If the Data Is Not Quite Ready

The 'orders' table has multiple currencies and you need USD only

Query my ClickHouse 'orders' table for total revenue in USD only (where currency = 'USD') grouped by product_category for Q1 2025 and write results into Sheet1 starting at A1 with headers.

One of the country names is stored inconsistently — 'US', 'USA', and 'United States' all appear

Query ClickHouse for revenue by country for Q1 2025. Before writing to Sheet2, normalize 'US' and 'USA' to 'United States' in the country column. Then write the consolidated results with headers.

The product categories have changed since Q4 and you want to compare Q1 2025 to Q1 2024 side by side

Query my ClickHouse 'orders' table for revenue by product_category for Q1 2025 and for Q1 2024. Write Q1 2025 revenue in column B and Q1 2024 revenue in column C, with product_category in column A — match the categories across both periods.

End-to-end: pull, normalize, summarize, and flag any category with less than $1,000 in revenue

Query ClickHouse for Q1 2025 revenue by product_category. Write results to Sheet1. In Sheet3, create a top-10 summary and add a column flagging any category below $1,000 total revenue as 'Low volume' — use 'Active' for everything else.

When the cleanup and the analysis and the summary are all part of one instruction, you skip the three-step process entirely.

Try It

Get the 7-day free trial of SheetXAI and open the Excel workbook where your Q1 reporting lives, then ask it to pull both revenue cuts from ClickHouse and populate the worksheets. See also the parameterized query spoke or the full ClickHouse overview.