<
DHTMLX Spreadsheet 5.2 Release: New Freezing and Hiding Options, Flexible Border Styling, and Formula Description
JavaScript

JavaScript Spreadsheet

Highly customizable JavaScript spreadsheet library with elegant Material style for editing and formatting data safely and conveniently.

Try Out DHTMLX Spreadsheet Demo

DHTMLX Spreadsheet JS library helps in creating Excel-like data tables with minimum time and effort.
Capterra Shortlist 2024
GetApp Category Leaders 2024
Software Advice Front Runners 2024
Best Meets Requirements
High Performer EMEA
Users Most Likely To Recommend
Easiest to Use

Enhance Your App with DHTMLX Spreadsheet Component

Built-in features

Add-on

Simple customization

Using 170+ predefined functions

The Spreadsheet JavaScript component includes hundreds of predefined math formulas and string, financial, and information functions users can apply to perform various calculations with values and strings. The functions are compatible with Excel and Google Sheets.

Working with multiple sheets

You can allow your users to work with multiple sheets. They may add a new sheet, rename it, remove an unnecessary one, and change the currently active sheet. Users can conveniently consolidate data from multiple sheets into a single one via cross-referencing.

Number formatting

You can apply different cell numeric values, including text, digits, percent, and currency signs. This Spreadsheet JavaScript example shows how to work with a time format that allows users to display numeric values in 12- or 24-hour formats. Moreover, you may change the settings of default number formats or create custom ones.

Excel export module

You can purchase a standalone module for exporting spreadsheet web-based tables to Excel (.xlsx) format. It can be deployed directly to your server or as a Docker image. Besides, you'll get all updates and fixes to the export service together with consultations on the Spreadsheet component.

Adding custom icons and toolbar buttons

By default, Spreadsheet UI is based on Material Design icons. However, you can add any other icon font pack as well as apply desired controls to the toolbar. For example, you can add a custom button to the toolbar to remove all content at once.

Enriching context menu controls

You have an option to add custom controls not only to the toolbar, but to other spreadsheet parts, including menu and context menu. Thus, you can add a Paint format control to the context menu and allow end-users to save cell style and apply it to other cells within seconds.

Multiple border styling options

Our JavaScript Spreadsheet includes flexible border styling for selected cells or cell groups. Users can access a wide range of customization options directly from the toolbar and choose which borders to modify (top, right, or all), adjust their color, and style to suit specific formatting needs.

JavaScript Spreadsheet Integrations

Angular

Angular Spreadsheet

Integrate DHTMLX with Angular to create a powerful Angular spreadsheet app. Simplify data workflows with advanced editing, built-in formulas, and customizable styling tailored for enterprise applications.
Vue.js

Vue Spreadsheet

Enhance Vue applications with a flexible Vue spreadsheet. Provide users with intuitive data entry, formula calculations, and formatting options while maintaining a smooth and responsive interface.
React

React Spreadsheet

Integrate the DHTMLX React spreadsheet component to enrich your projects with Excel-like functionality. Enjoy dynamic data tables, fast performance, and full compatibility with React’s component-driven architecture.
Svelte

Svelte Spreadsheet

Empower your Svelte projects with a lightweight Svelte spreadsheet component. Achieve efficient data management, seamless formula support, and easy customization without sacrificing speed or simplicity.

Spreadsheet Key Features

Intuitive Excel-like interface

Import and export of data to Excel (in all browsers except IE and Microsoft Edge)

Setting custom import/export path

Built-in and custom themes

Interface localization

Data searching and filtering

Merging and splitting cells

Columns' auto width

Frozen columns and rows

Plenty of operations for the grid


Cross-browser compatibility (IE11+)

Why Choose DHTMLX JavaScript/HTML5 Spreadsheet?

Operations for the grid

JavaScript spreadsheet supports the most essential features for displaying and formatting tabular data due to the simple API. Offering the basic Excel-like functionality, it allows you to embed the spreadsheet anywhere on a web page and work with the tabular data in a familiar way. The spreadsheet supports undo/redo actions, block selection, locking/unlocking cells, etc.

