Enide Studio

JavaScript SpreadSheet/DataGrid

20 August 2013

by Paul Verest

NOTE: This is open-source article you can contribute and extend.

Looking closely

Advice: When started search never, never stop on the first finding, but use it as base for search and comparison. When it is the best it is connected with other solutions more then any.

I started my search from DHTMLX, then googling. When a got several results, I asked friend. Then I went to StackOverflow.com that revealed a bit different picture.

Popular free open-source grids jqGrid, Flexigrid, SlickGrid, DataTables are all dependent on jQuery.


added 2013-08-29.

http://handsontable.com/ https://github.com/warpech/jquery-handsontable 2200 stars Marcin Warpechowski

Live example

Similar projects

I want to stay motivated to keep Handsontable the best possible editable datagrid on the Web. Therefore, I invite you to check out alternative projects. I would love to receive feedback if you would like to import some of their features to Handsontable.


A friend of mine advised me SlickGrid, that was great help because I could not find it. (Now I added it into Wikipedia, so maybe you have already found this way).

It is just 1 year old project hosted on GitHub, that grew popular (3000+ stars). However it is personal projects and the author seems to be overwhelmed with issues and Pull Requests stream.

project wiki, online examples

SlickGrid seems to focus on performance from the very beginning. 50k+ rows is quite normal.


jQuery Grid 1.0 beta May 5th, 2007 jQuery Grid is my first jQuery plugin…

project home, sources, online examples

jqGrid is oldie, with a lot of online info and maybe some dust. It supports data from XML sources, it is likely has started from XML then added JSON.

jqGrid is foundation for commercial offering Trirand jqSuite http://www.trirand.net.


Very lean web site http://flexigrid.info/ has examples, and all links. code on GitHub 400 stars

Last code update 4 month ago, seems a bit quiet.


DataTables https://datatables.net

In order for DataTables to be able to function correctly, the HTML for the target table must be laid out in a well formed manner with the ‘thead’ and ‘tbody’ sections declared.

sources on GitHub 900 stars

The development went plugin way: Core DataTabled is now stable for a year, while development goes in additiona features.


  • Long list of jQuery UI plugings: [jQuery UI Frameworks To Improve Visitors’ User Experience – 25 Plugins] (http://www.designyourway.net/blog/resources/jquery-ui-frameworks-to-improve-visitors-user-experience-25-plugins/)

SlickGrid Vs JQGrid


What I could find in the very beginning by googling (P.S. was not actually the best way to start):


site, wikipedia


dhtmlxSpreadsheet is an open source spreadsheet widget written in JavaScript and PHP that allows you to quickly add an Excel-like, editable data table on a web page. It is also available as a plugin for WP, Joomla, etc.

Free for only GPL-ed projects, then $149 or $449

It exists since 2005 and grow popular, there are some plugins. However it is not fully free, and not pure JavaScript. Though it is the closest approximation to Excel.


http://jqueryplugins.weebly.com/jquerysheet.html by Visopdev http://visop-dev.com/Project+jQuery.sheet

online demo

Was not tried yet.

Simple Spreadsheet


company site, wikipedia


Simple Spreadsheet (0.5)
Simple Spreadsheet (0.5) - Charts   
Simple Spreadsheet (0.4) </tbody> Was not tried yet. #### Sheetster <http://en.wikipedia.org/wiki/Sheetster> <http://sourceforge.net/projects/sheetster/> > 0 Downloads (This Week) > Last Update: 2012-12-13 Seems to be dead. I have not tried. #### EditGrid ![](http://feed.editgrid.com/wordpress/wp-content/uploads/2008/09/MarketMonitor2.png) http://www.editgrid.com/ Was not tried yet. #### jqwidgets Nice commercial widgets based on jQuery. http://www.jqwidgets.com/ <http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm#demos/jqxgrid/spreadsheet.htm> ### Other lists - [List of Online Spreadsheets](http://en.wikipedia.org/wiki/List_of_online_spreadsheets) - [Comparison of spreadsheet software](http://en.wikipedia.org/wiki/Comparison_of_spreadsheet_software) ### Conclusion There are a lot of commercial tools with varying degree of quality. Popular free open-source grids jqGrid, Flexigrid, SlickGrid, DataTables are all dependent on jQuery. I am going to try open-source SlimGrid first. It is the newest projetc with ideas for performance optimization from the very beginning, and more closer to Excel experience.
comments powered by Disqus