I am currently writing a lowcode platform that allows defining backend as Excel functions. The format is not visually organized as spreadsheets or cells but differently. The platform also allows connecting different data sources and targets to it. Finally, you can connect to the backend itself using a REST API!<p>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<p>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.<p>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?
I recently sat in on a demo of a complete accounting and invoicing system implemented entirely in excel.<p>Such things should not exist and be nuked from orbit.<p>Excel should not be used to create anything but spreadsheets and charts.
So ... Excel instead of AirTable?<p>Excel is <i>not</i> the "best" tool for most of what it is made to do<p>But it is the <i>available</i> 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<p>I remember in the late 90s using Excel (5.0, at the time) for a variety of statistical operations<p>...all of which I was informed by the in-house SPSS expert were "not possible to do" in Excel<p>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 <i>strict</i> sense of the word ... probably<p>But the point remains: Excel is good enough to get it done