this post was submitted on 03 Jun 2026
964 points (99.7% liked)
People Twitter
10414 readers
403 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 international politcs
- Be excellent to each other.
- Provide an archived link to the tweet (or similar) being shown if it's a major celebrity, figure or any politician. See stickied post https://web.archive.org/save is an option. Archive.is is no longer recommended because they remove/alter content.
- If a tweet (or similar) makes a statement of fact, either mark it as "satire" in the body or provide the original source link backing up the statement (see rule 6)
founded 3 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.