this post was submitted on 03 Jun 2026
950 points (99.7% liked)
People Twitter
10037 readers
417 users here now
People tweeting stuff. We allow tweets from anyone.
RULES:
- Mark NSFW content.
- No doxxing people.
- Must be a pic of the tweet or similar. No direct links to the tweet.
- No bullying or international politcs
- Be excellent to each other.
- Provide an archived link to the tweet (or similar) being shown if it's a major figure or a politician. Archive.is the best way.
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
How big were the CSVs? That sounds like a standard thing most spreadsheet apps can do already, unless the data size made traditional apps unusable.
The biggest ones I've seen are 1.2GB.
Why this company uses gigabyte CSVs is a separate problem.
(Also sometimes they want to compare a CSV to what's in a database, which the script can also do but I didn't mention in the post)
That makes sense. I have been asked to write a program that does a standard spreadsheet function on multiple occasions, so I was just curious. Sometimes people just don't know the tools at hand, want to offload their work, or think an over complicated workflow is a better workflow. I can see how it was actually useful in your case though.
I have an easier time doing that shit in powershell than I do in Excel which are the only tools I have available at work. I'm probably doing something wrong but I don't do it often enough to remember what that is. My PS script just works.