ThingieQuery works with excel tables. To turn a block of cells into a table, select any cell in the block and click Insert->Table. Adjust the borders and headers if needed, and click OK. Voila!
Once the data you care about is in tables, you can connect to it by going to the ThingieQuery tab in the ribbon and clicking "Connect to workbook".
Now that you are connected you can start writing SQL queries against your excel tables. And I mean all kinds of SQL, including update/insert/delete statements.
There is no better way to see if it's the right tool for you than to download it and give it a try. There is a trial period lasting 30 days, so you can test it without any commitment, and if you like it please buy it, if not, fine... be that way