Live data from Hacker News

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

superintendent.app

11–20 of 34 posts

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

#11
post #10
post #7

Earlier quoted context omitted.

iPad

It seems iphone and ipad can't play mp4 for some reason. I may need to change it to gif instead.

My “Why?” isn’t about the video not playing, it’s about using a video as almost the sole way to figure out what the product does.

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

#13
post #11
post #10

Earlier quoted context omitted.

It seems iphone and ipad can't play mp4 for some reason. I may need to change it to gif instead.

My “Why?” isn’t about the video not playing, it’s about using a video as almost the sole way to figure out what the product does.

Great point. I suppose I could show some screenshots as well.

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

#16
I got smacked with this just last week.

My answer was just import into MS Access.

Note: if you're pulling in a lot of S3 list_objects_v2() data, and have some honking big object sizes, the Long Integer type craps out at representing a 2Gb file. You need to use Double.

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

#17
post #6
post #3

Why is this a yearly cost? I don’t understand. There’s already open source utilities [0] for users who aren’t proficient in Unix commands. If anything this should be the definition of a one time fee. You’re free to charge whatever you like, but it seems odd that anyone would pay you year after year to use your app. It’s not the price, as $40 isn’t that much, but the value and principle of the thing. [0] https://githu…

The target users are non-technical users. Think accountants. They are technical and not be able to use command line tools. Other than that, I appreciate the feedback.

No post body was provided.

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

#18

It's interesting how people use and abuse Excel. How many people try to use Excel to process millions of rows? Time to use tools that can directly query csv files to aggregate the data.

I happen to build that kind of tool as well: https://superintendent.app

Anyway, if you don't know SQL, you are kinda out of luck and stuck with Excel.

Post reply on HN