Spreadsheet Plugin for CKEditor 4

The Spreadsheet plugin offers Excel-like functionality right inside CKEditor 4. It allows for creating complex data sheets that integrate smoothly with the existing CKEditor 4 WYSIWYG editor functionality and content, providing cell references, data types, formatting and styling, formulas, conditional formatting, support for pasting from Microsoft Excel and Google Sheets and more.

Refer to the Creating Data Grids with Spreadsheet Plugin article to learn more about the available features.

This feature is provided as a commercial product and provides integration with our partner solution, Handsontable. A license can be purchased here.

The Spreadsheet plugin is compatible with CKEditor 4 starting from version 4.13. It is not included in the CKEditor presets available from the Download site. Follow the instructions below to enable it.

Getting Started

Installation

There are a few methods that you can use in order to add the Spreadsheet plugin to your CKEditor 4 installation:

• Installation with npm
• Custom build with online builder
• Download manually from the Add-ons Repository

Refer to the Spreadsheets Integration - Quick Start section for installation steps.

Enable the Spreadsheet Plugin

The setup is straightforward — you just need to enable the plugin and add the license key in your CKEditor 4 configuration:

CKEDITOR.replace( 'editor', {
    extraPlugins: 'spreadsheet',
    spreadsheet_licenseKey: 'yourLicenseKey'
} );

The value of spreadsheet_licenseKey is unique for each website and can be found in the CKEditor Ecosystem customer dashboard. Go to Websites management and press the CKEditor configuration button to obtain it.

This is all. If you are having trouble with setting up the Spreadsheet plugin, please contact us.

Features

• Auto-updating cell references inside the editor content using smart suggestions.
• Support for pasting from Microsoft Excel and Google Sheets.
• Inserting spreadsheets with and without a header row or column and with any number of rows and columns.
• Inserting spreadsheets using predefined templates.
• Converting existing tables to spreadsheet instances and vice versa.
• Spreadsheet structure manipulation (adding or removing rows and columns).
• Resizing rows and columns.
• Single and multi-column sorting.
• Basic data styling like bold, italic, underline and so on.
• Advanced styles support like font family, font size, text and background color or text alignment.
• Selecting cell type and formatting with data validation support.
• Using formulas.
• Auto filling rows and columns.
• Applying various conditional formatting rules to single and multiple cells, entire columns or spreadsheets.
• Advanced copying and pasting.

Refer to the Creating Data Grids with Spreadsheet Plugin article for an overview of all available features of the Spreadsheet plugin.

Browser Support

The spreadsheet plugin is fully supported in the latest Chrome, Firefox, Safari and Edge browsers.

Support for Internet Explorer 11 is limited: the plugin is usable but there are known, visible issues.

If your application requires wider support for Internet Explorer 11 or you have encountered any issues using it, please contact us.

Demo

See the working "Creating Data Grids with Spreadsheet Plugin" sample that showcases the most important features like data styling, sorting, conditional formatting, formulas and more.

License

CKEditor 4 Spreadsheet plugin (https://ckeditor.com/ckeditor-4/spreadsheets/) Copyright (c) 2003-2020, CKSource Frederico Knabben. All rights reserved.

CKEditor 4 Spreadsheet plugin is licensed under a commercial license and is protected by copyright law. For more details about available licensing options please contact us at [email protected].