Giant spreadsheet or database in Debian?

everest · 08-03-2004, 04:18 AM

I have a file 10 Mb in size - it's a .csv file - it has about ten columns and about 65,000 rows of figures! I have Debian Woody R2 installed with a few basic programs. Does anyone know if there is a program in the first three CDs of the Woody set that I can open that file with and work on it?

Wandering_Dru · 08-03-2004, 11:33 AM

As long as your file isn't more than 65535 rows, gnumeric will handle it without a problem. I started to suggest oocalc as well but it tops out at 32000 rows.

I just attempted to load a 153,000 record csv with gnumeric and except for truncating everything about 65535, it worked fine.

If you need more than that, I would look to mysql/postgresql (and their respective phpmyadmins). Both of those have a much higher learning curve tho.

everest · 08-03-2004, 03:49 PM

Thanks Wandering_Dru - that's just the information I was looking for. I'll load gnumeric and use that - the file will just fit. My old Windows 95 Excel spreadsheet cuts off at a bit over 16,000 rows.