How can I help you?
Performance Metrics for Angular Spreadsheet Control
26 Mar 20263 minutes to read
The Syncfusion® Spreadsheet component provides a powerful, Excel‑like experience for web applications, allowing users to create, edit, view, and manage spreadsheets with ease. It supports large datasets, formulas, and interactive features such as styling, validation, sorting, filtering, and file import/export while maintaining a smooth and responsive user experience.
This document presents measured performance results for the Spreadsheet when working with large datasets and common operations such as rendering, styling, validation, and file import/export.
Environment
The following configuration was used for the performance evaluations:
- Browser: Microsoft Edge (latest stable)
- Hardware: 12th Gen Intel(R) Core(TM) i5-1235U
- RAM: 16 GB or higher
- Spreadsheet Version:
Evaluated Features
The following operations were measured to evaluate the Spreadsheet’s performance with large datasets: rendering, applying styles, number formatting, and data validation.
| Dataset Size | Initial Rendering | Styles | Number Format | Data Validation |
|---|---|---|---|---|
| 100k cells | 0.21s | 0.72s | 0.86s | 0.82s |
| 250k cells | 0.23s | 1.51s | 1.81s | 2.11s |
| 500k cells | 0.28s | 3.00s | 3.69s | 3.95s |
Import and Export Performance
The following table summarizes the import and export times for datasets that include various features such as formatting, validation, sorting, and filtering.
| Dataset Description | Import | Export |
|---|---|---|
| 100k cells with formats | 3.85s | 4.38s |
| 250k cells with formats | 3.96s | 6.61s |
| 100k cells with validation | 2.06s | 2.25s |
| 250k cells with validation | 3.77s | 18.04s |
| 500k cells with validation | 4.16s | 24.05s |
| 100k cells with sorting and filtering | 3.68s | 2.31s |
| 250k cells with sorting and filtering | 5.73s | 5.60s |
| 500k cells with sorting and filtering | 8.59s | 13.29s |
You can download the Excel files used for these measurements here.