Ask Your Question

Import small csv file to calc results in huge ods file [closed]

asked 2013-10-04 20:52:46 +0100

mspohr gravatar image

updated 2015-11-10 16:28:06 +0100

Alex Kemp gravatar image

I have a small csv file of transactions downloaded from my bank. It is 71 lines total size 7K. When I import into Calc and save as an .ods file, it ends up as 6.3 Meg in size and brings the computer to it's knees when saving (or trying to do just about anything with it.)... It takes about 3 minutes to open the file I'm using LO version When I save it as an xls file, it ends up 2.8 MB in size and opens and closes without delay and I can manipulate it without delay. What is going on here?

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-11-10 16:28:37.374573

1 Answer

Sort by » oldest newest most voted

answered 2013-10-04 22:30:09 +0100

m.a.riosv gravatar image

And the import result is fine? With Ctrl+End is the selected cell at bottom-right of data?

edit flag offensive delete link more


Ah Ha!... very astute of you (and clueless of me). There were 55 rows of data and then about 30 blank rows. After that, there were 1,104,000 rows where the last two columns of data from the first 55 rows were repeated... Not sure how that happened but don't think it was something that I did (even in my cluelessness). (When saved as an xls format there were only 64,000 extra rows so it was faster.) Thanks... cleaned up now.

mspohr gravatar imagemspohr ( 2013-10-04 23:16:34 +0100 )edit

Question Tools

1 follower


Asked: 2013-10-04 20:52:46 +0100

Seen: 147 times

Last updated: Oct 04 '13