Feature and compatibility comparison.

Compare selected editing features and file import/export capabilities with similar products. This page does not cover the full Univer Office SDK.

Comparing spreadsheet SDKs? See how Univer differs from SpreadJS, Handsontable, ONLYOFFICE, and Syncfusion.

  • All groups

  • Supported
  • Partially supported
  • Not supported
  • Open sourceFully supported in the open-source edition

Sheets

Compare spreadsheet editing, formulas, data analysis, automation, and file compatibility.

Sheets: Univer Sheets, Microsoft Excel, Google Sheets
Feature and scopeUniver SheetsFull Office SDK · optional modulesMicrosoft ExcelMicrosoft 365 · Windows desktopGoogle SheetsWeb version
Worksheets, rows, and columns 6 features
Multiple worksheets, duplication, and orderingSupportedOpen sourceSupportedSupported
Insert, delete, and move rows and columnsSupportedOpen sourceSupportedSupported
Row height, column width, and AutoFitSupportedOpen sourceSupportedSupported
Merge and unmerge cellsSupportedOpen sourceSupportedSupported
Freeze Panes; hide and unhide rows and columnsSupportedOpen sourceSupportedSupported
Group and outline rows and columns: expand and collapseSupportedSupportedSupported
Editing and cell formatting 9 features
Copy, paste, and Paste SpecialSupportedOpen sourceSupportedSupported
AutoFill numbers, dates, and formula sequencesSupportedOpen sourceSupportedSupported
Find and Replace; locate cells by contentSupportedOpen sourceSupportedSupported
Fonts, colors, and rich text within cellsSupportedOpen sourceSupportedSupported
Alignment, wrapping, fills, and bordersSupportedOpen sourceSupportedSupported
Number, currency, date, and custom formatsSupportedOpen sourceSupportedSupported
Rotated and vertical textSupportedOpen sourceSupportedSupported
Floating and in-cell imagesSupportedOpen sourceSupportedSupported
Drawing objects: shapes, text boxes, arrows, and connectorsSupportedSupportedSupportedBuilt-in drawing editor
Conditional formatting 3 features
Conditional formatting based on values, text, or formulasSupportedOpen sourceSupportedSupported
Color scales, data bars, and icon setsSupportedOpen sourceSupportedPartially supportedSupports single-color rules and color scales, but not Excel-style native data bar or icon set rules.
Rule priority and Stop If TrueSupportedSupportedPartially supportedApplies the first matching rule in list order; does not offer all of Excel's Stop If True settings.
Sorting and filtering 5 features
Single-column and multi-column sortingSupportedOpen sourceSupportedSupported
AutoFilter: filter by values and conditionsSupportedOpen sourceSupportedSupported
Filter by font and cell fill colorsSupportedOpen sourceSupportedSupported
Sheet Views: sort and filter without affecting collaboratorsNot supportedSupports AutoFilter, but not Sheet Views that leave other collaborators' sorting and filtering unchanged.SupportedSupported
Sort by font and cell colorsNot supportedNo built-in sorting by font or fill color; filtering by both colors is supported.SupportedSupported
Data validation and cleanup 5 features
Data Validation: drop-down lists, custom formulas, and input rulesSupportedOpen sourceSupportedSupported
In-cell checkboxes and custom checked valuesSupportedOpen sourcePartially supportedNative in-cell checkboxes use TRUE/FALSE. Custom checked values require formulas or other controls.Supported
Remove DuplicatesNot supportedNo built-in Remove Duplicates command.SupportedSupported
Text to Columns: split delimited textNot supportedNo built-in Text to Columns command.SupportedSupported
Trim extra spaces in textSupportedSupportedSupported
Tables and structured references 2 features
Table headers, styles, and filtersSupportedOpen sourceSupportedSupported
Structured references by table, column, and current rowSupportedOpen sourceSupportedPartially supportedSupports table and column references, but not #This Row. References in chart, pivot table, and conditional formatting ranges also have limitations.
Formulas, functions, and calculation 18 features
Aggregations: SUM, AVERAGE, COUNTSupportedOpen sourceSupportedSupported
Logic, text, and dates: IF, TEXT, DATESupportedOpen sourceSupportedSupported
Lookups: VLOOKUP, INDEX, MATCH, XLOOKUPSupportedOpen sourceSupportedSupported
Array calculations: FILTER, SORT, UNIQUESupportedOpen sourceSupportedSupported
QUERY: SQL-like filtering, sorting, and grouped aggregationsNot supportedNo native QUERY function or SQL-like query strings.Not supportedNo native QUERY function. FILTER, SORT, GROUPBY, and other formulas can cover some querying and aggregation needs.Supported
LET, LAMBDA, and MAP / REDUCE / SCANSupportedOpen sourceSupportedSupported
Defined names and cross-sheet referencesSupportedSupportedSupported
Dynamic array formulas: spilling and blocked spill rangesSupportedOpen sourceSupportedSupported
Spilled range operator (#): Excel A1# referencesSupportedSupportedPartially supportedARRAYFORMULA can expand array results, but Excel's A1# spill range reference syntax is not supported.
Generate arrays with SEQUENCE and RANDARRAYSupportedOpen sourceSupportedSupported
Legacy Ctrl+Shift+Enter array formulasSupportedSupportedPartially supportedCtrl+Shift+Enter adds ARRAYFORMULA. Fixed-range calculation and export behavior differ from Excel CSE formulas.
Financial functions: PMT, NPV, IRRSupportedOpen sourceSupportedSupported
Engineering unit conversions and complex numbersSupportedOpen sourceSupportedSupported
Create, reuse, and import named functionsSupportedSupportedSupported
Iterative calculation and convergence settings for circular referencesSupportedOpen sourceSupportedSupported
Trace Precedents, Trace Dependents, Evaluate Formula, and Watch WindowPartially supportedThe Facade API supports reference and dependency tracing and formula parsing. No ready-made step-by-step evaluation panel or Watch Window.SupportedPartially supportedSupports reference highlighting and F9 result previews, but not Excel's full dependency tracing, step-by-step evaluation panel, or Watch Window.
Calculate and refresh links to external Excel workbooksPartially supportedCan read results when the file contains sufficient cached external reference values. Cannot automatically load or refresh external Excel workbooks.SupportedPartially supportedIMPORTRANGE can read authorized Sheets ranges, but cannot directly evaluate Excel external workbook links.
User-defined functions (UDFs)SupportedSupportedSupported
PivotTables 6 features
PivotTable fields: rows, columns, filters, and summariesSupportedSupportedSupported
PivotTable date grouping, sorting, and Show DetailsSupportedSupportedSupported
PivotTable Show Values As: percentages, running totals, and rankingsSupportedSupportedPartially supportedIncludes percentages of the grand total, row, or column. Does not include all of Excel's running total, difference, and ranking combinations.
Slicers for interactive PivotTable and chart filteringSupportedv1.3.0+ · ProSupportedSupported
PivotTable TimelineSupportedv1.3.0+ · ProSupportedNot supportedSupports standard slicers and date filters, but not Excel-style pivot table timelines.
PivotTable calculated fields and calculated itemsNot supportedCalculated fields and calculated items are not supported.SupportedPartially supportedSupports calculated fields. Rules and formulas for Excel-style calculated items do not fully correspond.
Charts 6 features
Editable column, line, pie, and other chartsSupportedSupportedSupported
PivotCharts with field management inside the chartSupportedSupportedPartially supportedCan chart pivot table results and filter them with slicers, but has no separate PivotChart field management interface.
Chart sheets: a dedicated tab for a chartNot supportedNo dedicated chart sheets. Charts appear as embedded objects on regular worksheets.SupportedSupported
Statistical charts: histograms and box and whisker chartsSupportedSupportedSupported
Sparklines: Line, Column, and Win/LossSupportedSupportedSupported
Trendlines, error bars, and secondary axesPartially supportedSupports trendlines and secondary axes, but not error bars.SupportedSupported
What-If Analysis and Goal Seek 2 features
Built-in single-variable Goal SeekNot supportedNo built-in single-variable Goal Seek.SupportedNot supportedNo built-in Goal Seek; requires a separate Goal Seek add-on.
One- and two-variable data tables and Scenario ManagerNot supportedNo built-in one- or two-variable data tables or Scenario Manager.SupportedNot supportedNo built-in data tables or Scenario Manager. Requires add-ons, custom formulas, or scripts.
Collaboration and history 6 features
Real-time co-authoring and selection syncSupportedSupportedSupported
Comments, replies, and resolved discussionsSupportedOpen sourceSupportedSupported
Notes: static cell annotationsSupportedOpen sourceSupportedSupported
Version History: view and restore versionsSupportedSupportedSupported
Edit offline and sync after reconnectingSupportedSupportedSupported
Show Changes: cell editors and previous valuesSupportedSupportedSupported
Permissions and file security 4 features
Protect Workbook: restrict sheet creation, deletion, moves, and renamingSupportedSupportedNot supportedSupports file sharing permissions and sheet/range editing protection, but not Excel's separate workbook structure lock.
Protect Sheet: restrict worksheet editingSupportedOpen sourceSupportedSupported
Cell and range protection: restrict editing of specific contentSupportedOpen sourceSupportedSupported
File encryption, password-protected opening, and encrypted savingNot supportedCannot decrypt, open with a password, or save encrypted Office files.SupportedNot supportedCannot decrypt, open with a password, or save encrypted Office files. Sharing permissions and sheet protection can control access and editing.
File import and export 8 features
XLSX import and exportSupportedSupportedSupported
Import legacy XLS workbooksSupportedSupportedSupported
Export legacy XLS through the standard export menuNot supportedExports XLSX, CSV, and TSV, but not legacy XLS.SupportedNot supportedExports XLSX, but not legacy XLS.
Import and export CSV / TSV cell valuesSupportedSupportedSupported
Preserve VBA code and projects on import and exportNot supportedDoes not preserve VBA code or projects on import and export, or automatically convert VBA to JavaScript.SupportedNot supportedDoes not preserve original VBA code or projects during conversion and export. Apps Script does not round-trip as VBA in Excel files.
Read and write XLSB binary workbooksNot supportedXLSB import and export are not supported.SupportedNot supportedNo XLSB import or export. Convert to XLSX or another supported format first.
OpenDocument ODS import and exportNot supportedOpenDocument ODS import and export are not supported.SupportedSupported
PDF output, including Print to PDFSupportedSupportedSupported
Macros and scripting 3 features
Run existing VBA macros and VBA UDFsNot supportedDoes not run VBA macros or VBA UDFs directly. Automation can be rebuilt with JavaScript/TypeScript and the Facade API.SupportedNot supportedDoes not run existing VBA directly. The logic must be rewritten in Apps Script.
Macro Recorder: record repeated actions as reusable scripts or macrosNot supportedNo Macro Recorder or script/macro playback.SupportedSupported
Script and macro automationSupportedJavaScript(JS)SupportedVBASupportedApps Script
Comparison scope and notes

Compares Excel for Microsoft 365 on Windows with Google Sheets on the web. Univer includes the full Office SDK and optional modules. The comparison covers each product's built-in features, excluding AI, external data and business data sources, separate products, and add-ons. JavaScript, VBA, and Apps Script can all automate tasks; Univer and Google Sheets do not preserve VBA code or projects on import and export. Plan, platform, and integration requirements are noted where relevant.

The open-source edition includes only the frontend editors, not server components. Its formula engine has lower performance than the commercial edition.

Information updated in October 2026. The comparison covers built-in features, excluding separate external products and add-ons. Univer includes the full Office SDK and optional modules; some features require server components.

Supported means the listed task can be completed. Partially supported means limitations apply; see the cell notes. Not supported means the compared version does not offer the feature.

AI functions, assistants, and generative features are excluded. Import/export support does not guarantee identical content, fonts, or calculation results. Test complex files with your own samples.

Official documentationUniver Sheets documentationMicrosoft Excel documentationGoogle Sheets documentation

Univer compared with other spreadsheet SDKs

How Univer differs from SpreadJS, Handsontable, ONLYOFFICE, and Syncfusion: what each is best for, which editors it includes, and how it is licensed.

Univer is an Office SDK. One SDK puts spreadsheets, documents, and slides in your web app, and gives your existing AI agents the tools to create, edit, and check those files. Its core, including Sheets and Docs editing, is open source under Apache-2.0. The other SDKs here each have a different focus: SpreadJS on Excel-like spreadsheets, Handsontable on data grids that feel like a spreadsheet, ONLYOFFICE on a complete office suite that runs on its own document server, and Syncfusion on a spreadsheet editor within a larger UI component suite.

Compares SpreadJS by MESCIUS, Handsontable DataGrid, ONLYOFFICE Docs, and the Syncfusion JavaScript Spreadsheet Editor, using each vendor's own product and licensing pages. Information checked in November 2026. Univer includes the full Office SDK and optional modules, with its open-source scope noted. Licenses and editions change; check each vendor's current terms before you choose.

SDKBest forEditors includedLicenseOpen source
UniverProducts that need spreadsheets, documents, and slides from one SDK, with agents that edit and check the filesSheets, Docs, Slides, Canvases, Relational Tables, PDF EditorApache-2.0 core. Commercial modules under a Business or Enterprise license; Freemium for evaluationYes: the core, including Sheets and Docs editing. Other editors and modules are commercial
SpreadJS (MESCIUS)Excel-like spreadsheet apps, such as financial, budgeting, and reporting tools, for users who expect Excel featuresSpreadsheet. Designer Ribbon, PivotTable, Collaboration Server, and other add-ons are licensed separatelyCommercial: a license for each developer, plus a deployment license for each production hostname (annual; perpetual on request)No
HandsontableEditable data grids with a spreadsheet look and feel in React, Angular, and Vue appsData grid. Formulas come from HyperFormula, a separate engineCommercial for commercial use; a free license for non-commercial use and evaluation. HyperFormula is licensed separately or in a bundleNo. The source code is public on GitHub
ONLYOFFICE DocsA complete office suite inside your app, served from a document server and embedded through its APIs or WOPIDocuments, spreadsheets, presentations, forms, PDFDocs Community under AGPL-3.0; Docs Developer under a commercial license, with white-labelingYes: Docs Community (AGPL-3.0)
Syncfusion JavaScript Spreadsheet EditorExcel-like viewing and editing in apps that already use Syncfusion's UI componentsSpreadsheet. DOCX Editor and PDF Viewer are separate Syncfusion SDKsCommercial, with a free Community License for small companies and individuals who meet Syncfusion's eligibility rulesNo

Univer or SpreadJS

Choose SpreadJS when your product is a spreadsheet first and your users expect Excel features, such as the PivotTable and Designer Ribbon add-ons. Choose Univer when the same product also needs documents and slides, with live, editable sheets inside them; when you want an open-source core to build on; or when the agents you already run should edit the files and hand each change to a person to review.

Univer or Handsontable

Handsontable is a data grid that looks and feels like a spreadsheet, with wrappers for React, Angular, and Vue, and formulas through its HyperFormula engine. Univer is a workbook editor. Multiple worksheets, formulas, conditional formatting, data validation, sorting and filtering, comments, and sheet protection are all part of its Apache-2.0 Sheets editing, and it runs in React 18 and 19. If you want an open-source alternative to Handsontable in a React app and your users work in whole workbooks, start with Univer. If they only edit a table of records, a data grid is the better fit.

Univer or ONLYOFFICE

ONLYOFFICE Docs is a complete office suite, with documents, spreadsheets, presentations, forms, and PDF. It runs on a document server, self-hosted or in ONLYOFFICE's cloud, and embeds in your app through its JavaScript API or WOPI. Docs Community is AGPL-3.0; Docs Developer is commercial and can be white-labeled. ONLYOFFICE also offers AI agents that work with the model you choose. Choose ONLYOFFICE when you want ready-made office editors with their own interface. Choose Univer when the editors should be part of your own front end: you compose Univer's plugins into your app and call its Facade APIs from your code and your agents, on an Apache-2.0 core.

Univer or Syncfusion

Syncfusion's JavaScript Spreadsheet Editor opens, edits, calculates, and exports Excel files. It is part of Syncfusion's Essential Studio, alongside its UI Component Suite, DOCX Editor, and PDF Viewer, and Syncfusion also offers AI tools for spreadsheet workflows. It is commercial; small companies and individuals who meet Syncfusion's eligibility rules can use it free under the Community License. Choose Syncfusion when your app already uses its components. Choose Univer when you want spreadsheets, documents, and slides on shared content models from one SDK, with an open-source core.

Coming from Luckysheet

Luckysheet is no longer maintained. Its README recommends Univer, the upgraded version, for production.

Migrate from Luckysheet to Univer

Questions about choosing an SDK

Which open-source alternative to SpreadJS can import and export Excel files?

Univer's core is open source under Apache-2.0. Univer imports XLS, XLSX, CSV, and TSV, and exports XLSX, CSV, and TSV. Import and export run on Univer's Server SDK, a commercial module: try it with Freemium, which has watermarks and limits, and use a Business or Enterprise license in production. ONLYOFFICE Docs Community, under AGPL-3.0, also works with XLSX, DOCX, and PPTX files on its own document server.

What is the best JavaScript spreadsheet SDK to embed in a web app?

It depends on what else your product needs. For a spreadsheet on its own, SpreadJS and Syncfusion are commercial Excel-like editors, and Handsontable is a spreadsheet-style data grid. If the product also needs documents and slides, an open-source core, or AI agents that edit and check the files, Univer covers these in one SDK.

Which parts of Univer are open source?

The core is Apache-2.0: the content models, plugin and command systems, formula and rendering engines, Facade APIs, UI foundation, and Sheets and Docs editing. Slides, canvases, Office file import and export, real-time collaboration, charts, pivot tables, and the AI SDK are commercial. Turn on the "Open source only" filter in the tables above to check each feature.

Can AI agents edit spreadsheets and documents with Univer?

Yes. Univer CLI, open source under Apache-2.0, gives your existing agent an Agent Skill to create, edit, and check sheets, docs, and slides. Each task runs in an isolated worktree draft; the agent then returns a link where a person reviews the result and merges, revises, or discards it. The Univer Pro SDK packages that Univer CLI bundles keep their own license terms.

Build the Office features you need into your product. Choose the modules that fit.