Ask HN: What's the best way to expose random CSV/.xlsx files for future queries

5 pointsmtr1y ago5 comments

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 comments

oulipo1y ago

perhaps using datasette? https://datasette.io/

solardev1y 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_1y ago

What are you planning to query them with? What makes the native CSV/XLSX files not viable?

mtrOP1y 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.

mkranjec1y ago

You can query CSV with DuckDB

j / k navigate · click thread line to collapse