TreeGrid SpreadSheet

Cell-based AJAX spreadsheet with full Excel compatibility

TreeGrid SpreadSheet is an Excel-compatible, browser-based spreadsheet component built as a TreeGrid extension.
It displays and edits cell-based data with formulas, formatting and fast in-browser processing of XLSX files - all without requiring a server round-trip.

Drop any .xlsx file to the grid to open and edit it here! Or open any .xlsx file from your disk by click to icon on toolbar.
The .xlsx files can be opened, edited and saved (by icon) directly in browser, without any server communication!

Why SpreadSheet

Complex features

TreeGrid SpreadSheet is a feature-rich web spreadsheet component, refined over many years and shaped by real-world enterprise projects and customer feedback.

Excel-like Editing

Excel-style in-cell editing with formulas, validation and formatting. Full copy & paste support, keyboard navigation and range selection for productivity workflows.

Modern Integration

Works seamlessly with React, Vue, Angular, Svelte and Vanilla JavaScript. Includes complete TypeScript definitions for strongly-typed development.

Flexible Data Handling

Load and save XLSX files directly in the browser, without accessing a server. Alternatively, XLSX files can be downloaded from or uploaded to a server. JSON and XML formats are also supported.

Export & Print

Export to HTML, CSV and PDF with custom styling. Print-ready layouts enable splitting and scaling across multiple pages.

Advanced Features

Copy & paste values, styles and formats. Insert and edit images. Full RTL (right-to-left) support for Middle Eastern languages.

Features and Advantages

Comprehensive capabilities for enterprise-level spread sheets

Data Management

Flexible XLSX handling

Full XLSX support - loading, opening and saving XLSX files.
Open, edit and save XLSX directly in the browser.
Optional backend upload and download of the XLSX files.
Spread sheet can be stored in XML or JSON format for lightweight text storage.

Calculations & formulas

Excel-like and JavaScript formulas

Editable formulas starting with = just like in Excel.
230 built-in formula functions compatible with Excel.
Formula source cell selection by mouse during editing, including across sheets.
Formulas with external sheet references.
User defined names for cells and cell ranges to use in formulas.
Custom formulas and expression-based calculations.

Advanced Layout

Special grid and cell structure features

Multiple sheets with add, delete, move, copy, rename.
Interactive toolbar with list of sheets / grids.
Automatic sheet sizing (row and column management).
RTL (right-to-left) display for Middle Eastern languages.
Dynamic cell styling: color, font, alignment, wrapping, rotation.
Dynamic cell borders with different width, style and color.
Dynamic cell spanning (vertical and horizontal).
Automatic cell type detection and formatting
Advanced formatting using format string.

Layout Operations

Rows & columns manipulation

Add, copy and delete rows and columns.
Resize, move and hide rows and columns.
Freeze rows and columns.
Resize sheet sections and grid.
Dynamic spanning for flexible layouts.
Multiple selection modes: row, column, cell and range.
Copy & paste rows, columns and cell ranges.
Full undo & redo support.

Cell Editing

Excel-like editing and navigation

In-cell editing with Excel-like keyboard navigation.
Single-cell or range cursor.
Multi-line editing in textarea.
Rich text editing with full formatting and styling.
Mass operations for ranges: copy, move, fill, clear.
Handles mass updates affecting formulas, values, styles, borders and spans.

Advanced Editing

Extra editing features

Auto-fill and smart fill-down operations.
Copy & paste cells and ranges from and to Excel and other spreadsheets.
Inserting images floating above cells like in Excel.
Manipulating and changing images by mouse dragging.
Fully customizable cell context menu.

Tree & Hierarchical Data

Multi-level structures and pivot tables

Excel outline to arrange rows and columns in tree.
Unlimited tree hierarchy for rows and columns.
Expand & collapse with keyboard shortcuts.

Export

Export capabilities and formats

Export to XLSX, CSV, PDF with customizable styling.
Print-ready layouts with multi-page splitting and scaling.
HTML export with full formatting preservation.
Synchronize changes via AJAX, form submits or custom API.

Integration

Framework support and compatibility

