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

5 points by mtr 2 years ago | 5 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.

oulipo 2 years ago |

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

solardev 2 years 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_ 2 years ago |

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

mtr 2 years 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 2 years ago |

You can query CSV with DuckDB