Google Spreadsheet What is the maximum number of rows? Verification of the maximum number of rows

Table of Contents

Maximum number of rows in a Google Spreadsheet workbook
cell count limit
Maximum number of lines
How many lines can we go?
If the number of cells is increased too much
summary

Maximum number of rows in a Google Spreadsheet workbook

How far can the maximum number of rows in a Google Spreadsheet workbook go? I have verified the following.

So, let’s try to add 1,000,000 rows as a trial.

Yes, … suddenly we have the answer: it seems to be that 5000000 cells is the upper limit!

*Addition: The cell count limit has now been expanded from 5 million to 10 million! The maximum number of cells seems to have been increased from 5 million to 10 million.

cell count limit

Apparently, there is a “limit of 50000000 cells in a workbook”.

I thought, “Well, it’s 1,000,000 lines, so it should work, right? But here is the point.

If you look closely, the key point is that the “cell count limit is 5,000,000”, not the number of rows.

So, if you have column B~, you cannot try to add row 4,999,999.

Maximum number of lines

So, it seems that “row x column = 5,000,000 is the maximum” for the maximum number of rows in a spreadsheet.

Finding the square root of 5,000,000, we obtain
= SQRT(5000000)
= 2236.067977

That is, for the same number of matrices
2,236 rows x 2,236 columns (= 4,999,696) is the maximum, and
This means that for the same number of matrices

At 2,236 rows by 2,237 columns, we get.
= 5,001,932, which is
This is over the limit.

Since we have columns from the beginning up to “Z” (column 26), we can use the following formula to calculate the number of rows.
If we keep the initial number of columns and add the number of rows, we get
? ×x 26 = 5,000,000.
The answer to “?” is the upper limit of the number of rows. is the upper limit of the number of rows.

5,000,000 ÷ 26 ＝ 192,307.…

If the number of cells is 27, the number of cells is 5,192,289, which exceeds the upper limit.

I was able to add up to “line 192,307” as expected!

When I try to add row 192,308, I get a warning that “The number of cells in the workbook exceeds the 5000000 limit.” and a warning appears. The result I expected.

How many lines can we go?

As a test, how many rows can we go if we use only column A?

Cells seem to be able to go up to “exactly” 5,000,000 numbers.

However, if you increase the number of cells on sheet 1 to 5,000,000
You will not be able to add a new sheet.

Since the new sheet has row 1,000 and column Z(26)
When you create a new sheet
You need to leave at least 26,000 cells (1,000 x 26)
cells (1,000 × 26) or more must be left empty in advance.