Works with React, Vue, Angular, Svelte and Vanilla JavaScript.
Full TypeScript definitions and IntelliSense support.
Responsive design with mobile and touch support
Comprehensive API and event system.
Can be used without writing custom JavaScript.
Cross-browser compatibility (Chrome, Firefox, Safari, Edge).
Salesforce LWC & CSP compatibility.

Customization & Theming

Flexible styling and customization

Full theming support with JSON customization.
Built-in themes and custom theme creation.
Animated actions in grid
Customizable toolbar and context menu options.
Customizable cell styling and formatting.
Localized to 14 languages, including all texts and date and number formats
Fully customizable key and mouse navigation action schemes

SpreadSheet Advantages to FastSheet

TreeGrid SpreadSheet features not supported by FastSheet

Choosing cell / cell ranges for formula across sheets.
Search in cells by user expression.
Cell hint showing the overflowed cell value.
Cell IDs for automated testing.
Localized to 14 languages, including all texts and date and number formats.
RTL (right-to-left) display for Middle Eastern languages.

Technical Specifications

Supported Browsers

Logo ChromeChrome
Logo EdgeEdge
Logo SafariSafari
Logo FirefoxFirefox
Logo Android WebViewAndroid
Logo Samsung InternetSamsung
Logo OperaOpera

And all Gecko and WebKit / Chromium / Blink engine clones

JavaScript Frameworks

The TreeGrid package includes examples and documentation for use with JavaScript frameworks:

ReactJavaScript / TypeScript
AngularTypeScript
VueJavaScript / TypeScript
SvelteJavaScript / TypeScript
EmberJavaScript / TypeScript
ExpressJavaScript
SalesForce LWCJavaScript
OtherHTML, JavaScript

The package can be used in any other client-side framework that supports third-party JavaScript code.

Server-Side Support

The TreeGrid package includes examples and predefined server script code:

