Question 1

What is the limit for rows per worksheet in a spreadsheet?

Accepted Answer

1,048,576 (excel grid (2^20) — caps.ts EXCEL_MAX_ROWS). a reference beyond the grid is rejected rather than silently extending the sheet.

Question 2

What is the limit for columns per worksheet in a spreadsheet?

Accepted Answer

16,384 (excel grid (column XFD) — caps.ts EXCEL_MAX_COLS).

Question 3

What is the limit for operations per write request in a spreadsheet?

Accepted Answer

10,000 (caps.ts OPS_MAX_BATCH). split larger edits across requests; each request is still one atomic commit unit.

Question 4

What is the limit for write request body in a spreadsheet?

Accepted Answer

5 MB (caps.ts OPS_MAX_BYTES).

Question 5

What is the limit for xlsx upload in a spreadsheet?

Accepted Answer

15 MB (journal-import.ts IMPORT_MAX_BYTES).

Question 6

What is the limit for cells per viewport read in a spreadsheet?

Accepted Answer

10,000 (slice.ts SLICE_MAX_CELLS). read a window at a time; the diff endpoint is the cheaper way to track changes.

Question 7

What is the limit for values per page in a spreadsheet?

Accepted Answer

50,000 (slice.ts VALUES_PAGE_MAX).

limit	value	where it comes from
rows per worksheeta reference beyond the grid is rejected rather than silently extending the sheet.	1,048,576	excel grid (2^20) — caps.ts EXCEL_MAX_ROWS
columns per worksheet	16,384	excel grid (column XFD) — caps.ts EXCEL_MAX_COLS
operations per write requestsplit larger edits across requests; each request is still one atomic commit unit.	10,000	caps.ts OPS_MAX_BATCH
write request body	5 MB	caps.ts OPS_MAX_BYTES
xlsx upload	15 MB	journal-import.ts IMPORT_MAX_BYTES
cells per viewport readread a window at a time; the diff endpoint is the cheaper way to track changes.	10,000	slice.ts SLICE_MAX_CELLS
values per page	50,000	slice.ts VALUES_PAGE_MAX