github.com/revolist/revogrid @v4.23.20 sqlite

Powerful data grid component built with StencilJS.

Render 1M+ rows, millions of cells, and thousands of columns efficiently with no hard row limit in the grid.

Used by some of the largest companies in Europe and the United States.

Demo and API • Key Features • Pro Features • How To Use • Installation • Docs • License

RevoGrid material theme.

Key Features

• High Performance: Render 1M+ rows and millions of cells with no hard row limit in the grid. Virtualization keeps the DOM focused on the visible viewport.

• Accessibility: Follows WAI-ARIA best practices.

• RTL Support: Comprehensive Right-to-Left language support for Arabic, Hebrew, Persian, and other RTL languages. Features automatic column reordering, proper text alignment, and layout adjustments for RTL interfaces.

• Keyboard Support:

• Excel-like focus for efficient navigation and editing.

• Seamless copy/paste from Excel, Google Sheets, or any other sheet format.

• Lightweight: Minimal initial bundle size . Can be imported with polyfills or as a module for modern browsers.

• Intelligent Virtual DOM: Smart row recombination to minimize redraws.

• Virtual Scroll: Handles large datasets without rendering every row or column into the DOM.

• Drag and Drop: Drag and drop in rows and columns.

• Sorting: Multiple options, customizable per column, with advanced event handling.

• Filtering:

• Predefined system filters.
• Multi column filters.
• Conditional filters.
• Preserve existing collections.
• Selection.
• Slider.
• Header filtering.

• Custom filters to extend system filters with your own set.

• Export:

• CSV: Built-in file export for core RevoGrid data workflows.
• PDF: Browser-side PDF export with the lightweight @revolist/revogrid-pdf-export plugin.

• Excel (Pro): Workbook export for RevoGrid Pro with layout, styles, frozen panes, merged cells, and formulas.

• Custom Sizes: Define custom sizes for columns and rows. Automatic sizing based on content.

• Column Resizing: Adjust column widths.

• Auto Size Columns: Intelligent column width adjustment that automatically adapts to content, ensuring optimal readability and layout efficiency.

• Pinned/Sticky/Freezed Elements:

• Columns (define left or right).

• Rows (define top or bottom).

• Grouping:

• Column grouping (nested headers).
• Column grouping Drill Down: Collapse grouping columns to streamline your grid view, trimming away unnecessary columns and enhancing data organization. Perfect for focusing on the information that matters most, while keeping your workspace clean and efficient.

• Row grouping (nested rows).

• Column Types: More details

• Text/String (default).
• Number.
• Select/Dropdown.
• Date.

• Custom (create extended styles using any template).

• Range Operations:

• Selection.

• Editing.

• Theme Packages:

• Excel-like (default).

• Material (compact, dark, or light).

• Extensibility: Modern VNode features and tsx support for easy extension.

• Trimmed Rows: Hide rows on demand.

• Plugin System: Create custom plugins or extend existing ones easily.

• Customizations:

• Column header template.
• Row header template.
• Cell properties (define custom properties for rendered cells).
• Cell template (create your own cell views).

• Cell editor (use predefined or apply your own custom editors and cell types).

• AI Agents and MCP: Connect Codex, Cursor, Claude Code, and VS Code to version-aware RevoGrid docs, examples, migrations, feature availability, and typed API context.

• Rich API & Additional Improvements: Explore hundreds of other small customizations and improvements in RevoGrid.

RevoGrid Pro Features

RevoGrid Pro extends the core grid with production plugins for advanced data entry, analytics, layout, validation, remote data workflows, and enterprise planning.

• Advanced Data Structures:
• Hierarchical Data View: Display tree data with expandable rows, nested relationships, sorting, filtering, editing, and drag-and-drop friendly hierarchy handling.

• Row Transpose: Flip records into a row-oriented view when users need to inspect one entity as a vertical form-like grid.

• Headers, Columns, and Grid Structure:

