Which is Microsoft Excel.

For those who know the limitations of Excel as a DBMS: Please don’t hit me, I can explain….

There are four types of people, divided by their usage type of Excel.
– Who use Excel for table formatting or data visualizing.
– Who automate some complex logical calculations on Excel.
– Who code in some serious Programs to Excel, via its Macro(VBA) or Add-in(Office JS API) or Scripts(TypeScript) functionalities.
– And the majority of people, who maintain some data on it but don’t know how to leverage the true powers of what they’re using, the Excel.

I found out that, in much of enterprises, Excel is only a data storage. Which is clearly not what all it can do, and if you’re in such an enterprise, there must be a proper reason why they cannot use Excel as a DBMS. (Proper reasons do exist, but I bet, there isn’t.)

Here are some examples of what you can do with Excel.

In my project Haezimvo DBM: You input some raw data into a sheet. Then the Excel Add-in I made comes in. It automatically organizes your raw data, stores them on the other sheet safely. The add-in is also perfectly capable of searching, fixing, modding the stored data. I also wrote a simple Python script, which will convert the data sheet into a JSON file so that the data can be read by a website. (In my case I made the website too: project Haezimvo.com.) Tada, not only a tailored DBMS has been made, but also a whole Web platform has been made around a single Excel workbook.

Are you convinced yet.

So, if your enterprise (or you) already have Excel, you don’t need to pay for other DBMS…

except. What are the limitations of Excel as a DBMS? What are the proper reasons not to use Excel?

1. If the database is huge enough, Excel simply won’t work.
   – In the past, one Excel sheet could have no more than 65,500 rows. For the current version of Excel the limit is around 1,024,500. This means if one of your databases have more than a million entries, Excel won’t do.
2. If the database must be read/written anytime in real-time and instant, Excel may be inefficient.
   – Excel is an humanly program. It is perfectly capable of dealing with humanly amount of input/outputs, It may be inefficient to deal with all the inhumanly many requests in an instant, because it lacks a proper fail-safe system for that purpose.
3. You have to buy an Excel or Microsoft 365.