6
tombjarne
39d

What's up with Excel not being able to fucking handle bigger CSV files? Shouldn't that be kind of the main feature?

Comments
  • 4
    What's up with Excel not being able (still, in 2020) to open two files with the same filename (eg. from different folders)!
  • 2
    @Bandic00t well you tell me... even numbers from Apple can do that stuff. Why can't Microsoft finally implement something useful
  • 6
    If a CSV file is that big, a spreadsheet is likely the wrong solution anyway.
  • 0
    @tombjarne It's not like the CSV handling isn't without its idiosyncrasies, either. (Sorry for the triple??? negative)
  • 0
    @Fast-Nop Not my idea though ^^ I wish they would have chosen something else, but csv it is...
  • 3
    @tombjarne Abusing Excel as database and complaining it doesn't work too well is really common.
  • 0
    @Bandic00t what's a triple negative?
  • 0
    @tombjarne My clumsy sentence: "it's not like" +"isn't" + "without".
    Not the easiest to parse.
  • 2
    @Bandic00t I'd have guessed "no HIV, gonorrhoea, or syphilis".
  • 1
    @Fast-Nop That's a triple threat
  • 1
    What's up with excel formatting data on its own and fucking me over because it thinks it's smarter then me.

    Respect my data bitch!
  • 2
    Stop pretending excel is a database! Process the data with a real data prep tool!
  • 0
    The problem is not Excel, it's you. There are many things a hammer cannot fix.
  • 0
    @donuts I love how those wannabe-deep-psychologists on devRant always tell me I am the problem. Tell me doc, when does your schedule allow the next appointment? Maybe we can then talk about when and where I can best hang myself.
  • 0
    @python3 Dude it was not my god damn idea! What the fuck should one do if there’s data that’s only available as a fucking csv file?!
  • 0
    @tombjarne use literally any computer language... like python has pandas or numba, r has dplyr, data.table or ff , heck even js has some nice processing libraries. The libraries in these languages are much more efficient at doing data prep, all of them have really simple interfaces to do everything you can do in excel. From pivot tables to modelling to plotting.

    You can also use tableu prep, or even powerbi for more GUI like tools (there’s also lots of other more free tools if you google them).
Add Comment