Formats

XLSX vs ODS vs CSV file size: measured on 54 real workbooks

The same workbook written as XLSX, ODS, CSV, XML and Numbers: median size ratios, extremes and the reasons behind each gap, measured on 54 real files.

Across 54 real workbooks, the same file came out about 23% smaller as ODS than as XLSX (median ratio 0.77) and about 74% smaller as CSV (0.26). Excel 2003 XML was 5.7 times the size of XLSX and Apple Numbers 6.7 times. CSV was the smallest of the five formats for every workbook, and XML was larger than XLSX for every one.

Format Median size Median vs XLSX Range vs XLSX Smaller than XLSX
XLSX 15.6 KB 1.00
ODS 12.2 KB 0.77 0.70 to 0.94 54 of 54
CSV (zipped) 3.9 KB 0.26 0.02 to 0.67 54 of 54
XML (Excel 2003) 88.3 KB 5.7 3.1 to 13.6 0 of 54
Numbers 101.3 KB 6.7 0.64 to 9.2 1 of 54

The workbooks are the 50 templates and 4 datasets Sheet Reserve launched with on 9 October 2026; sheets added later are not included. The sizes are those of the files Sheet Reserve writes. Files saved by Excel, LibreOffice or Numbers themselves will differ, so treat the ratios as a guide to how the formats behave, not as a promise about any other program.

How was the file size measured?

Every workbook is stored once as a compressed model of its cells, formulas, styles and column widths. Each one was written in all five formats by the site's own browser writers, run under Node, and the size in bytes of every result was recorded. For each workbook, each format's size was divided by its XLSX size, and the median of those 54 ratios is the figure in the table.

Two details affect how to read the numbers:

  • All 54 workbooks have at least two tabs, so the CSV output is a ZIP archive with one CSV file per tab. The CSV figures include that archive.
  • Repeating the run changes some files by a few bytes, because ZIP archives store timestamps. The figures are rounded to 0.1 KB and the ratios to two digits.

How much smaller is ODS than XLSX?

ODS was smaller for all 54 workbooks: 12.2 KB against 15.6 KB at the median. The saving ranged from 30% for the unit price bid schedule (ratio 0.70) to 6% for the loan amortization schedule (54.9 KB against 58.2 KB, ratio 0.94).

Both formats are ZIP packages of XML parts, so neither has a compression advantage on paper. The gap comes from how each writer lays out cells, formulas and styles inside the package. Another program's XLSX and ODS files can show a different gap.

Why is CSV so much smaller than XLSX?

A CSV file keeps values only: no formulas, styles or column widths. It was the smallest of the five formats for all 54 workbooks, at 3.9 KB against 15.6 KB at the median.

How much CSV removes depends on what the workbook is made of:

  • The debt payoff planner holds 27,146 cells, 26,873 of them formulas. As zipped CSV it is 7.6 KB against 308.3 KB as XLSX, a ratio of 0.02.
  • The GDP by country dataset is mostly data, so CSV keeps most of it: 217.6 KB against 324.7 KB, a ratio of 0.67.
  • Across the 50 templates the median CSV ratio is 0.26. Across the 4 datasets it is 0.43.

The more of a workbook is calculation and layout, the more CSV removes. The more it is plain rows of data, the less. What CSV loses is not just size: see XLSX versus CSV for the full list and how to convert XLSX to CSV without losing data for the checks before you export.

Why is an XML spreadsheet so much larger?

Excel 2003 XML, formally XML Spreadsheet 2003, is a single plain-text XML file, not a ZIP package. XLSX compresses its XML; this format does not. The median file was 88.3 KB against 15.6 KB, and the ratio ran from 3.1 to 13.6.

The extreme is the debt payoff planner again: 4,179.3 KB as XML, about 4.1 MB, against 308.3 KB as XLSX. The format is useful for scripts and older tools that read XML, and a poor choice when size matters. Compressing the XML would shrink it, but that was not measured here.

Why are Numbers files larger than XLSX?

The Numbers files Sheet Reserve writes hold cell values, tabs and merged cells, but formulas become their results and formatting is left out. They are still large: 101.3 KB at the median, 6.7 times the XLSX.

The smallest Numbers file in the set is 90.6 KB, written for a workbook whose XLSX is 9.9 KB and which has about 200 cells. That suggests a fixed overhead of roughly 90 KB in every .numbers package this writer produces, with content adding to it. The only workbook where Numbers came out smaller than XLSX is the debt payoff planner (196.7 KB against 308.3 KB), where almost every cell is a formula that XLSX stores as text and a values-only Numbers file does not. Apple's own app was not part of the test, and its files may be smaller. See what a .numbers file is.

Does file size matter at this scale?

Rarely. 52 of the 54 XLSX files are under 100 KB, and 36 are under 20 KB. The largest is the GDP dataset at 324.7 KB. None of the formats comes near an email attachment limit or a slow download at these sizes, so choose the format for what must survive, not for its size:

  • Choose XLSX or ODS when formulas and formatting must survive. See what an ODS file is.
  • Choose CSV when a program, not a person, reads the data.
  • Choose XML only for a tool that asks for it, and Numbers only for Apple's apps.

The comparison of the five formats goes through what each one keeps.

How big is a Sheet Reserve download?

The compressed model the browser receives is smaller than any of the files above. Across those 54 sheets the median is 8.5 KB, the 90th percentile 31.7 KB and the largest 264.1 KB. The format you pick is written on your own device from that copy.

Which workbooks are the largest?

Workbook XLSX ODS CSV XML Numbers
GDP by country 324.7 KB 270.7 KB 217.6 KB 2,133.5 KB 848.7 KB
Debt payoff planner 308.3 KB 269.5 KB 7.6 KB 4,179.3 KB 196.7 KB
Freshwater withdrawals by country 79.5 KB 65.0 KB 34.4 KB 710.4 KB 287.0 KB
Monthly weather for 60 world cities 71.6 KB 51.1 KB 28.5 KB 773.6 KB 652.6 KB
Loan amortization schedule 58.2 KB 54.9 KB 15.1 KB 557.1 KB 146.9 KB

Keep reading