this post was submitted on 13 Sep 2023
1508 points (98.9% liked)
Memes
45550 readers
992 users here now
Rules:
- Be civil and nice.
- Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
i...isn't that the entire point of excel? what is it for if not to store data?
similarly i remember a reddit comment that broke my brain, saying no one should be using excel, they should be using a 'cell matrix organizer' or similar. we all can name 5 off the top of our heads
Excel has a purpose, but storing data long term isn't it. It's for calculating data. It shouldn't be the single source of truth.
One of the things Microsoft did to make it work was extending the row limit from 65k to 1M. Apparently, Economics professors were very excited about that one, which explains a lot.
Excel is this weird mix of storing small amounts of data but so good for visualizing data. If people are saying it shouldn't be used to store data they mean massive amounts of data as opposed to something like some small scale accounting for a fund raiser.
Storing data is only one of the parts to the formula of what makes a database. Proper databases require structured storage of the data and some way to query the data constructively. Excel did not have those features until Microsoft gave up trying to convince people to not use it as a DB and added it to Excel.