Upper limit to number of rows in Calc

When importing csv text files, is there a upper limit to number of rows a person can create/save in LibreOffice Calc?

Depends on the LO version you are using:

  • pre 3.3.3: limit is 65 536 rows
  • 3.3.3 and later: 1 048 576 rows (1M)

If this is not sufficient for you needs, you can use the Base module of LibreOffice to import csv-files with almost no row limit at all. With Base you can query and strip the data before you pass it to Calc for charts and such a like…

For a brief intro see here and/or open a new topic for further questions.


I figured the 65535 would apply but the expansion in newer versions is great


Could you please let me know where can I find the base module of Libre Office that has almost no row limit?