Open a CSV or Parquet file with tens of millions of rows, then scroll, sort, filter, edit
and add calculated columns in your browser. Next to those big tables, build ordinary sheets
with formatting, charts and Excel formulas such as XLOOKUP and SUMIFS, and point those
formulas straight at the big tables. Everything runs on a DuckDB file on your machine. There
are no seats, tiers or paywalls: export, sign-in, teams and every other feature are free.
npx alephgrid flights.parquet # npm: opens http://127.0.0.1:7878 with the file loaded
uvx alephgrid --demo-rows 10000000 # PyPI: or try it on 10M generated rows
docker run -p 7878:7878 -v alephgrid-data:/data ghcr.io/alephgrid/alephgrid:0.1.0
| |
|---|
| |
| Sheets with Excel formulas that read whole tables | Pivots and charts from the Analyze pane, no SQL |
| |
| SQL when you want it, docked under the grid (dark theme) | Imports reviewed column by column before they commit |
| |
| Your own functions in a side panel: code, tests, docs and versions | The hub: every workbook, its size and whether its compute is running |
v0.1.0, the first release, is out (9 November 2026): binaries for Linux and macOS, npm
and PyPI packages, and a Docker image. See the release
and what is shipped and what is not.
Why Alephgrid
- Big tables stay fast. Opening a workbook reads nothing into memory. The grid asks only
for the rows on screen, so scrolling to row 900,000,000 is a range read. Sorts build a
permutation, not a copy; calculated columns are computed only for the rows you look at.
- A real spreadsheet next to them. Sheets use Excel syntax and an Excel-compatible engine
(IronCalc), with formatting, merged cells, frozen
panes, charts, colour rules, comments and XLSX import and export.
- Spreadsheet formulas over big tables.
=XLOOKUP(A2, customers[id], customers[region])
and =SUMIFS(orders[amount], orders[region], A2) in a sheet cell run as one query over the
whole table, not one lookup per row. See table formulas.
- No SQL required, SQL available. Filters, pivots, joins and charts work without writing
SQL; the SQL workspace stays closed until you open it, and a server can turn it off.
- Yours to run. One binary with the UI embedded, data in a plain directory, Apache-2.0.
Teams get spaces, roles, single sign-on, audit, quotas and backups in the same binary.
- Agents through MCP. Give an AI agent read access to a workbook's tables, sheets and saved
queries over the Model Context Protocol, with a receipt for every result.
以上为 README 的开头部分。其余内容请阅读原文。 查看完整 README ↗
