Some problems with Excel when people have tried to achieve the "excel as a backend": - Excel was not designed to act as a (headless) backend - you should not do it because it will crash - million rows limitation - understanding what a Excel tool does is almost impossible to explain to other people, which makes sharing and maintaining the tool almost impossible
Using other types of spreadsheets like Google's is quite complex due to traditional way of representing data as cells and having the 2D format that is very functional for visual inspection but somewhat challenging when you interact through API: hopefully you take my word for it because I have done it.
I know many people have implemented many tools using Excel - with or without VBA. So my question is which kind of tools or services you would create with Excel if you could turn the an Excel sheet into a backend?
Such things should not exist and be nuked from orbit.
Excel should not be used to create anything but spreadsheets and charts.
Excel is not the "best" tool for most of what it is made to do
But it is the available tool for the majority of people out there - it is plenty good enough to get most of what most people want to get done with it done ... so they use it
I remember in the late 90s using Excel (5.0, at the time) for a variety of statistical operations
...all of which I was informed by the in-house SPSS expert were "not possible to do" in Excel
Is importing your data into Tableau, or a database and using PowerBI, or into a time-series analysis tool like Splunk or ELK "better"? In the strict sense of the word ... probably
But the point remains: Excel is good enough to get it done