SpreadSheet Grid

No data-binding

SpreadSheet Grid can work as a controlled and uncontrolled component. It renders based on the props just like any React component.

Frozen rows and columns

Freezing rows and columns is a breeze. You can customize this on for each sheet.

Autofilters

Filter views lets you slice and dice data right in the SpreadSheet Grid

Custom Editors

You can use your own React component as Cell Editors

Custom Cell Renderers

Using React Konva, you can declaratively render any canvas element on to SpreadSheet Grid.

Data validation

Validate your data, prompting user to select from dropdown, datepicker, checkbox etc

Styling

Each cell in the grid can be customized as per your liking. Add borders, colors, stroke styles or custom gradients very easily.

Copy/Paste/Cut and Undo/Redo

All operations have first-class support in SpreadSheet Grid.

Custom fonts

You can use any fonts in SpreadSheet Grid. It can be linked locally or loaded from Google fonts, typekit, fonts.com etc.

Context Menu

Either use the built-in Context Menu or easily switch to your own React Component

Merge cells

Merging multiple cells is a breeze. Use this to create nested or spanned headers or data.

Export and Import Excel and CSV files

You are able to import any excel or csv files to SpreadSheet Grid. Exporting to the formats is also supported.

Hide, Insert, Delete rows and columns

Rows and columns can be easily hidden or shown. Currently these functions are available in Context Menu or as Sheet Config

Text Formatting

Full support for text formatting, just like Excel and Google sheets. Align, change fonts, make text bold, add underline or custom number format is very easy.

Data types

SpreadSheet Grid supports numbers, string, checkbox, hyperlink, error, date (soon), rich text(soon), formula(soon)

Dark mode

Excel may not support it yet, But SpreadSheet Grid does. Switch to dark mode and start working on your datasheet at your convenience.

Outline/Grouping support (coming soon)

Allow collapsing rows and columns using native excel outline feature.

Filter sorting (coming soon)

Currently, sorting should be done outside SpreadSheet Grid, but core support is landing soon.

Conditional formatting (coming soon)

Currently conditional formatting can be done using a custom cell renderer. Core support will be available soon.

Formula (beta)

Make complex calculations, with cross-sheet references, external data source etc. High performance as calculations run in a separate thread.