Cell formatting

With the formatting options of the DHTMLX Spreadsheet web component, you can style cells with custom colors and borders, adjust horizontal and vertical alignment, and enable text wrapping for better readability. End-users can clear values or styles in one click, while developers can apply styles via API. Built-in support for number, currency, and date formats ensures data is always displayed in the right way.

Custom look and feel

Need to build a complex financial app or use a simple JavaScript spreadsheet for internal purposes? Due to a wide range of configuration settings, you may fine-tune the layout, toolbar, menu, and context menu of your web-based spreadsheet. Thus, you can add custom toolbar controls and context menu items, replace the default icons with your preferred set, etc.

Support for Angular, React, and Vue

DHTMLX Spreadsheet comes with support for the most widely used client-side frameworks to meet the needs of the majority of developers. Integration with Angular, React, and Vue.js is smooth and requires just a few quick steps described in our guides.

Data import and export

Beyond grid operations and UI customization, DHTMLX Spreadsheet supports importing and exporting data in popular formats like Excel and CSV. This makes it easy to exchange data between your application and external tools, enhancing interoperability for business, financial, or reporting apps.

Get started for free

Download the DHTMLX Spreadsheet trial version and test it completely free of charge for 30 days taking advantage of our email technical support.

DHTMLX Spreadsheet Licensing

Individual
Total: $599
Commercial
Total: $1299
Enterprise
Total: $2899
Ultimate
Total: $5799
License Terms Read License Agreement Read License Agreement Read License Agreement Read License Agreement
Developers 1 5 20
Projects 1 1 5
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Standard Premium Premium Ultimate
Time Period 1 year 1 year 1 year 1 year
Updates Major, minor, and maintenance updates Major, minor, and maintenance updates Major, minor, and maintenance updates
Major, minor, and maintenance updates
Priority queue for bug fixing
Support requests 10 30 50
Response time 72h 48h 48h 24h
Personal Account Manager
Functionality
PRO PRO PRO + 1 add-on PRO + 1 add-on
Online export to Excel Free Free Free Free
Free local Excel export module
Individual
$599
License Terms Read License Agreement
Developers 1
Projects 1
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Standard
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 10
Response time 72h
Personal Account Manager
Functionality
PRO
Online export to Excel Free
Free local Excel export module
Commercial
$1299
License Terms Read License Agreement
Developers 5
Projects 1
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Premium
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 30
Response time 48h
Personal Account Manager
Functionality
PRO
Online export to Excel Free
Free local Excel export module
Enterprise
$2899
License Terms Read License Agreement
Developers 20
Projects 5
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Premium
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 50
Response time 48h
Personal Account Manager
Functionality
PRO + 1 add-on
Online export to Excel Free
Free local Excel export module
Ultimate
$5799
License Terms Read License Agreement
Developers
Projects
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Ultimate
Time Period 1 year
Updates
Major, minor, and maintenance updates
Priority queue for bug fixing
Support requests
Response time 24h
Personal Account Manager
Functionality
PRO + 1 add-on
Online export to Excel Free
Free local Excel export module

Unlock up to 65% Savings with DHTMLX Bundles

Documentation

Refer to documentation

The documentation for Spreadsheet includes API references and comprehensive guides, enabling you to set up and customize your spreadsheets easily. It also provides instructions on seamlessly integrating the library with React, Svelte, Angular, and Vue.js.
Samples

Explore code snippets

You have a great option to work with the Spreadsheet online, test out JavaScript and HTML code variations, and share your unique code snippets with your colleagues or DHTMLX support team.
Free trial

Download Spreadsheet trial

We recommend you explore the DHTMLX Spreadsheet functionality by obtaining the free 30-day trial version, complete with the latest updates and official technical support. There's no need for a credit card during the trial.
Official tech support

Learn about technical support

Whether you're a trial user or own a proprietary license, you can rely on DHTMLX technical or licensing assistance. We’ve outlined the ways to obtain support on the linked page.
Community forum

Use DHTMLX forum

