I am building/editing a table and utilising Excel as the vehicle. When I change the spreadsheet I need to produce a new csv file and then re-import to generate new layers. Handling Excel spreadsheet in QGIS? gives me some options.
But would it be easier to use a database for the process? I can update/edit the database which could then automatically update the layers? (Postgis, Spatiallite, GeoPackage?) If so, which database should I be moving to? There will be a steep learning curve for all of them.