I have been wanting a tool like this for a few years. I can see a bazillion uses for it. Home-run!
ThingieQuery: a SQL plugin for Excel
11–20 of 65 posts
Re: ThingieQuery: a SQL plugin for Excel
#12I think the approach of https://airtable.com/ is a better solution for these kind of problems, but not everybody is free to change tools.
A lot of data is already in spreadsheets. And using an existing spreadsheet in AirTable is not quick and easy because its only possible with csv import:
https://support.airtable.com/hc/en-us/articles/203423579-Imp...
Strange they do not offer a more direct import. It would help the transition.
Re: ThingieQuery: a SQL plugin for Excel
#13It looks great. Too bad it's Windows only.
The preview of excel 2016 for mac is pretty good and some of our marketing staff are contemplating the idea of migrating to mac.
Congrats on the launch, I'm not an excel user myself but I've sent the link to some of my coworkers and they look excited :D
Re: ThingieQuery: a SQL plugin for Excel
#14So how about a tool that would open an Excel spreadsheet as a sqlite database ? By on-the-fly converting the tabs into tables. Then open this database in your favorite sqlite browser.
Maybe even open several spreadsheet files at once, each file in a separate database.
Re: ThingieQuery: a SQL plugin for Excel
#15So how about a tool that would open an Excel spreadsheet as a sqlite database ? By on-the-fly converting the tabs into tables. Then open this database in your favorite sqlite browser. Maybe even open several spreadsheet files at once, each file in a separate database.
ODBC does this on windows. You can connect to a spreadsheet and issue queries.
Re: ThingieQuery: a SQL plugin for Excel
#16This could be awesome for teaching SQL
Re: ThingieQuery: a SQL plugin for Excel
#17So how about a tool that would open an Excel spreadsheet as a sqlite database ? By on-the-fly converting the tabs into tables. Then open this database in your favorite sqlite browser. Maybe even open several spreadsheet files at once, each file in a separate database.
Neat idea, you could get pretty close to that experience right now by running http://databaseimportscriptor.com, then Alt+Tab-ing into MySQL Workbench.
Problem is, I can't really see a market for it. You're trying to write SQL on your database, so you're a developer, and how much would you really be willing to pay to have the experience streamlined down to a couple of clicks?
Re: ThingieQuery: a SQL plugin for Excel
#18I'm banging my head against Excel, wishing for SQL right now! But I could never go to my boss and ask for a purchase order for something called ThingieQuery. Give it a more bland gray name and make a massively expensive corporate site license available, and I think you're onto a winner.
completely agree about the name - would love to use this at the office.
Re: ThingieQuery: a SQL plugin for Excel
#19Nice. Though, from a finance perspective, my daily nightmare is in the sharing piece - not in the analysis piece - of my job. Sharing numbers in spreadsheets and consolidations is a deep un-solved pain in the finance world. But I do see this solution as a potential fix for the many pivot functionalities shortfalls.
Re: ThingieQuery: a SQL plugin for Excel
#20I'm banging my head against Excel, wishing for SQL right now! But I could never go to my boss and ask for a purchase order for something called ThingieQuery. Give it a more bland gray name and make a massively expensive corporate site license available, and I think you're onto a winner.
Author here. I'm inclined to agree, the naming is poor, it didn't start out as a serious product, and I never changed the name. That said, you can at least use the trial licence (free for 30 days) and after that who knows, maybe I'll rename the plugin to Excel SQL Studio 3000 XT and add an Enterprise Ultimate Premier License for 1200$.
Personally I think the guy is a moron. If he wasn't banging his head so hard he might realize it's reasonably priced and he can save all the corporate hassle by purchasing it himself.