[rolling_roland]

I was struggling with spreadsheet performance some time ago, trying to open csv with over million of rows, which made my excel cough. To help with this I built collection of tools for myself (https://blocksheet.io) so I could at least split my csv files to smaller ones and then edit with excel.

>In a similar vein, sorting causes problems on very small datasets (less than 10K rows):

Reading this made me wonder just how much excel prioritizes formulas and other fancy features over basic utilities such as sorting. For comparison, I just tried sorting csv with over 2 million rows on blocksheet and even though it took few seconds and made my laptop fan do extra jumps (it's a static site), it still managed to do it in reasonable time.

For me it's such a rare problem to run into huge spreadsheets, that it's a bit overkill to build my own software for it. So if anyone knows any good ones that deal well with rearranging large spreadsheets, I'd be happy to hear about them.