DuckDB Analytics in a Spreadsheet Grid

DuckDBEvery ATX AnalyticsTable project carries its own DuckDB database: a fast, local, columnar engine that makes a spreadsheet grid behave like a data warehouse. It is where imports land, where pipelines run and where results from remote warehouses are cached.

What you can do

A project database per project — imports, pipelines and cached query results live there
Measured speed: a sum over 100 million rows in 0.35 seconds on a four-thread laptop (see the performance page for every query and size)
Open other .duckdb databases as connections, optionally read-only
Read Parquet, CSV and JSON straight from cloud storage into the project database without passing through the application window
_SQL grid formulas aggregate in DuckDB rather than pulling rows into the sheet

How to connect DuckDB

Every project already has its own DuckDB database — nothing to set up.
To open another .duckdb file, add a DuckDB connection and point it at the file, read-only if it should not change.
Import files and cloud data into the project database, then query, pin and chart them.

Security and governance

Runs entirely on your machine — no data leaves it for analysis
Read-only connections cannot change the database they open

Related guides

Excel alternatives for large data

More integrations

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.