About Handsontable

JavaScript data grid that looks and feels like a spreadsheet.

Handsontable is a JavaScript/HTML5 data grid component with a spreadsheet look and feel that is independent from any external framework. It can be easily modified or extended with custom plugins. It also binds to any source using the JSON format and is capable of handling large amounts of data. You can easily perform data binding, data validation, filtering, sorting and CRUD operations, and provide end-users with an Excel-like experience. Handsontable comes with wrappers and directives for most popular frameworks, such as Angular, React and Vue. The component supports multiple languages including Chinese, Japanese, German, Spanish, French, Portuguese, Polish and Russian.

Handsontable Features

• Accessibility - Be able to use screen readers and navigate between cells.
• Alignment - Decide where the content is placed within the cell or a range of cells.
• Autocomplete - Choose one of the suggested options while typing or entering a custom value.
• Binding rows with headers - Bind rows with headers to lock the row number and always display one beside the other.
• Checkbox - Add a checkbox to a cell to indicate binary choices.
• Collapsing columns - Expand and collapse columns to better fit the content.
• Column summary - Make pre-defined calculations and display the results in Handsontable.
• Comments - Provide an additional note about the cell to help better understand its content.
• Conditional formatting - Define how specific cells are formatted depending on their values.
• Context menu - Invoke a shortcut menu to choose an action related to the selected object.
• Copying - copy data with and without headers.
• Custom borders - Apply custom border style around cells or range of cells.
• Custom buttons- Insert and remove column or row using custom action buttons.
• Custom Cell Types - Use Handsontable itself as a custom cell editor.
• Custom HTML - Display HTML content in a cell or header.
• Data validation - Control what values can be entered into a cell.
• Date - Use a date picker to select a date.
• Disable cell editing - Make cell non-editable without changing its appearance and behaviour.
• Drag-down - Drag the fill handle (a square in the bottom right corner of the cell) to fill cells with data series.
• Dropdown - Create an advanced dropdown list of choices in a cell.
• Dropdown menu - Add a menu to the heading to enable additional operations for the columns.
• Export to file - Export data to a flat file like CSV or a string.
• Filtering - Display rows that meet your criteria and hide the rest.
• Fixed rows and columns - Define which rows or columns are visible while scrolling down or across the table.
• Formulas - perform extensive calculation capabilities based on formulas using the spreadsheet notation.
• Freezing - Create freeze columns to keep them visible while scrolling.
• Hiding columns - Hide specific columns and show the rest.
• Hiding rows - Hide specific rows and show the rest.
• Highlighting current - Indicate the entire active column or row.
• Internationalization - Change the text of the UI for the purpose of translating it to specific languages.
• Merge cells - Display cells across multiple rows or columns.
• Moving - Drag rows or columns to swap them within the table.
• Navigable headers - Use keyboard navigation to navigate between table elements and execute operations.
• Nested headers - Create a nested, hierarchical structure of headers to get your data into groups.
• Numeric - Type a custom number format in a cell.
• Pagination - Limit the number of records being displayed in a single view.
• Password - Use asterisks to mask the value in a cell.
• Pre-populating new rows - Create empty cells with predefined types or values
• Read-only - Lock the cell or a range of cells to disallow altering them.
• Resizing - Drag the sizing handle to change the size of column or row.
• RTL Support - Support RTL mode for the whole table.
• Scrolling - Use native scrollbars to navigate within the table.
• Search for values - Search through the content with the search field.
• Select - Create a simple dropdown list of choices in a cell.
• Sorting/multi column sorting - Sort data in ascending or descending order throughout the column or multiple columns.
• Stretching - Allow columns to the parent container width.
• Trimming rows - Exclude specific rows from the rendering process so they won't be displayed.