When downloading open data files from government sites there can be millions of rows. It would be nice if excel worked with 50M rows to do quick filters and pi

When downloading open data files from government sites there can be millions of rows. It would be nice if excel worked with 50M rows to do quick filters and pivots and stuff. But of course there are other tools for that. Comically, I’m not sure how splitting a 50M line csv into 50 files helps as you can’t filter or pivot across 50 files unless you want to do lots of manual stuff.