ParamQuery grid is the fastest jQuery grid plugin with enterprise features like row grouping, pivot, treegrid, column grouping, nesting, batch editing, export to multiple formats, selections, full keyboard navigation in addition to the basic features like sorting, filtering, paging, inline editing, validations, etc.
It can also be used as plain javascript grid or with contemporary frameworks like Angular, React, Vuejs, etc. Examples are provided for the usage of ParamQuery with aforementioned frameworks.
It truly supports unlimited rows and columns with blazing fast performance.
Server side interaction is based on simple RESTful API and it can be used with Nodejs, Python, PHP, ASP.NET, J2EE, Cold fusion, etc
Its data can be served from and persisted in any kind of database like Sql server, MySQL, MongoDB etc.
Free version of grid is released under GPL v3 license while Pro version is released under Commercial and OEM license.
Please scroll down for feature wise comparison between free and Pro versions.
ParamQuery is an exceptionally lightweight yet powerful JavaScript spreadsheet and grid solution. Despite its minimal file size and memory footprint, it delivers unmatched performance—loading large datasets dramatically faster than any other JavaScript-based spreadsheet.
Don’t take our word for it—try it yourself.
It includes all essential spreadsheet features: Autofill, unlimited worksheets, cross-sheet formulas, Excel-style functions, styling, date and number formatting, comments, merged cells, and seamless import/export in Excel (xlsx), CSV, HTML, and PDF formats.
Every worksheet, cell, row, and column is represented as a plain JavaScript object, allowing dynamic manipulation—much like VB scripting in Excel or Apps Script in Google Sheets.
After importing an Excel file, you can instantly use it as a spreadsheet, grid, or treegrid—switching between them effortlessly. ParamQuery uniquely blurs the boundaries between these components, offering true interoperability across grid, treegrid, and spreadsheet modules.
Few of our esteemed users
Feature comparison between Free and Pro versions
| Features | Free version | Pro version | Comments |
|---|---|---|---|
Framework support |
|||
| Plain js | yes | yes | |
| Angularjs | yes | yes | |
| Angular(2+) | yes | yes | |
| jQuery | yes | yes | jQuery >= v2.x, jQueryUI >= v1.12.x |
| Knockout | yes | yes | |
| React | yes | yes | |
| Vue | yes | yes | |
Browser support |
|||
| Chrome | yes | yes | |
| Edge | yes | yes | |
| Firefox | yes | yes | |
| IE | yes | ||
| Safari on Mac | yes | yes | |
Rendering |
|||
| Virtual rendering( unlimited rows & columns ) | yes | yes | Pro version is tested upto 50 milliion rows. |
| Infinite scrolling | view | view, view | |
| Scrolling mode in virtual rendering | Step scrolling | Smooth scrolling | |
| Auto height of rows in virtual rendering | yes | yes | Very few grids support this feature. |
| Conditional styles of rows/cells | yes | yes | |
| Touch & swipe support | yes | yes (native) | |
| Context menu | view | ||
| RTL ( Right to Left ) layout | view | ||
Drag and drop |
|||
| Reorder rows | view | ||
| Between grids | view | ||
| Between grid and other components | view | ||
| Reorder rows in grid with row grouping | view | ||
| Between grids with row grouping | view | ||
| Reorder rows in treegrid | view | ||
| Between treegrids | view | ||
Excel like features |
|||
| Number and date formatting | Basic | Advanced | |
| Frozen rows, columns and summary rows | yes | yes | |
| Keyboard navigation | yes | yes | |
| Copy paste | yes (Plain) | yes (Rich) | |
| Auto fill, drag to fill | view (Plain) | view (Rich) | Very few grids support these premium features. |
| Merge cells | view, view | view, view | |
| Standalone javascript workbook (useful to export / import even third party components) | - | view | |
| Import from xlsx of data, formatting, pictures, multiple spreadsheets, etc | - | view | |
| Import from csv | - | view | |
| Excel formulas | - | view | |
Export |
|||
| Export to Excel | yes (xlsx format) | yes (xlsx format) | |
| Export of data, merge cells, Excel formulas, number and dates formatting, grouped rows & columns, pictures to multiple spreadsheets | - | yes | |
| Combined export of multiple grids to one workbook | - | view | |
| Export of static and conditional styles | - | view | |
| Preservation of data type of cells (dates, numbers) between Excel export and import | - | yes | |
| Export to csv | yes | yes | |
| Export to html | yes | yes | |
| Export to pdf | - | yes | |
Pivot gid |
|||
| Pivot grid with drag n drop toolPanel | - | view | |
Tree gid |
|||
| Tree grid with aggregates, cascade checkboxes, custom icons, etc | - | view | |
| Tree grid with lazy loading | - | view | |
Hierarchy |
|||
| Row details | yes | yes | |
| Nested grids (upto any level) | yes | yes | |
Row grouping |
|||
| unlimited columns | yes | yes | |
| OLAP mode | - | yes | |
| Grouping toolbar | - | yes | |
Column grouping |
|||
| unlimited levels | yes | yes | |
| Collapsed columns | - | yes | |
Paging |
|||
| Local | yes | yes | |
| Remote | yes | yes | |
Sorting |
|||
| Local | yes | yes | |
| Remote | yes | yes | |
Filtering |
|||
| Local | yes | yes | |
| Remote | yes | yes | |
Selections |
|||
| Row | yes | yes | |
| Cell | yes | yes (Range based API) | |
| Checkbox selections | yes | yes | |
Inline editing |
|||
| Row editing | yes | yes | |
| History, undo & redo | yes | yes | |
| Batch editing with commit and rollback | yes | yes | |
| Validations | yes | yes | |
| Conditional editability | yes | yes | |
Licensing |
|||
| License | GPL v3 | Evaluation, Commercial & OEM | |
Download |
|||
| Download url ( opens a new window ) | [ Download ] | [ Download ] | |
