Max number of Rows in Numbers

Numbers won't do it, Excel will but I would expect it not to run well.

Realistically this would be better done with a database rather than a spreadsheet. (Libre Office Base)

Excel maximum: 1,048,576 rows by 16,384 columns, Libre Office has the same maximums as Excel.

Hi Divakar,

Someone will come along and give you a definitive answer but in the meantime you should know that even if Numbers can allow that many rows it will likely not work well.

quinn

Hi Divakar,

Just looking through the Numbers Function Browser, and randomly clicking on functions, I found this under the ADDRESS function. It could be that 65,535 rows or 255 columns (not both at once!) is the maximum that Numbers can handle.

The ADDRESS function constructs a cell address string from separate row, column, and table identifiers.

ADDRESS(row, column, addr-type, addr-style, table)

• row: A number value representing the row number of the address. row must be in the range 1 to 65,535.
• column: A number value representing the column number of the address. column must be in the range 1 to 255.

As quinn says, wait for a definitive answer. Numbers is not Excel and will bog down with large tables. I suspect that a document with 500,000 rows is better suited to another app.

Regards,

Ian.