# Sheets feature comparison

> Compare Sheets features, support, and compatibility with Microsoft Excel, Google Sheets.

- Human documentation: [https://docs.univer.ai/overview/features/sheets](https://docs.univer.ai/overview/features/sheets)

- Agent Markdown: [https://docs.univer.ai/overview/features/sheets.md](https://docs.univer.ai/overview/features/sheets.md)

- Requested language: `en-US`

- Content language: `en-US`

- Documentation version: `1.3.0`

- Source: [features/sheets.mdx](https://github.com/dream-num/documentation/blob/dev/content/docs/features/sheets.mdx)

---

**14 categories, 83 features**; Univer supports 64, partially supports 3, and does not support 16.

[Integration guide](https://docs.univer.ai/guides/sheets.md) · [All features](https://docs.univer.ai/overview/features.md)

> [!NOTE: Comparison scope]
> Compares Microsoft 365 Excel for Windows desktop with web-based Google Sheets. Univer includes the complete Office SDK and optional modules. Only non-AI capabilities of each product itself are included; external/business data sources, separate external products, and add-ons are excluded. JavaScript, VBA, and Apps Script provide automation, but Univer and Google Sheets do not import/export VBA code and projects. Plan, platform, and integration requirements are stated per feature.

“Open source” marks full support in the open-source edition. Unmarked items may include basic subsets, optional modules, or commercial licensing; consult the corresponding module documentation.

## Worksheets, rows, and columns

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Multiple worksheets, duplication, and ordering | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Insert, delete, and move rows and columns | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Row heights, column widths, and autofit | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Merge and unmerge cells | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Freeze and hide rows and columns | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Row and column grouping and outlines | ✓ Supported | ✓ Supported | ✓ Supported |

## Editing and cell formatting

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Copy, paste, and paste special | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Autofill number, date, and formula series | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Find, replace, and locate cells by content | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Fonts, colors, and in-cell rich text | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Alignment, wrapping, fills, and borders | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Number, currency, date, and custom formats | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Rotated and vertical text | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Floating and in-cell images | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Shapes, text boxes, arrows, and connectors | ✓ Supported | ✓ Supported | ✓ Supported Create and edit in the built-in Sheets drawing editor, then insert as a drawing object. |

## Conditional formatting

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Conditional formats based on values, text, or formulas | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Color scales, data bars, and icon sets | ✓ Supported **Open source** | ✓ Supported | ◐ Partial Single-color rules and color scales are supported; no native Excel-style data bars or icon-set rules. |
| Conditional-format priority and Stop If True | ✓ Supported | ✓ Supported | ◐ Partial Applies the first matching rule in list order; does not expose every Excel Stop If True option. |

## Sorting and filtering

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Single-column and multi-column sorting | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| AutoFilter by values and conditions | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Filter by font or cell fill color | ✓ Supported **Open source** Filters matching rows by fill or font color. Filtering changes row visibility without changing row order. | ✓ Supported | ✓ Supported |
| Independent filter views | — Not supported Standard AutoFilter is available; independent views that leave other collaborators' sorting and filtering unchanged are not supported. | ✓ Supported Sheet Views require supported storage such as OneDrive or SharePoint. | ✓ Supported |
| Sort by font or cell fill color | — Not supported Built-in color sorting is unavailable. Filtering by these colors is supported. | ✓ Supported | ✓ Supported |

## Validation and data cleanup

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Dropdowns, custom formulas, and input validation | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Checkboxes and custom checked values | ✓ Supported **Open source** | ◐ Partial Native cell checkboxes use TRUE/FALSE. Custom checked values need formulas or other controls. | ✓ Supported |
| Remove duplicate rows | — Not supported No built-in Remove Duplicates operation. | ✓ Supported | ✓ Supported |
| Split text into columns by delimiter | — Not supported No built-in Text to Columns operation. | ✓ Supported | ✓ Supported |
| Trim excess whitespace | ✓ Supported TRIM removes leading, trailing, and repeated spaces. Some Unicode whitespace requires additional handling. | ✓ Supported TRIM formulas remove leading, trailing, and repeated spaces. | ✓ Supported Use Trim whitespace or TRIM; the whitespace characters handled differ by method. |

## Tables and structured references

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Table headers, styles, and filters | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Structured references by table, column, and current row | ✓ Supported **Open source** | ✓ Supported | ◐ Partial Table and column references are supported, but not #This Row. Chart, pivot, and conditional-format ranges have reference limitations. |

## Formulas, functions, and calculation

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Aggregation with SUM, AVERAGE, and COUNT | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Conditions, text, and dates with IF, TEXT, and DATE | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Lookups with VLOOKUP, INDEX, MATCH, and XLOOKUP | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Array calculations with FILTER, SORT, and UNIQUE | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| SQL-like QUERY filtering, sorting, and aggregation | — Not supported The QUERY function and SQL-like query strings are not supported. | — Not supported No native QUERY string function. Combine FILTER, SORT, GROUPBY, and other formulas for some queries and aggregations. | ✓ Supported QUERY uses Google Visualization Query Language, including SELECT, WHERE, GROUP BY, PIVOT, and ORDER BY. It is a SQL-like subset, not a standalone SQL() function. |
| LET, LAMBDA, MAP, REDUCE, and SCAN | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Defined names and cross-worksheet references | ✓ Supported | ✓ Supported | ✓ Supported |
| Dynamic-array spilling and obstruction checks | ✓ Supported **Open source** Array results spill automatically with #SPILL! obstruction checks. Validate complex array formulas against representative files. | ✓ Supported | ✓ Supported Array functions and ARRAYFORMULA expand into adjacent cells; syntax and errors differ from Excel. |
| Excel A1# spill-range operator | ✓ Supported | ✓ Supported | ◐ Partial ARRAYFORMULA expands array results; Excel A1# spill-range references are unsupported. |
| SEQUENCE and RANDARRAY | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Legacy Ctrl+Shift+Enter array formulas | ✓ Supported | ✓ Supported | ◐ Partial Ctrl+Shift+Enter adds ARRAYFORMULA. Fixed-range calculation and export differ from Excel CSE formulas. |
| Financial functions including PMT, NPV, and IRR | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Engineering units and complex numbers | ✓ Supported **Open source** Engineering functions, unit conversion, and complex-number calculations are supported. | ✓ Supported | ✓ Supported |
| Create, reuse, and import named functions | ✓ Supported | ✓ Supported Save LAMBDA in Name Manager. Migration between workbooks differs from Google. | ✓ Supported |
| Iterative calculation and convergence for circular references | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Dependency tracing, formula evaluation, and watch windows | ◐ Partial Facade APIs provide reference/dependency tracing and expression parsing. No ready-made step-by-step evaluation panel or Watch Window. | ✓ Supported | ◐ Partial Reference highlighting and F9 result previews are available; no complete Excel-style dependency tracing, step-by-step evaluation panel, or watch window. |
| Calculate and refresh external Excel workbook links | ◐ Partial Saved external-reference cache values can supply results. External Excel workbooks are not automatically loaded or refreshed. | ✓ Supported | ◐ Partial IMPORTRANGE reads authorized Sheets ranges; it cannot execute Excel external-workbook links directly. |
| Custom formula functions (UDFs) | ✓ Supported Register functions through JavaScript/TypeScript and formula extension APIs. VBA, COM, and XLL functions are not compatible. | ✓ Supported Define functions with VBA UDFs or LAMBDA. | ✓ Supported Apps Script registers custom functions; not every interactive service is callable. |

## Pivot tables

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Pivot row/column fields, filters, and aggregation | ✓ Supported | ✓ Supported | ✓ Supported |
| Pivot date grouping, sorting, and drill-down | ✓ Supported | ✓ Supported | ✓ Supported |
| Pivot percentages, running totals, and rankings | ✓ Supported | ✓ Supported | ◐ Partial Totals and row/column percentages are supported; not every Excel running-total, difference, or ranking combination is available. |
| Slicers for pivot tables and charts | ✓ Supported | ✓ Supported | ✓ Supported |
| Pivot date timeline controls | ✓ Supported | ✓ Supported | — Not supported Standard slicers and date-condition filters are supported; no Excel-style pivot timeline control. |
| Pivot calculated fields and calculated items | — Not supported Calculated fields and calculated items are not supported. | ✓ Supported | ◐ Partial Calculated fields are supported; calculated-item rules and formulas do not fully match Excel. |

## Charts

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Editable column, line, pie, and other charts | ✓ Supported | ✓ Supported | ✓ Supported |
| PivotCharts with pivot-field management | ✓ Supported PivotCharts share the pivot-table model, including field configuration and linked filtering. | ✓ Supported | ◐ Partial Plot pivot results as regular charts and filter with slicers; no separate PivotChart field-management UI. |
| Dedicated chart worksheets | — Not supported Charts are embedded objects on ordinary worksheets; dedicated chart-sheet tabs are not supported. | ✓ Supported Move charts to dedicated chart sheets. | ✓ Supported Dedicated chart sheets are supported, separately from charts embedded in a cell grid. |
| Histograms and box plots | ✓ Supported | ✓ Supported | ✓ Supported |
| Line, column, and win/loss sparklines | ✓ Supported | ✓ Supported | ✓ Supported Create with the SPARKLINE function. |
| Trendlines, error bars, and secondary axes | ◐ Partial Trendlines and secondary axes are supported; error bars are not. | ✓ Supported | ✓ Supported |

## What-if analysis and goal seeking

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Built-in single-variable Goal Seek | — Not supported No built-in single-variable Goal Seek. | ✓ Supported | — Not supported No built-in goal seeking; install the separate Goal Seek add-on. |
| One/two-variable data tables and Scenario Manager | — Not supported No built-in one/two-variable what-if data tables or Scenario Manager. | ✓ Supported | — Not supported No built-in what-if data tables or scenario manager. Use add-ons, formulas, or scripts. |

## Collaboration and history

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Co-editing and shared selections | ✓ Supported Requires Univer collaboration services and application identity and permissions. | ✓ Supported Requires a supported version, Microsoft 365 sign-in, and supported storage such as OneDrive or SharePoint Online. | ✓ Supported |
| Comments, replies, and resolved discussions | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| Cell notes and static annotations | ✓ Supported **Open source** | ✓ Supported | ✓ Supported |
| View and restore historical versions | ✓ Supported Requires the Server SDK history module. Collaboration history from the original platform is not recovered from XLSX. | ✓ Supported Version history depends on storage services such as OneDrive or SharePoint. | ✓ Supported |
| Offline editing and reconnection sync | ✓ Supported Requires preloaded documents, enabled offline caching, and collaboration services. Changes synchronize after reconnection. | ✓ Supported Local or cached files can be edited offline; shared files synchronize when reconnected. | ✓ Supported Enable offline access in advance and meet browser and account requirements. |
| Cell edit authors and historical values | ✓ Supported Requires history and collaboration modules. Traceability depends on the recorded operation types. | ✓ Supported Uses Show Changes, subject to supported operations and storage requirements. | ✓ Supported Cell edit history and full-file version history cover different operations. |

## Permissions and file security

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Protect workbook structure | ✓ Supported Permissions restrict adding, deleting, moving, renaming, and hiding worksheets. Validate Excel password-protection compatibility separately. | ✓ Supported | — Not supported File sharing and sheet/range editing protection are available; no separate Excel-style workbook-structure lock. |
| Protect worksheet editing | ✓ Supported **Open source** Permissions restrict worksheet editing operations. Validate Excel password-protection compatibility separately. | ✓ Supported | ✓ Supported Restrict sheet editing by user and define exception ranges; requires native Google Sheets format. |
| Protect cells and ranges | ✓ Supported **Open source** Range permissions restrict edits to selected cells or ranges. Validate Excel password-protection compatibility separately. | ✓ Supported Lock cells and enable worksheet protection, leaving permitted input regions editable. | ✓ Supported Assign editable users through protected ranges; requires native Google Sheets format. |
| File encryption, password opening, and encrypted saving | — Not supported Office file password decryption, password opening, and encrypted saving are not supported. | ✓ Supported | — Not supported No Office password decryption, password-based opening, or encrypted saving. Sharing permissions and sheet protection control access and editing. |

## File import and export

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| XLSX import and export | ✓ Supported Requires file conversion. Complex charts, external links, and special objects have format-specific compatibility limits. | ✓ Supported | ✓ Supported XLSX conversion and export are supported; not every Excel feature can be edited or executed in Sheets. |
| Import legacy XLS workbooks | ✓ Supported | ✓ Supported | ✓ Supported |
| Export legacy XLS through the standard exporter | — Not supported XLSX, CSV, and TSV export are supported; legacy XLS export is not. | ✓ Supported | — Not supported XLSX export is supported; legacy XLS export is not. |
| CSV and TSV value import and export | ✓ Supported CSV/TSV retain text and values, not multiple worksheets, styles, charts, or formula-calculation behavior. | ✓ Supported Text formats retain the active sheet and relevant values, not full workbook functionality. | ✓ Supported CSV/TSV export operates on one sheet and does not retain full workbook functionality. |
| VBA macro/project import and export compatibility | — Not supported VBA code and projects are not imported/exported compatibly or automatically converted to JavaScript. | ✓ Supported Macro-enabled formats such as XLSM preserve VBA code and projects; XLSX does not. | — Not supported Conversion/export do not preserve original VBA code and projects. Apps Script does not round-trip as VBA in Excel files. |
| XLSB binary workbook read/write | — Not supported XLSB import and export are not supported. | ✓ Supported | — Not supported No XLSB import/export; convert to a supported format such as XLSX first. |
| OpenDocument ODS import and export | — Not supported ODS import and export are not supported. | ✓ Supported | ✓ Supported |
| PDF output, including print to PDF | ✓ Supported Requires the print module and the browser's Save as PDF function. No standalone server-side PDF conversion API. | ✓ Supported | ✓ Supported |

## Macros and scripting

| Feature and scope | Univer Sheets Complete Office SDK · optional modules | Microsoft Excel Microsoft 365 · Windows desktop | Google Sheets Web |
| --- | --- | --- | --- |
| Run existing VBA macros and VBA UDFs | — Not supported VBA macros and UDFs are not executed directly. Reimplement automation with JavaScript/TypeScript and Facade APIs. | ✓ Supported Desktop Excel includes VBA macros and VBA UDFs, subject to macro security policies. | — Not supported Original VBA does not run directly; rewrite the logic in Apps Script. |
| Record operations as reusable scripts or macros | — Not supported Operation recording and script/macro replay are not provided. | ✓ Supported | ✓ Supported |
| Script and macro automation | ✓ Supported JavaScript/TypeScript and Facade APIs can read, write, calculate, and format content. VBA logic can be rewritten but original VBA is not executed. | ✓ Supported Automate with desktop Excel's built-in VBA macros, subject to macro security policies. | ✓ Supported Write Apps Script or generate scripts with the Sheets macro recorder. Original VBA must be rewritten. |

Official documentation: [Univer Sheets](https://docs.univer.ai/guides/sheets.md) · [Microsoft Excel](https://support.microsoft.com/en-us/excel) · [Google Sheets](https://support.google.com/docs/answer/9331278?hl=en)