3 ms·
I’d love a SQLite to macOS Excel (or any macOS spreadsheet application) workflow so less technical users can do analysis. Has anybody pulled this off?
by bradgessler 7y ago
I’d love a SQLite to macOS Excel (or any macOS spreadsheet application) workflow so less technical users can do analysis. Has anybody pulled this off?
- drongoking 7y agoYou mean like the .excel command? "... causes them to accumulate output as Comma-Separated-Values (CSV) in a temporary file, then invoke the default system utility for viewing CSV files (usually a spreadsheet program) on the result. This is a quick way of sending the result of a query to a spreadsheet for easy viewing"
- iagovar 7y agoYou can do that with powerquery
- simonb 7y agoOr load it in Metabase (as an macOS app).