Excel compatibility, explained.

Emberkit Sheets uses the open-source Univer spreadsheet and formula engine. Familiar Excel-style formulas and references are supported, but this is not Microsoft Excel and does not implement every Excel function or behavior.

Start with familiar formulas

Use arithmetic, A1 cell references, ranges and formulas such as SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, IFERROR, SUMIF, COUNTIF and VLOOKUP. Formula suggestions and descriptions appear in the editor. Function coverage and edge cases depend on the engine version. Unsupported expressions may display an error; do not assume an imported cached value has been recalculated correctly.

Import and export

XLSX import includes cell values, formulas, basic formatting, column widths and merged cells. XLSX export includes values, formulas, basic cell formatting, widths and merged cells. CSV contains values from one worksheet only. Emberkit JSON backups retain the native workbook snapshot and are the preferred format for preserving Emberkit-specific settings.

Not supported as a full round-trip

• VBA/macros, Office Scripts, Power Query and external workbook/data connections.
• Excel charts, pivot tables, drawings, embedded files, slicers and advanced print layouts.
• Password-protected or encrypted workbooks, legacy XLS files and every dynamic-array or financial edge case.
• Exact Excel formatting and full conditional-formatting/data-validation compatibility on XLSX export.

Before moving an important workbook

1. Keep the original file.
2. Import a copy and review warnings.
3. Compare formula results, dates, totals and representative records against the original.
4. Export and reopen a sample before relying on repeated exchange with Excel.
5. Report a reproducible issue through support. Share only data you are comfortable including in the support request.

Supported sizes

Up to 20 worksheets, 2,000 rows and 100 columns per worksheet, 50,000 populated cells and 200,000 grid cells per workbook. Cloud workbook size is capped at 2 MB. XLSX imports are limited to 5 MB and must fit the resulting workbook limits. Very complex formulas can be slower even within these limits.