this post was submitted on 02 Oct 2025
405 points (98.6% liked)
Technology
76484 readers
3261 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
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
Excel is such an incredible piece of shit. There's many reasons to hate it for me, but what i hate the most is not being able to do relationships in any meaningful way. So often i need to have one to many relationships and this garbage makes it impossible. Data consistency? Nope. Opening a csv? Fuck you! Why the fuck are there online tools that are better at this shit? You had 40 years ffs. No amount of AI is going to fix this turd. God I hate Excel.
There's a ton of reasons to hate Excel, I'm sure, but I don't think lack of support for relational data is a reasonable one. There's tools for that job, but Excel isn't trying to be one of them.
Just because it doesn't offer features a database has doesn't mean people aren't trying to use it as one
I support your argument, but unfortunately there are some real monstrosities out there that have carried small businesses since decades
Yeah, not denying that people use Excel to do all kinds of crazy shit. People using the tool wrong isn't the tool's fault though, right?
Wrong! If I am using a hammer to deliver babies I expect hammer manufacturers to put a rubber coating on the claw so it doesn't scratch the baby as I pry it out.
Reminded me of these two projects by some Dylan Tallchief on YouTube:
He first made a programmable drum machine, then a DAW in Excel.
I get that. But it's a case that's just so incredibly common. Tagging/categorization. We end up with multiple columns like 'cat 1', 'cat 2', etc. Or doing pivot tables. I guess to me there's pretty much always something that can do the job better, but the reality is that in the corporate setting I operate in everybody uses Excel.
You are trying to use Excel like a database and that’s not its job. Use Access for that, if you must stick within the Office ecosystem
If I'm the only one doing it then I'd prefer to stick with sqlite. But the reality is that everyone I work with does these kinds of things in excel, and it's a shitshow. Yes, u could say 'don't blame the tool', but it's ms shoving it down our throats and they could've done much better with the time they had.
With power query, Excel can perform more database-like functions, I use it all the time! It comes with it's own quirks however