OT: Spreadsheet software for very large files

Posted by dan7000
Oct 1, 2014 at 11:08 PM

Have been looking for this for a few days and just realized maybe the CRIMP community would have some ideas.

I’ve been working with some large spreadsheets lately (100,000 rows, 50 or so columns). The main thing I need to do with them is just sort and filter on different columns. But in Excel, every time I sort or filter on a new column it takes 5 minutes and up. I’ve tried Excel 2010 and 2013, same thing. This seems like something that modern software should do better, but I can’f seem to find any alternatives. I tried uploading to Google Sheets but despite the claims on the Sheets website (claiming to have no size limit), it fails with an error that the file is too large. I tried uploading in sections but you cannot copy and paste the sections together because it hangs attempting to copy/paste large numbers of rows. I guess I could type it all into a new Google Sheet one row at a time if I wanted to kill a week or so.

Any suggestions for online or windows-based software that can work with this size of spreadsheet without hanging?