Files and compatibility

8sheets works with the Office Open XML spreadsheet format defined by ECMA-376, the format Excel has used since 2007. Behaviour is checked against that standard, Microsoft's published documentation and files saved by the desktop version of Excel.

Formats

FormatOpenSave
Excel workbook .xlsxYesYes
Excel macro-enabled workbook .xlsmYesYes, VBA kept and not run
Excel template .xltxYesYes
Password-protected workbook (password to open)YesYes
CSV, TSV and text .csv .tsv .txtYes. Data > Get Data > From Text/CSV adds delimiter and column type choicesActive sheet as CSV
PDFNoYes, through Print

The older binary format .xls and the OpenDocument format .ods are not supported.

What survives a save

A workbook can contain things 8sheets shows but doesn't edit, and things it doesn't use at all. Saving never throws them away:

  • VBA projects in .xlsm files are saved unchanged. They are never run; automation in 8sheets uses JavaScript scripts.
  • Power Query definitions, custom XML parts, embedded OLE objects, ActiveX controls and parts of unknown types are copied unchanged, together with their relationships.
  • 3D models, audio and video are shown as the fallback picture the file stores, can be moved and resized, and are kept.
  • SmartArt is drawn, its text can be edited, and it is saved. New SmartArt graphics can't be created.
  • Data types (stocks, geography, currencies) show their stored values and cards, and work in formulas such as =A2.Price. They do not refresh from the web.
  • Python in Excel cells show the last result Excel saved and are kept. They are not run.
  • Legacy shared workbook revision logs are kept unchanged.

Features that Excel has no place for in its file format, such as some cell types and view settings, are stored in the file's own custom XML parts, which Excel ignores and keeps.

Large files

Files are never loaded into memory in one piece. A background thread reads the ZIP package entry by entry and parses the XML as a stream, sending cells to the page in batches, so the page stays responsive while a file opens. Saving works the same way in reverse, with compression running as a stream.

Cells are kept in compact typed arrays rather than one object per cell, and shared strings stay encoded until they are displayed. A workbook of 1,000,000 rows by 20 columns is part of the regular performance tests.

How large a file you can open depends on the memory of your device and the browser's limits.

Limits

8sheets follows Excel's sheet size: 1,048,576 rows by 16,384 columns.