License: MIT

Language: JavaScript

Handsontable Community Edition logo

Handsontable Community Edition (CE) is an open source JavaScript/HTML5 UI Spreadsheet component for web apps. It easily integrates with any data source and comes with a variety of useful features like data binding, validation, sorting or powerful context menu. It is available for Vue, React, Angular and Polymer.

If you are looking for an extended version, try out Handsontable Pro.

Build status npm npm

We are looking for Contributors who would like to help us with translations. Learn more
Most wanted languages: French, Chinese, Italian, Spanish, Swedish and Russian.

Table of contents

  1. What to use it for?
  2. Installation
  3. Basic usage
  4. Examples
  5. Features
  6. Screenshot
  7. Resources
  8. Wrappers
  9. Support
  10. Contributing
  11. Community
  12. License

What to use it for?

The list below gives a rough idea on what you can do with Handsontable CE, but it shouldn't limit you in any way:

  • Database editing
  • Configuration controlling
  • Data merging
  • Team scheduling
  • Sales reporting
  • Financial analysis


There are many ways to install Handsontable CE, but we suggest using npm:

npm install handsontable

Alternative ways to install

  • See the download section on how to install Handsontable CE using nuget, bower, yarn and more.

Basic usage

Assuming that you have already installed Handsontable CE, create an empty <div> element that will be turned into a spreadsheet:

<div id="example"></div>

In the next step, pass a reference to that <div> element into the Handsontable CE constructor and fill the instance with sample data:

var data = [
  ["", "Tesla", "Volvo", "Toyota", "Honda"],
  ["2017", 10, 11, 12, 13],
  ["2018", 20, 11, 14, 13],
  ["2019", 30, 15, 12, 13]

var container = document.getElementById('example');
var hot = new Handsontable(container, {
  data: data,
  rowHeaders: true,
  colHeaders: true



Some of the most popular features include:

  • Sorting data
  • Data validation
  • Conditional formatting
  • Freezing rows/columns
  • Merging cells
  • Defining custom cell types
  • Moving rows/columns
  • Resizing rows/columns
  • Context menu
  • Adding comments to cells
  • Dragging fill handle to populate data
  • Internationalization
  • Non-contiguous selection

See a comparison table




Handsontable CE comes with wrappers and directives for most popular frameworks:


Report all the suggestions and problems on GitHub Issues.

An open source version doesn't include a commercial support. You need to purchase Handsontable Pro license or contact us directly in order to obtain a technical support from the Handsoncode team.


If you would like to help us to develop Handsontable, please take a look at this guide for contributing.



Handsontable Community Edition is released under the MIT license. Read license.

Copyrights belong to Handsoncode sp. z o.o.

Project Statistics

Sourcerank 3
Repository Size 23.2 MB
Stars 0
Forks 0
Watchers 0
Open issues 0
Dependencies 1,769
Contributors 71
Tags 147
Last updated
Last pushed

Top Contributors See all

Marcin Warpechowski Jan Siegel Krzysztof Budnik psmolenski Wojciech Szymański Piotr Laszczkowski Jakub Klekociuk Grzegorz Bera Nicholas Bollweg buggythepirate piotr Cody Littley Steve Williamson Jayden Kneller P R Dinesh skilesare Tom Manderson Thanasis Polychronakis Jeff Francisco Tomek Wytrębowicz

Recent Tags See all

0.38.1 March 20, 2018
0.38.0 March 14, 2018
0.37.0 March 01, 2018
0.36.0 February 16, 2018
0.35.1 January 25, 2018
0.35.0 December 06, 2017
0.34.5 October 12, 2017
0.34.4 September 13, 2017
0.34.3 September 12, 2017
0.34.2 September 12, 2017
0.34.1 September 06, 2017
0.34.0 August 02, 2017
0.33.0 July 11, 2017
0.32.0 May 31, 2017
0.32.0-beta2 May 24, 2017

Something wrong with this page? Make a suggestion

Last synced: 2018-11-21 07:36:23 UTC

Login to resync this repository