FastGrid

Ultra-Fast JavaScript Grid for Large-Scale Data

Handle millions of rows or columns with smooth virtual scrolling and no pagination.
Edit, sort, filter, group, search, pivot, copy, paste, import, export and print - all in one high-performance JavaScript data grid.

Why FastGrid

Lightning Performance

Scroll through millions of rows with no gaps or delays. Virtual scrolling, lazy loading and optimized rendering deliver real-time responsiveness even on massive datasets.

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 export data in JSON, XLSX or CSV. Communicate with any backend, with support for background loading and large-scale data flows.

Export & Print

Export full datasets to XLSX, HTML, CSV and PDF with custom styling. Print-ready layouts include automatic splitting and multi-page scaling.

Advanced Features

Advanced grouping, pivoting, filtering, sorting, aggregation, built-in charts and conditional formatting optimized for enterprise analytics.

Features and Advantages

Comprehensive capabilities for enterprise-level data management

Performance & Optimization

Speed and efficiency advantages

Display millions of rows or columns without pagination using virtual scrolling.
Lightning-fast rendering with smooth scrolling
Smart virtualization loads only visible cells.
Memory-efficient architecture with automatic cleanup.
Optimized for large datasets using minimal DOM footprint.
Lazy loading and progressive data fetching
Caching and memoization for repeated operations.
Optimized and fast JSON I/O format.
Optional ultra-fast UTF8 Store data format.

Calculations & formatting

Cell formats and Excel-like and JavaScript formulas

Full Excel-style editable formula engine with 200+ functions.
Expression-based calculations and custom formulas.
Full JavaScript formulas and calculations in data.
Cell types: text, HTML, number, date, checkbox, combo box, image, link...
Support for side icons and buttons in cells.
Multi-state checkboxes for advanced workflows.
Simple and calculated bar & line charts embedded directly in cells.
Advanced formatting based on type and format strings.
Conditional formatting with custom rules and conditions.

Advanced Layout

Special grid structure features

Each row supports its own column structure and widths.
Each column section supports its different rows & heights.
Unlimited independently-scrollable and resizable sections.
Sticky rows remain visible during vertical scrolling.
Sticky cell text remains visible during horizontal scrolling.
Cell spanning across rows, columns or both directions.
Customizable state colors, icons and indicators.
Optional column-based grid mode for alternative layouts.

Layout Operations

Rows & columns manipulation

Add, copy and delete rows and columns.
Resize, move and hide row and columns.
Freeze rows and columns on all sides.
Drag rows or columns between grids.
Resize row and column sections and the entire grid.
Span cells dynamically for layout flexibility.
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.
Auto-complete with suggestions and rules.
Advanced validation via custom rules or regex.
Input masks with regular expressions.
Multi-line editing in text areas
Rich text editing with full formatting and styling.

Advanced Editing

Extra editing features

Auto-fill and smart fill-down operations.
Copy & paste cells and ranges from and to Excel and other spreadsheets.
Copy & paste cell styles and formats.
Calendar picker for date cells.
Inserting images floating above cells like in Excel.
Manipulating and changing images by mouse dragging.

Tree & Hierarchical Data

Multi-level structures and pivot tables

Unlimited tree hierarchy for rows and columns.
Expand & collapse with keyboard shortcuts.
Row tree can be split in more columns.
Dynamic multi level pivot tables with drag & drop configuration.
Editable pivot cells with automatic or custom aggregation
Flexible grouping with automatic or custom aggregation
Tree filtering and search capabilities for hierarchical datasets.
Expand indicators displaying number of hidden items.

Filtering & Analysis

Advanced filtering, sorting and data analysis

Excel-style auto-filter with checkbox lists.
Expression filtering with custom operators
Global Google-like full-text search.
Custom filter functions and predicates.
Multi-column sorting with custom comparators.
Sorting and filtering both rows and columns.
Aggregation functions (sum, average, count, ...).
Statistical analysis and data summaries.

Export & Integration

Export capabilities and framework support

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.
Works with React, Vue, Angular, Svelte and Vanilla JavaScript.
Full TypeScript definitions and IntelliSense 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.
Responsive design with mobile and touch support.
Customizable toolbar and context menu options.
Full manual and automatic toolbar arrangement.
Customizable cell styling and formatting.
Custom cell renderers and editors.
Flexible layout options with unlimited sections.
Localization to any language possible, including date and number formats.
Fully customizable key and mouse navigation action schemes.
User-managed configuration profiles.

FastGrid Advantages to TreeGrid

FastGrid features not supported by TreeGrid

Significantly faster rendering and scrolling
Handles millions of rows without paging
Zero scroll gap or blank areas during scroll
Extremely compact and fast UTF8 Store data format
Each row supports its own column structure and widths.
Each column section supports its different rows & heights.
Unlimited resizable and scrollable row and column sections
Sticky rows remain visible during vertical scrolling.
Fixed scroll by whole rows or row groups
Multi-column row tree.
Sorting, filtering and grouping columns.
Optional column-based grid mode for alternative layouts.
Static HTML cells not re-rendered.
Simple and calculated bar & line charts embedded directly in cells.
Multi-state checkboxes with numbers.
Expand icons indicators displaying number of hidden items.
Small state or informational icons in every cell.
Toolbar icons and positions automatically arranged and wrapped.
Toolbar icons and positions can be manually customized by users.
Users can use, manage, load and save multiple configurations.

Technical Specifications

Supported Browsers

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

All WebKit / Gecko / Blink based engines

JavaScript Frameworks

The FastGrid 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 FastGrid package includes examples and predefined server script code:

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

FastGrid can integrate with any backend returning JSON.

FastGrid Pivot Example

Speed up your web grid

FastGrid does what other components slow down on.