4 ms·
I don't know when it became "easy" to handle a million rows in excel, but I do know that some time ago that was intractable. As late as a few months ago, I reca
by crispyambulance 10y ago
I don't know when it became "easy" to handle a million rows in excel, but I do know that some time ago that was intractable. As late as a few months ago, I recall trying to work with ~6 million rows in excel and it flaked out miserably.
For quick, ad-hoc tasks on huge files I recommend R/RStudio.
I also use Notepad++, of all things, for cleaning-up csv data because its "operating envelope" in terms of file-size and sheer number of files is unlike anything else. The regexp search/replace combined with zoomed-out views allow for easy clean-up of text data.
- NetStrikeForce 10y agoNo joking, I find Sublime Text brilliant to work with humongous CSV files :-)
- winteriscoming 10y agoWhich version? The latest 3.x version, that I use, almost stalls trying to load a file of relatively small size of 20 odd MBs.
- NetStrikeForce 10y agoWith 2.x I've opened and edited with multiple cursors (my favourite feature) files around a GB in size. On Windows, if that makes a difference.
- hermitdev 10y agoExcel 2007. Prior it was impossible due to file format limits. Row limit was 64k, i think. Not sure what the Col limit was. Not sure what or if there limits are since the move to the xlsx format. Despite doing Excel addin development in finance, i never hit a limit in post 2007 excel.