Excel Is a Bane of Humankind

Excel is used by thousands, if not millions, of people every day and in all industries. It is a useful tool for what it is. The problem as I write this, I suppose, is not so much Excel itself but rather how it is used. Users expect it to be dependable. As they should. It's developed by one of the biggest companies in the world. But it should be used for what it is intended to be, a spreadsheet. What is Excel not?

A DATABASE!!!

Just to be clear. I understand it's not feasible for most companies to write a program for every nuanced situation. But when you have an enormous, and I mean ENORMOUS, spreadsheet that does calculations, uses macros made by the last person who had the job, and is needed for an absolutely integral cog in the function of your business, Excel is not what you need. You need a specialized program to handle that amount of data reliably. I've seen so many times where a macro gets corrupted, a file is corrupted, 32-bit version of office can't handle the processes needing done, etc. (Why programs still use 32-bit architecture is beyond me, but I guess companies have a financial limit on what they can realistically keep up to date.)

I've made a few simple web applications that handle a decent amount of data. I've used SQLite and PostgreSQL depending on the situation and they both work better than an Excel spreadsheet. I can customize it the way I need it and it is reliable. Of course, a database can be corrupted. But that's why you use a backup. (And I don't mean a person that doesn't know how to code making an Access program that runs like garbage.)

Again, while I realize that a niche application is not practical in every situation. For reliable data integrity and something that anyone can sit down and use, it is going to be best to have an application that stores data in a real database rather than an Excel spreadsheet. This may be just a rant posting, but it gives me impetus to keep coding. The fact that there is bad or misused software out there than can be improved upon. I will do what I can to make the world a better place by helping to rid the world (or at least myself) of the snare that is an Excel "database"

25 Words or Less: If you care about your data, do not use Excel to store it. Use a real database!