We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

upper limit to number of rows in Calc [closed]

asked 2012-12-05 00:29:40 +0200

Will the tinkerer gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 02:59:53.586606

1 Answer

Sort by » oldest newest most voted

answered 2012-12-05 01:48:13 +0200

famo gravatar image

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.


edit flag offensive delete link more


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

Will the tinkerer gravatar imageWill the tinkerer ( 2012-12-16 08:53:13 +0200 )edit


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

aelwan3 gravatar imageaelwan3 ( 2016-12-19 03:27:35 +0200 )edit

Question Tools


Asked: 2012-12-05 00:29:40 +0200

Seen: 26,905 times

Last updated: Dec 05 '12