You can exchange knowledge with other DHTMLX users and access the insights shared by fellow developers who are well-acquainted with the Spreadsheet. We diligently keep track of discussions and answer frequently raised questions.
Demos

Explore demo app examples

Get inspired for your web projects with our demo app collection, showcasing how to implement a spreadsheet for web development and other UI widgets in real-world applications.

What Customers Say

It is a robust and very powerful piece of software. It is bug free and does the job wonderfully. The features of the spreadsheet are very in depth. The ability to rely on such a great product prevented us from re-inventing the wheel.
Bilal C.
Bilal C.

Latest Blog Posts

Announcing the Repackaged DHTMLX Grid and Brand-New Table Pack Bundle
Guide into CRUD Operations in JavaScript by DHTMLX
Data Analysis with DHTMLX JavaScript Libraries
What's new
Discover the recently launched DHTMLX Spreadsheet versions, fresh developer guides, and tutorials with code snippets and practical tips from our tech team.

Frequently Asked Questions

How can I integrate DHTMLX Spreadsheet into React, Angular, or Vue.js applications?

DHTMLX Spreadsheet can be seamlessly integrated with React, Angular, and Vue.js. You should install the package, import the component, and initialize the spreadsheet within your framework's component lifecycle, thus leveraging reactive data binding and component-based architecture. Guides and examples in the official documentation of the Spreadsheet JS library demonstrate quick setup and integration steps.

Can I use DHTMLX Spreadsheet for building financial dashboards or SaaS platforms?

Yes, DHTMLX Spreadsheet is ideal for financial dashboards and SaaS platforms. Customizable Spreadsheet UI, Excel-like features, and support for large datasets make it suitable for complex data analysis and reporting in enterprise-grade applications. Developers can also implement formulas, formatting, and integrations with other services to deliver robust financial tools.

What are the key benefits of using DHTMLX Spreadsheet for enterprise data management?

DHTMLX Spreadsheet component offers precise control over data visualization and formatting. It supports large datasets, multi-sheet management, undo/redo, and integration with modern frameworks, streamlining enterprise workflows. This combination ensures accurate reporting, secure collaboration, and efficient handling of complex tabular data.

Does DHTMLX Spreadsheet support multi-sheet editing and cross-referencing data?

Yes, DHTMLX Spreadsheet in JavaScript supports multiple sheets and cell references across them. You can create formulas that pull data from other sheets, enabling complex calculations and consolidated reporting within a single spreadsheet instance. This is particularly useful for financial models, KPI tracking, or multi-department dashboards.

How does DHTMLX Spreadsheet compare to other Excel-like JavaScript libraries?

The Spreadsheet component stands out with its combination of lightweight performance, full customization, and multi-framework support. Unlike some libraries that focus solely on rendering or formula calculation, it provides an all-in-one solution with UI controls, multi-sheet management, and enterprise-grade features. This makes it suitable for both simple applications and complex business platforms.

Does DHTMLX Spreadsheet support working with large datasets efficiently?

Yes, it is designed to handle large datasets without compromising performance. Features like virtual rendering, efficient data loading, and selective updates ensure smooth interaction even with thousands of rows and columns. This makes it suitable for enterprise reporting and analytics applications.

Is there a free trial or online demo available for DHTMLX Spreadsheet?

Yes, DHTMLX offers both an online demo and a free trial. You can explore all core features, test integration with frameworks, and evaluate performance directly in your browser before making a purchase. This allows developers to quickly assess suitability for their projects.

Is DHTMLX Spreadsheet compatible with low-code or no-code AI platforms?

Yes, DHTMLX Spreadsheet can be integrated into low-code or no-code platforms that support embedding JavaScript components. Its API and event-driven architecture allow for dynamic data manipulation and visualization, making it a practical choice for extending the functionality of AI-powered workflow or business automation tools.

Manage large data sets conveniently with DHTMLX Spreadsheet

Download the Spreadsheet trial version and evaluate it free of
charge for 30 days getting assistance from the official support team.
NO credit card required
Send
a Question