Excel is made for calculations. But if you make it hard to make a DB, people will abuse Excel as a DB.
replyI mean, it might have been at first, but Microsoft figured out that the majority of users for lists without formulas in 1993 and they've strategized around that. IMHO, the biggest concession to this was when they added Power Query to core Excel in 2016.
replyExcel has sheets for tables, columns and rows, primary keys (UNIQUE), foreign key references etc if you squint.
replyIt doesn't require you use all of that properly, but it's there.
or reimplement excel with sqlite as a backend :-D
replyBTW sqlite can run SQL queries on CSV files with relatively simple one-liner command...
and excel has gui for forms
replyOnly where VBA is available. Not available for MacOs versions if I'm correct?
replyVBA is just there for backward compatibility.
replyThe modern alternative is to use JavaScript/TypeScript, which makes such solutions cross platform (including MacOs, web etc.):
https://learn.microsoft.com/en-us/office/dev/add-ins/overvie...