• Multi-Level Headers / Column Groups: Build stacked, nested headers so related columns can sit under shared parent groups.
• Multi-Row Headers: Render more than one header row for dense tables, grouped labels, or spreadsheet-like header layouts.
• Column Group Panel: Let users drag columns into a grouping panel to create row groups interactively.
• Column Group Render Sync: Keep grouped header rendering aligned during column moves, resizing, and virtualization updates.
• Column Move with Groups: Move columns while preserving grouped header relationships and valid group boundaries.
• Column Collapse & Expand (Drill Down): Collapse grouped columns to focus on summary information, then expand when details are needed.
• Column Hide: Hide and reveal columns to create focused views without mutating the underlying dataset.
• Column Add Popup: Provide a UI flow for adding columns from available field definitions.
• Column Selection: Select entire columns from the header for bulk operations, copying, formatting, or analysis.
• Column Stretch: Distribute column widths to fill available grid space while respecting sizing constraints.
• Column Autosize: Measure content and automatically adjust column widths for readability.
• Merge Cells: Merge cells across rows and columns for grouped labels, reports, or spreadsheet-style layouts.
• Auto Merge / Same-Value Merge: Automatically merge neighboring cells with matching values to reduce visual repetition.
• Sticky Cells and Rows: Keep important rows, cells, totals, labels, or action areas visible while scrolling.

• Overlay Layers: Push temporary UI layers above the grid for richer interactions without replacing the main grid.

• Remote Data and Large Dataset Workflows:

• Server Loading with Infinite Scroll: Load remote data as users scroll, keeping memory and DOM usage controlled for large datasets.
• Infinite Scroll: Support total-based or dynamic scrolling patterns where rows are fetched and released in chunks.
• Pagination: Split large datasets into page-sized views with built-in navigation controls.
• Remote Pagination: Keep page index, page size, total counts, and server-loaded rows synchronized with the grid.

• Server-Side Grouping: Request grouped row blocks from a remote source, expand group paths on demand, and combine grouping with remote filtering, sorting, and export.

• Data Management and Change Tracking:

• Audit Trail History: Record data-change history for traceability, review, and compliance-oriented workflows.
• History: Track user edits and provide undo/redo controls for grid changes.
• History Controls: Add ready-made UI controls for navigating undo and redo stacks.
• Range Apply Preview: Preview copy, paste, or fill changes before applying them to target cells.
• Smart Auto Fill: Fill ranges from an initial value, series, or pattern to speed repetitive data entry.
• Excel Export/Import: Export and import Excel workbook formats including xlsx, xlsm, xlsb, and xls.
• Multi-Column Export Headers: Preserve grouped and multi-level column headers when exporting structured grids.

• Clipboard with JSON: Copy and paste structured JSON/object values while keeping control over parsing and rendering.

• Selection and Range Operations:

• Multi-Range Selection: Work with multiple selected ranges for spreadsheet-style copy, edit, and interaction flows.
• Range Selection Limit: Restrict selected ranges with configurable limits to protect performance and workflow rules.
• Row Checkbox Selection: Select rows through checkbox controls with bulk selection and keyboard-friendly behavior.
• Row Advanced Drag and Drop: Reorder rows with custom drag handles, multi-row behavior, and controlled drop handling.
• Row Expand: Add expandable row affordances for detail views, children, or custom row content.

• Row Custom Heading: Customize row header content for labels, actions, or contextual row information.

• Filtering, Search, and Grouping:

• Advanced Selection Filtering: Filter with multi-condition selection controls for categorical data.
• Selection Filter Cascade: Cascade filters so each choice narrows available values in dependent filters.
• Advanced Slider Filtering: Filter numeric values with range sliders.
• Header Input Filtering: Put filter inputs in the header area for fast per-column search.
• Date Filter: Filter temporal data by date-specific conditions and ranges.
• Row Grouping Drag and Drop: Drag fields into a panel to group rows dynamically.
• Grouping Aggregation: Calculate grouped summaries such as sum, average, count, min, and max.

• Server-Side Group Aggregation: Combine remote grouped data with aggregate values returned by the server.

• Calculations and Formulas:

• Formula Engine: Add Excel-like formulas with cell references, dynamic calculations, and a broad function set.
• Formula Bar: Give users a dedicated place to inspect and edit formulas.
• Formula Name Manager: Define reusable named references for formulas.
• Formula Dependency Highlighting: Highlight related cells so users can understand formula inputs and outputs.

• Summary Header: Render calculated summary values in header-level UI.

• Data Visualization and Cell Rendering:

• Charts in Cells: Render compact visuals such as progress lines, progress lines with values, sparklines, bar charts, timelines, rating stars, badges, change indicators, thumbs, and pie charts.
• Heat and Cold Maps: Color-code values with gradients and legends so users can compare magnitude quickly.
• Conditional Formatting: Apply styling rules based on cell values, row data, or custom logic.
• Multi-Cell Formatting: Choose different renderers or editors inside the same column based on row-level conditions.