3 ms·
Hi all! So as a side project I developed a plugin that lets you do SQL inside Excel. It's called ThingieQuery (www.thingiequery.com). When you install Thingie
by anakic 12y ago
Hi all!
So as a side project I developed a plugin that lets you do SQL inside Excel. It's called ThingieQuery (www.thingiequery.com).
When you install ThingieQuery, you get a SQL IDE window inside Excel. It uses an embedded SQLite engine to process the queries and uses the data from excel tables. Basically you get full SQL support inside Excel.
In case you want to query your excel tables together with the tables on an external db server you can do that as well. In this case the data from Excel tables will be copied in the form of temp tables to the external server. If you wish, you can write the results of your queries back to Excel.
It has syntax highlighting, code completion (currently rudimentary tho), and can do some neat tricks.
I've also made two tutorials so far:
https://www.youtube.com/watch?v=Ld-mbyAGsow https://www.youtube.com/watch?v=Ld-mbyAGsow
https://www.youtube.com/watch?v=1vjlEd2-bJQ https://www.youtube.com/watch?v=1vjlEd2-bJQ
I could be happier with the tutorials, but they do illustrate the point of the plugin.
I created the licensing infrastructure and the website, and am trying to launch it as a product so I'd really appreciate feedback.
If you do a lot of data manipulation in Excel and you're good with SQL do give it a try.
Thanks! Antonio