Data Grid Add-on to 8sheets Spreadsheet
From raw records to answers, in the browser.
Search, filters, groups with subtotals, pivot reports and export to Excel, CSV and PDF in one JavaScript data grid. Open a local file or embed it in your app with one call. It is an add-on to 8sheets Spreadsheet: one price per company covers both, source code included.
- No licence key
- No runtime dependencies
- Files are never uploaded

- 88 ms
- to open 100,000 records with 20 fields (median of five runs)
- 34 ms
- to sort the same 100,000 records (median of five runs)
- 5 file types
- opened in the browser: XLSX, XLSM, XLTX, CSV and TSV
- 1 licence
- per company: Data Grid is included in the 8sheets Spreadsheet licence
Timings: headless Chromium 131, minified production build, records held in memory, 18 November 2026. Conditions and the full table
How people use it
Find it, total it, hand it over
A table should answer a question and let you pass the answer on. Data Grid covers the whole path.
Find the right records
Search across every field, combine typed filters and sort by several columns. The menu on a column header sorts, filters, groups, pins or hides that column. On a phone, a record opens in its own details panel.
- Search
- Compound filters
- Multi-column sort
- Record details
Group and compare
Nest groups, read a subtotal on each one and a total for the whole result. Sorting a grouped field orders the groups too. Turn the same records into a pivot report with a chart.
- Nested groups
- Subtotals
- Aggregates
- Pivot report
- Chart
Export exactly what you see
The download holds the matching rows and the visible columns, nothing else. Amounts and dates stay typed in Excel.
- Typed XLSX
- CSV
- No hidden data
Checked on the sample
The number on screen is the number in the file
We ran this on the sales example and compared the screen with each download. You can repeat it in a minute.
- The export is a new file. The XLSX has one fresh worksheet with typed results, and none of the source workbook’s notes, hidden columns or connections.
- The source stays as it was. Sorting, filtering and editing work on the view or on a private copy.
sales-table.xlsx, step by step
- Open the example Sales grouped by region, with a revenue subtotal per group60 records
- Search for East The count and the total follow the search21 records
- Read the revenue The same figure in the grid, the CSV and the XLSX19,262.80
- Hide Price, then export The Price column and the other regions are not in the fileCSV · XLSX · PDF
Features
Everything is in the one licence
There is no paid edition above this one. What is listed here is in the free app and in the licensed source.
Find
Search, filter and sort
Narrow a table to the rows that matter.
- Search across fields
- Text, number and date filters
- Combined conditions
- Multi-column sort
- Record details
- Phone layout
Analyse
Groups, totals and pivots
Summaries that follow the current filter.
- Nested groups
- Subtotals
- Result totals
- Pivot report
- Pivot chart
- Count, sum and average of a selection
Arrange
Columns and saved views
Each reader shapes the table without touching the data.
- Hide
- Reorder
- Pin
- Width
- Number formats
- Named views
- Light and dark theme
Edit
Editing, when you allow it
Off by default. Turned on, it changes a private copy.
- Field rules
- Add and remove records
- Range selection
- Copy and paste
- Fill down
- Undo and redo
- Calculated fields
Files
Real Excel files, read locally
Read in a Worker, with no extra library and no upload.
- .xlsx
- .xlsm
- .xltx
- .csv
- .tsv
- Pick a table, sheet or range
- Pick the header row
Embed
An API for your app
Local records or your own server behind the same grid.
- mountTable()
- getState()
- setState()
- exportResults()
- remoteTableSource()
- Host cell renderers
- TypeScript declarations
Privacy
The file stays on the device
A local file is read, filtered and exported in the browser. No backend receives it, in the free app or in your product. Records from your own server arrive only when you connect a remote source.
No upload
Files open from disk and exports are written in the browser. Nothing is converted on a server.
Work off the main thread
Reading the file, formula columns, sorting and exports run in a dedicated Worker.
No account
The app has no sign-up. Saved views are kept in the browser on that device.
For developers
One call puts it on your page
mountTable() takes an element and your records, a local file or a remote source, and returns a handle for state, export and disposal.
- Independent embeds. Each mount owns its search, selection, history and Worker, so several grids can share a page.
- Your server, your rules. A remote source asks for a window of rows and columns; your backend applies access control, filters, grouping and whole-result totals.
- Safe write-back. Remote edits carry the dataset revision, and a stale edit is refused.
- React, Vue and Angular components.
@8sheets/data-grid-react,@8sheets/data-grid-vueand@8sheets/data-grid-angularwrap the same call, typed with TypeScript, and give you every grid method through a ref. Framework components - Plain ES modules. No runtime dependencies, with TypeScript declarations and the source code.
import { mountTable } from '@8sheets/data-grid';
// The host element needs a height.
const grid = await mountTable(document.querySelector('#orders'), {
title: 'Orders',
fields: [
{ name: 'Region', type: 'string' },
{ name: 'Units', type: 'number' },
{ name: 'Price', type: 'number' },
{ name: 'Revenue', type: 'number',
formula: '[@Units]*[@Price]', format: '#,##0.00' },
],
data: [{ Region: 'East', Units: 2, Price: 24 }],
});
// Group by region and total the revenue.
await grid.setState({
...grid.getState(),
groups: [{ field: 'Region' }],
total: { field: 'Revenue', agg: 'sum' },
});
// The rows and columns on screen, as a Blob.
const report = await grid.exportResults('xlsx');
import { useMemo, useRef } from 'react';
import { DataGrid } from '@8sheets/data-grid-react';
// The same options as a component; every grid method is on the ref.
export function Orders({ orders }) {
const ref = useRef(null);
const options = useMemo(() => ({ title: 'Orders', data: orders }), [orders]);
return (
<>
<button onClick={() => ref.current.download('xlsx')}>Excel</button>
<div style={{ height: 480 }}>
<DataGrid ref={ref} options={options} />
</div>
</>
);
}
Measured
Timed next to AG Grid Community
The same records in both grids, in the same browser. We publish every figure from the run.
| Task | 8sheets Data Grid | AG Grid Community 36.3.0 |
|---|---|---|
| Open 10,000 records | 70 ms | 96 ms |
| Sort 10,000 records | 23 ms | 36 ms |
| Search 10,000 records | 33 ms | 34 ms |
| Open 100,000 records | 88 ms | 123 ms |
| Sort 100,000 records | 34 ms | 85 ms |
| Search 100,000 records | 33 ms | 200 ms |
How to read it
- Opening 100,000 records took 88 ms in Data Grid and 123 ms in AG Grid Community; at 10,000 records it was 70 against 96 ms. Data Grid’s time includes starting its Worker.
- Sorting 100,000 records took 34 ms against 85 ms.
- Searching 100,000 records took 33 ms against 200 ms.
- Searching 10,000 records is a tie: 33 and 34 ms. Both are bound by the two animation frames that end each timing.
Conditions: 18 November 2026, minified production build, headless Chromium 131 (Playwright 1.49.1) in a Linux container, 1200 × 800 viewport, AG Grid Community 36.3.0. Both grids were given identical generated JavaScript object records with 20 fields. Five separate runs; each figure is the median across runs. For sort and search, each run’s value is already the median of five operations, and each timing ends after two animation frames. Opening includes starting the grid’s Worker. The marker ◂ shows the lower time in a row; a difference of one millisecond is not marked. This measures local grid actions only, not network queries or opening an Excel file, and it is not an overall speed ranking. Handsontable was not timed. Benchmark on the comparison page
Why 8sheets
What you don’t pay for separately
Some grid vendors charge per developer and keep grouping, pivoting or Excel export for a paid edition. Here is how 8sheets differs.
- Per company
One price, every developer
A licence covers your whole company and unlimited deployments. AG Grid Enterprise is licensed per developer, and Handsontable prices by the number of end users through its sales team.
- Included
Grouping, pivots and Excel export
AG Grid lists row grouping, aggregation, pivoting, Excel export and clipboard operations as Enterprise features. In Data Grid they are part of the one edition.
- Built in
Opens Excel files itself
Data Grid reads XLSX in a Worker. The AG Grid and Handsontable guides for importing Excel files both use a third-party library.
- No key
No licence key, full source
Nothing to configure and nothing that can expire in production. You get the source code with the right to change it, and every version you received stays usable.
Competitor terms come from the vendors’ own pages, read on 18 November 2026: ag-grid.com/license-pricing, ag-grid.com/javascript-data-grid/excel-import, handsontable.com/pricing, handsontable.com/docs/javascript-data-grid/recipes/import-export/import-csv-excel. The comparison lists every source and where those grids are ahead.
Pricing
Included in the Spreadsheet licence
The app is free. Data Grid is an add-on to 8sheets Spreadsheet. Building either into your own tools or product takes one source licence, paid once per company.
The app
Free
Open your own XLSX or CSV file at grid.8sheets.com, with no account.
Try the sales tableSource licence
Included in the 8sheets Spreadsheet licence
- 8sheets Spreadsheet and the Data Grid add-on, in one licence.
- Every developer in your company, unlimited deployments.
- The source code, with the right to change it, and no licence key.
- 12 months of updates. Later updates are optional, and the versions you have stay usable.
Questions
Questions
Are my files uploaded anywhere?
No. Data Grid reads the file in a Worker in your browser and writes exports there too. There is no account and no server that receives the file.
Which files can it open?
XLSX, XLSM, XLTX, CSV and TSV. For a workbook you choose the table, worksheet, header row or range to read.
What exactly ends up in an export?
The rows that match the current search and filters, and the columns that are visible. You can export to CSV, a typed XLSX or PDF. The XLSX is a new file with one worksheet; hidden columns and the rest of the source workbook are not in it.
Can users edit the data?
Only if you turn it on. Editing then works on a private copy, with field rules, adding and removing records, copy and paste, fill down, calculated fields and undo. The original file is not changed; export the copy to keep the edits.
Does it work with data from my server?
Yes. A remote source sends the view state and the row and column window to your endpoint. Your server applies access control, search, filters, grouping and totals over the whole result, and can accept edits checked against a dataset revision. The source distribution includes a working example; a production backend has to implement the query against its own database.
How fast is it?
In our run of 18 November 2026 in headless Chromium 131, with 100,000 records of 20 fields, Data Grid opened in 88 ms, sorted in 34 ms and searched in 33 ms (medians of five runs). AG Grid Community 36.3.0 took 123, 85 and 200 ms on the same records. This is one browser and local data, not an overall ranking.
What does it cost?
Using the app is free. Data Grid is included in the 8sheets Spreadsheet licence: one company licence for Spreadsheet, paid once, that covers every developer, every deployment and the source code. Updates after the first 12 months are optional. The licences and their prices are on the Pricing page.
Is it open source?
No. It is commercial software sold with its full source code. A licence gives your company the right to read and change that code for its own products, but not to resell 8sheets itself as a component.
How is Data Grid different from 8sheets Spreadsheet?
Data Grid shows one table of records with named fields, for reading, summarising and exporting. Spreadsheet is the full workbook editor with sheets, formulas and charts. Data Grid has its own version, changelog and npm packages. It is included in the same Spreadsheet licence and delivered in the same source download.
Try it on your own data
Open the sales table, then load your own XLSX or CSV file. The app runs the same code as the source licence. Data Grid is an add-on to 8sheets Spreadsheet, included in that licence.