HACKER Q&A
📣 mtr

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.


  👤 oulipo Accepted Answer ✓
perhaps using datasette? https://datasette.io/

👤 solardev
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_
What are you planning to query them with? What makes the native CSV/XLSX files not viable?

👤 mkranjec
You can query CSV with DuckDB