What's the best way to expose random CSV/.xlsx files that I can query in the future? We're house hunting and it would be nice have a local db to keep track of price changes, asking prices, photos, etc.<p>And look up (local) municipal OpenData for an address and grab the lot size, zoning, etc.<p>I'm using Airtable and sometimes Excel, but it would be nice to have a home (hobby) setup for storing queryable data. Could be cloud hosted but "affordable".<p>I'm very comfortable in Excel (Pivot Tables, but don't speak SQL. Reasonably comfortable with PowerBI. But that's about it.
Gsheets? You can easily get it out as a JSON <a href="https://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpoint/" rel="nofollow">https://www.freecodecamp.org/news/cjn-google-sheets-as-json-...</a><p>You can also script it to do integrated geo lookups with Apps Script