NodeJS (JavaScript)
ASP.NET (C#, Visual Basic)
JSP (Java)
PHP
HTML (other)

TreeGrid SpreadSheet can integrate with any backend returning XML or JSON.

TreeGrid SpreadSheet standard look example

Articles about SpreadSheet

Real-world use cases, architecture notes and tips from teams shipping high-performance data grids.

Buyer Guide · Web Spreadsheets

Web Spreadsheet Buyer's Guide

A web spreadsheet is not just a grid with editable cells. It is a browser-based workspace that users expect to behave like Excel: formulas, formatting.

Read article
July 20259 min readSpreadsheetXLSX

Security Guide · JavaScript Components

CSP-Compatible JavaScript Components Guide

Content Security Policy, usually called CSP, is an important security mechanism for modern web applications. It helps control which scripts and resources.

Read article
July 20259 min readSecurityCSP

Framework Guide · React

React Data Grid Guide

A React data grid must do more than display rows. It must fit React's component model, state management patterns, rendering behavior and TypeScript usage.

Read article
July 20259 min readReactData Grid

Framework Guide · Angular

Angular Data Grid Guide

An Angular data grid must fit enterprise application architecture. Angular is widely used in structured, long-lived business applications where.

Read article
July 20258 min readAngularData Grid

Framework Guide · Vue

Vue Data Grid Guide

A Vue data grid should combine a smooth developer experience with enough performance and flexibility for real applications. Vue is often chosen for its.

Read article
July 20258 min readVueData Grid

Excel · Browser Editing

Can a JavaScript Data Grid edit Excel files?

Learn when a data grid can import, export and edit XLSX files — and when a full spreadsheet component is the better fit.

Read article
June 20256 min readExcelXLSX

Frameworks · Integration

Which JavaScript frameworks do data grids support?

Modern data grids need to fit real frontend stacks. Here is how framework support works across React, Angular, Vue, Svelte and Vanilla JavaScript.

Read article
June 20256 min readFrameworksJavaScript

Product Comparison · Data Grids

Which TreeGrid Component Should You Choose?

TreeGrid offers several JavaScript components for enterprise data applications. They share the same focus on complex browser-based data work, but they are.

Read article
June 20253 min readComparisonTreeGrid

Product Comparison · Web Spreadsheets

FastSheet vs SpreadSheet: Which Web Spreadsheet Is Right for Your Application?

FastSheet and SpreadSheet are both web spreadsheet components from the TreeGrid product family. Both can be used to open, edit and save spreadsheet-like.

Read article
June 20253 min readComparisonSpreadsheet

Product Comparison · Web Spreadsheets

TreeGrid vs SpreadSheet: Hierarchical Grid or Excel-Compatible Spreadsheet?

TreeGrid and SpreadSheet are related products, but they are designed for different user expectations. TreeGrid is a JavaScript data grid and tree grid.

Read article
June 20253 min readComparisonSpreadsheet

Web Spreadsheet · Excel Compatible · Workflow

10 things to watch out for when implementing an Excel-compatible spreadsheet in a web application

Templates, forms, validation, localization and auditability turn spreadsheet editing from a file attachment into a controlled part of the application workflow.

Read article
June 20259 min readSpreadsheetExcel

Web Spreadsheets · XLSX · Browser-based editing

Drop the file attachment: SpreadSheet in real-world projects

Open, edit, and save XLSX files in the browser with full Excel formula compatibility and 14 languages.

Read article
June 20259 min readEnterpriseSpreadsheet

Frequently Asked Questions

Everything you need to know about SpreadSheet

What is TreeGrid SpreadSheet and who is it for?

TreeGrid SpreadSheet is a browser-based spreadsheet component for developers who need to embed Excel-compatible spreadsheet functionality into a web application. It is suitable for teams that need to open, edit, and save XLSX files in the browser without requiring users to install desktop software.

Can XLSX files be opened and saved without a server?

Yes. XLSX files can be opened, edited, and saved entirely in the browser without any server round-trip. Alternatively, backend upload and download of XLSX files is supported if server-side persistence is needed. JSON and XML storage formats are also available.

What formula capabilities does SpreadSheet include?

SpreadSheet provides 230 built-in Excel-compatible formula functions, editable formulas starting with =, formula source cell selection by mouse including across sheets, external sheet references, user-defined names for cells and ranges, and custom expression-based calculations.

Does SpreadSheet support multiple sheets?

Yes. Multiple sheets are fully supported with the ability to add, delete, move, copy, and rename them. An interactive toolbar displays the sheet list. Cross-sheet formula references and cell range selection across sheets during formula editing are also available.

What editing features are available?

SpreadSheet offers Excel-like in-cell editing with keyboard navigation, single-cell and range cursors, multi-line and rich text editing, auto-fill and smart fill-down, copy and paste to/from Excel with style and format preservation, image insertion and manipulation by mouse dragging, mass operations across ranges, and a fully customizable context menu. Full undo/redo is included.

What cell formatting options are supported?

Dynamic cell styling covers color, font, alignment, text wrapping, and rotation. Cell borders can be configured with different widths, styles, and colors. Dynamic cell spanning is supported both vertically and horizontally. Automatic cell type detection and advanced formatting via format strings are also included.

What export and print options are available?

SpreadSheet exports to XLSX, CSV, PDF, and HTML with full formatting preservation. Print-ready layouts include automatic multi-page splitting and scaling. Changes can be synchronized with a backend via AJAX, form submits, or a custom API.

Does SpreadSheet support RTL languages?

Yes. Full RTL (right-to-left) display is supported for Middle Eastern languages. SpreadSheet is also localized to 14 languages, including all UI texts and date and number formats.

What does SpreadSheet offer that FastSheet does not?

SpreadSheet supports cross-sheet cell range selection during formula editing, search by user expression, cell hints showing overflowed content, cell IDs for automated testing, localization to 14 languages, and full RTL display for Middle Eastern languages — features not currently available in FastSheet.

Which frameworks and browsers does SpreadSheet support?

SpreadSheet works with React, Vue, Angular, Svelte, Ember, Express, Salesforce LWC, and Vanilla JavaScript. Full TypeScript definitions are included. It runs in Chrome, Edge, Safari, Firefox, Opera, Android WebView, and Samsung Internet.

Can SpreadSheet be used without writing JavaScript?

Yes. SpreadSheet can be configured and operated entirely through its UI without writing custom JavaScript. Responsive design and touch support are built in, and the component integrates with any backend returning XML or JSON.

Build powerful spreadsheets with TreeGrid

SpreadSheet brings comprehensive Excel-like functionality to the web.