you are viewing a single comment's thread
view the rest of the comments
[–] 15 points 1 year ago (5 children)

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.

  • source
  • hideshow 5 child comments
  • [–] 9 points 1 year ago (3 children)

    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.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 2 points 1 year ago (2 children)

    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.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 3 points 1 year ago (1 child)

    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

  • source
  • parent
  • hideshow 1 child comment
  • [–] 1 point 1 year ago

    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.

  • source
  • parent