Query
FreeMaintainedSheetXL - Workbook read surface and renderers (grep, reports) — capabilities declared once, adapted by any host surface
About
SheetXL - Workbook read surface and renderers (grep, reports) — capabilities declared once, adapted by any host surface
README
The full stack spreadsheet — for developers
SheetXL is the open spreadsheet ecosystem — modular, embeddable, and fully scriptable.
Excel-compatible. API-first. Built for speed.
If you like SheetXL give us a star ⭐ and help others find us!
Whether you're building a custom UI, adding live scripting, or integrating spreadsheet logic into your app, SheetXL gives you full control with zero platform lock-in.
Headless API. Live Scripting. CLI Tools. Built for developers.
Try it now — Complete Excel-compatible App
🚀 Getting Started
Get started in minutes with our production ready application.
1. Installation
# Using npm
npm install @sheetxl/sdk @sheetxl/studio-mui @mui/material @emotion/react @emotion/styled
# Using yarn
yarn add @sheetxl/sdk @sheetxl/studio-mui @mui/material @emotion/react @emotion/styled
2. Basic Usage
import React from 'react';
import { Studio } from '@sheetxl/studio-mui';
function App() {
// Studio will fill it's parent container.
return (
<div style={{ height: '600px', width: '100%' }}>
<Studio />
</div>
);
}
For more advanced setup options, check out our full Getting Started Guides.
📚 Ecosystem Overview
The SheetXL ecosystem is modular by design. You can use only what you need — or compose it all together.
SDK
At the core of the ecosystem is a headless, high-performance SDK @sheetxl/sdk, built to power everything from lightweight grid widgets to massive enterprise-scale calculation engines
Key features:
- Blazing Speed: Executes 10M+ operations per second and handles spreadsheets with 17B+ cells.
- Powerful API: A modern, vectorized, range-based API for precise, scriptable control over data — independent of any UI.
Applications and UI Toolkits
Build UIs your way — from plug-and-play dashboards to fully custom design systems.
- Rapid Deployment @sheetxl/studio-mui: A complete, open-source spreadsheet UI with Excel-grade features. Ready to ship.
- Custom Interface @sheetxl/react: A flexible component and hook library for deep customization.
I/O Connectors
Easily load and save workbooks in popular formats:
xlsx(Excel)csvparquet(in progress)json(native format)
Click to see the a detailed overview of all modules...

Items marked with 💎 are part of the premium licensing.
| Category | Module | Description | License |
|---|---|---|---|
| Core | @sheetxl/sdk 💎 | Headless spreadsheet API | Commercial |
| @sheetxl/formulas | Collection of 400+ formulas | MIT | |
| @sheetxl/primitives | Low level types (Scalar, IRange) | MIT | |
| @sheetxl/scripting 💎 | Scripting engine and compiler | Commercial | |
| IO | @sheetxl/io | Import/export (xlsx, csv, json) | MIT |
| Applications | @sheetxl/studio-vanilla | Framework-agnostic spreadsheet app | MIT |
| @sheetxl/studio-mui | Spreadsheet app powered by React/MUI | MIT | |
| UI Toolkits | @sheetxl/react 💎 | Spreadsheet React UI components and hooks | Commercial |
| @sheetxl/grid-react 💎 | Lightweight, standalone React data grid | Commercial | |
| Utils | @sheetxl/utils | Headless utilities (math, ranges, etc) | MIT |
| @sheetxl/utils-react | React UI helpers | MIT | |
| @sheetxl/utils-mui | MUI UI helpers (color picker, dialogs, etc) | MIT |
Key Features
SheetXL is built on four core pillars: extreme performance, deep Excel compatibility, unparalleled developer power, and a modern, extensible architecture.
Performance & Scale
Process 10M+ ops/second and manage massive 17B+ cell workbooks, all in-browser.
True Excel Fidelity
Go beyond basic formulas. Get the Excel-grade features your users demand, from tables and charts to cross-sheet copy/paste.
Unmatched Developer Power
With a headless core, a powerful vectorized API, and a built-in scripting engine, you have the ultimate control to build any experience.
Modern, Open Architecture
Built with TypeScript and a flexible plugin model, including a fully open-sourced MIT-licensed MUI design system.
🔥 Power Features
Live Scripting Engine
Write and execute TypeScript/JavaScript directly inside your spreadsheet. Perfect for complex data transformations, custom validation, and real-time calculations.

