Comment by pbhjpbhj

6 years ago

If you use LibreOffice then you can make a spreadsheet into a "database source" and query it with SQL. That seems like a good interim, you can move sheets and make them external tables as you grow in confidence/knowledge.

At least you could 10 years ago, very easily (it was OOo.org I was using then I think) - I made a simple customer record system just 4 or 5 tables but the address "table" was a kind-of view of the spreadsheet for email-merge.

Presumably Excel and others do this too.

I do use LibreOffice. There seems to be some way of using SQL to access Base data, but I still didn't explore that.