Show HN: An app to split CSV into multiple files to avoid Excel's 1M row limit

Re:Show HN: An app to split CSV into multiple files to avoid... by NibLer on Tuesday October 18, 2022 @03:02AM (#33243927)

Do people really have CSV files with more than 1M rows? How do you search and update such files? Why not use some database?

[ Parent | on HN ]

Re:Show HN: An app to split CSV into multiple files to avoid... by popcalc on Tuesday October 18, 2022 @06:04AM (#33245049)

The only use case I can see is script kiddies toying with credential stuffing using Open Bullet 2 and well-known compromised accounts.

[ Parent | on HN ]

Re:Show HN: An app to split CSV into multiple files to avoid... by prepend on Tuesday October 18, 2022 @09:16AM (#33246640)

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.

[ Parent | on HN ]