Ask HN: What's the best way to expose random CSV/.xlsx files for future queries
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.
And look up (local) municipal OpenData for an address and grab the lot size, zoning, etc.
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".
I'm very comfortable in Excel (Pivot Tables, but don't speak SQL. Reasonably comfortable with PowerBI. But that's about it. perhaps using datasette? https://datasette.io/ Gsheets? You can easily get it out as a JSON https://www.freecodecamp.org/news/cjn-google-sheets-as-json-... You can also script it to do integrated geo lookups with Apps Script What are you planning to query them with? What makes the native CSV/XLSX files not viable? Nothing in particular. Just nice to have structured data that I can start mashing together to show in a presentable format. Spreadsheets don't handle images and you can't run a report. You can query CSV with DuckDB