Command-Line Interface
Automate spreadsheet operations, run batch processes, and integrate SheetXL into your build pipeline with our full-featured CLI.

# Run custom scripts
sheetxl run process-data.ts --workbook sales.xlsx
🏷️ User Features
- 17B+ cells (The same as Excel)
- 400+ Excel-compatible formulas
- Full fidelity Excel import/export
- Scripting Engine
- Fast. Autofill 1,048,576 rows with formulas in 0.7s (10M+ formulas/second)
Click to see the full list of additional User Features...
- Formatted Copy/Paste (Compatible with Microsoft Excel and Google Sheet)
- Hidden Rows/Columns
- Frozen Rows/Columns
- Resizable, Auto-fit Rows/Columns
- Office Theme (Color Picker, Theme Selector)
- Cell Styles (Themes and Formatting)
- Preset Cell Style Selector
- Overflow, Word-wrap
- Borders
- Tables
- Drawings
- Multi-range selection
- Merged Cells
- Autofill
- Keyboard Accessible Support for all Excel shortcut keys
- Undo/Redo
- Find/Replace
- Sort
- Zoom
- Hyperlinks
- Mobile Friendly (Touch / Small screen accommodation)
🛠️ Developer Features
- Typescript
- Easy Integration
Click to see the full list of Developer Features...
- Built in scripting & Formula support.
- Built from the ground up using React and CSS-in-JS components.
- Fully functional MIT Open-sourced Material-UI Application.
- Headless spreadsheet API can be used without UI and on server or as library.
- Easily extend functions with simple registration.
Roadmap
- Table Filtering (in progress)
🧭 Click to see the full Roadmap...
2025 Roadmap
- Conditional formatting
- Full Styling in Excel Export
- Full Charting (nearly complete)
- Multi-key shortcuts
- Pivot
- Sparklines
- Slicer/Timeline
- Accessibility https://www.w3.org/TR/WCAG21/
- Printing
2026 Roadmap
- Google Sheets Interop
- Collaboration
🤔 Why SheetXL?
We believe developers have been forced to compromise between powerful but closed spreadsheet apps and flexible but limited data grids for too long. SheetXL was built to end that compromise.
Why not just a spreadsheet app?
Importing and Exporting data from a spreadsheet is a broken part of nearly every business workflow. Instead of importing/exporting data, just import the spreadsheet.
- Reduce errors on data due to import/export copying of data.
- Real time integration/validation of your data.
- Complete control of data as your data never leaves your systems.
- Improved user productivity.
- Combine custom user enhancements with flexible data manipulation.
Why not just a spreadsheet component?
As a Microsoft Excel user and a React developer I have always wanted a solution that combines the flexibility and ease of use of Excel with the control and specific capabilities of my custom application.
I wanted my custom applications to have spreadsheet features!
Several great spreadsheet components exists but none of them have:
- Excel compatibility and features.
- Simple integration.
- Billions of cells.
- Comprehensive support for keyboard shortcuts (e.g. tabbing within multi-selected ranges, arrow-keys within cells).
- Enable advanced copy / paste between Excel/Excel Online/Google Sheets.
- Easily extendable libraries that use open-source and modern design patterns.
- Real-time integration to data providing a single source of truth; no copying data between systems using complex APIs.
The Competitive Landscape
We encourage you to explore the landscape. We're confident you'll see why we built SheetXL.
👐 Open-source Spreadsheets Components...
- https://dream-num.github.io/LuckysheetDemo/ https://github.com/dream-num/Luckysheet (14,500 :star:)
- https://github.com/jspreadsheet/ce https://jspreadsheet.com/v8 (6,400 :star:)
- https://github.com/myliang/x-spreadsheet https://myliang.github.io/x-spreadsheet (13,500 :star:)
- https://github.com/nadbm/react-datasheet https://nadbm.github.io/react-datasheet (5,300 :star:)
- https://github.com/adazzle/react-data-grid (6,200 :star:)
- https://iddan.github.io/react-spreadsheet (1,000 :star:)
💲 Paid Spreadsheets Components...
- https://demos.devexpress.com/ASPxSpreadSheetDemos/Features/Charts.aspx
- https://www.igniteui.com/spreadsheet/overview https://www.infragistics.com/products/ignite-ui-jquery/grids-and-lists/spreadsheet
- https://ej2.syncfusion.com/react/demos/#/bootstrap5/spreadsheet/default
- https://webix.com/demos/spreadsheet
💲 Paid Data-grids...
A data-grid is a sub-component within a spreadsheet that provides base grid-level rendering but without many of the spreadsheet features (user styling, formulas, Excel compatibility, etc). Features vary by product but generally include sorting, filtering, grouping, and basic cell editing.
- https://handsontable.com/demo (18,100 :star:)
- https://www.ag-grid.com/example (10,500 :star:)
- https://mui.com/x/react-data-grid (6,100 :star:)
- https://www.datagridxl.com/
💲 SAAS Spreadsheets...
SAAS spreadsheets are still closed solutions and lack the full experience of Excel.
🙏 Credits / 🎉 Special Thanks
- Formula.js (For function references)
- Fast Formula Parser (For grammar support)
- SheetJS (For original number format parsing and Excel import/export)
- Papa Parse (For CSV parsing)
🔗 Learn More
Whether you're ready to build, need help, or just want to see more examples, here's where to go next.
- 💬 Join our Discord Community - Get help and connect with the
- ⭐ Star us on GitHub - If you like SheetXL give us a star ⭐ and help others find us!
- 📘 Developer Docs - Guides and tutorials.
- 🔌 API Reference - Detailed documentation for all packages.
- 👀 Live Demo Gallery - A showcase of interactive examples.
- 🖼️ Storybook - Explore and test individual UI components. team.
- 🌐 Website - Our Website.
Install Query in Claude Desktop, Claude Code & Cursor
unyly install queryInstalls into Claude Desktop, Claude Code, Cursor & VS Code — handles npx, uvx and build-from-source repos for you.
First time? Get the CLI: curl -fsSL https://unyly.org/install | sh
Or configure manually
Run in your terminal:
claude mcp add query -- npx -y @sheetxl/queryStep-by-step: how to install Query
FAQ
Is Query MCP free?
Yes, Query MCP is free — one-click install via Unyly at no cost.
Does Query need an API key?
No, Query runs without API keys or environment variables.
Is Query hosted or self-hosted?
Self-hosted: the server runs locally on your machine via the install command above.
How do I install Query in Claude Desktop, Claude Code or Cursor?
Open Query on unyly.org, pick your client tab (Claude Desktop, Claude Code, Cursor) and press Install — the config is generated automatically, no JSON editing.
Related MCPs
Fetch
Web content fetching and conversion for efficient LLM usage.
Roblox Studio
Enables AI coding tools to control Roblox Studio for workspace exploration, instance manipulation, and script management. It provides tools for playtesting, sce
by paralovAWS KB Retrieval
Retrieval from AWS Knowledge Base using Bedrock Agent Runtime.
by modelcontextprotocolSpring AI MCP Server
Provides auto-configuration for setting up an MCP server in Spring Boot applications.
llm-analysis-assistant
A very streamlined mcp client that supports calling and monitoring stdio/sse/streamableHttp, and can also view request responses through the /logs page. It also
by xuzexin-hzMCP-Agent
A simple, composable framework to build agents using Model Context Protocol by [LastMile AI](https://www.lastmileai.dev)
by lastmile-aiSpring AI MCP Client
Provides auto-configuration for MCP client functionality in Spring Boot applications.
mcp.natoma.ai
A Hosted MCP Platform to discover, install, manage and deploy MCP servers by [Natoma Labs](https://www.natoma.ai)
MCPHub
Website to list high quality MCP servers and reviews by real users. Also provide online chatbot for popular LLM models with MCP server support.
MCP Servers Rating and User Reviews
Website to rate MCP servers, write authentic user reviews, and [search engine for agent & mcp](http://www.deepnlp.org/search/agent)
Compare Query with
Not sure what to pick?
Find your stack in 60 seconds
Author?
Embed badge for your README
Browse similar
All ai MCPs
