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.

  • 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 filteringSupportedSupportedSupported
PivotTable TimelineSupportedSupportedNot 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

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