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.

5 points | by mtr 30 days ago

4 comments

  • oulipo 29 days ago
    perhaps using datasette? https://datasette.io/
  • solardev 29 days ago
    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

  • akerl_ 30 days ago
    What are you planning to query them with? What makes the native CSV/XLSX files not viable?
    [-]
    • mtr 30 days ago
      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.
  • mkranjec 26 days ago
    You can query CSV with DuckDB