Hacker News new | ask | show | jobs
by krylon 4153 days ago
I once had to open a CSV file with about 2,000 columns. Excel failed me, OpenOffice/LibreOffice failed me, only Gnumeric managed to open the file.

I'll admit that I only deal with that many columns on very rare occasions, but it does come in handy sometimes.

1 comments

In theory Excel can open files with 16,384 columns so it's surprising it failed.

https://support.office.com/en-nz/article/Excel-specification...

I might misremember the number of columns (could have been 20,000 - also, it had many rows), or maybe the 16,384 column limit applies to xls(x) files only, not to importing CSV files.

I remember at first cursing at Excel, then realizing what a ridiculously large number of columns the file had.