+ Reply to Thread
Results 1 to 10 of 10

I've created an Excel plugin for using SQL inside Excel

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    Zagerb, Croatia
    MS-Off Ver
    2013
    Posts
    5

    I've created an Excel plugin for using SQL inside Excel

    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 it, 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 which I won't go into here.

    I've also made two tutorials so far:
    https://www.youtube.com/watch?v=Ld-mbyAGsow
    https://www.youtube.com/watch?v=1vjlEd2-bJQ

    I created the licensing infrastructure and the website, and am trying to launch it as a product and I'd really appreciate any feedback.

    If you do a lot of data manipulation in Excel and you're good with SQL do give it a try.

    Thanks! Antonio

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: I've created an Excel plugin for using SQL inside Excel

    Hi Antonio,
    You probably posted it on the wrong section of the forum. This section is purely for answering questions, but not commenting on a topic.
    I applaud you for your skills and time.
    Where does your add-ins sit-in with in powerpivot and ADO?
    Last edited by AB33; 04-15-2015 at 09:49 AM.

  3. #3
    Registered User
    Join Date
    04-08-2015
    Location
    Zagerb, Croatia
    MS-Off Ver
    2013
    Posts
    5

    Re: I've created an Excel plugin for using SQL inside Excel

    Ah, ok, sorry about that. Can you point me in the right direction where it might be appropriate to post this?

    Regarding how this fits in with PowerPivot and ADO, those are good questions In comparison with:
    1) PowerPivot
    There is some overlap but not that much. In principle PowerPivot is a BI tool and ThingieQuery is a SQL IDE.
    Strong points of PowerPivot being user friendly BI operations (drilldown, slice&dice).
    Strong points of SQL being unparalleled expressiveness when querying and manipulating tabular relational data, and scriptability (easy to repeat and share a set of operations).

    2) ADO
    Ado focuses on sheets, while ThingieQuery focuses on tables. The benefit of focusing on tables is you can have as many as you want in a single sheet surrounded by text and images- no cleaning up neccessary.
    ThingieQuery also provides some standard features you would expect from a SQL IDE: syntax highlighting, code completion, partial query execution to name a few.

    With ThingieQuery you can also use an external DB engine to process the data.
    In this case, this is like importing the excel tables into a target database, processing it there and then bringing any results you want back into the workbook.
    While this can be done with tools like SSIS, ThingieQuery makes the process quite a bit more convenient.

    Obviously ThingieQuery won't save the world, but it does provide a lot of convenience,
    and if it saves people a few hours of tedious work each year, than I think it justifies it's price and my efforts in building it
    Last edited by anakic; 04-08-2015 at 04:52 PM.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: I've created an Excel plugin for using SQL inside Excel

    You can post it on this section or ask the mods to transfer it.
    http://www.excelforum.com/the-water-cooler/

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: I've created an Excel plugin for using SQL inside Excel

    I think this is great, I've watched your videos and I'm going to download the trial

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,204

    Re: I've created an Excel plugin for using SQL inside Excel

    This looks really impressive but I'm no expert on SQL. But, if Kyle says it's "great", that's good enough for me.

    Watched the videos. Very interesting but the background music is dreadful!


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  7. #7
    Registered User
    Join Date
    04-08-2015
    Location
    Zagerb, Croatia
    MS-Off Ver
    2013
    Posts
    5

    Re: I've created an Excel plugin for using SQL inside Excel

    Hey, that's great to hear! I hope you find it useful, and please feel free to let me know what you think.

  8. #8
    Registered User
    Join Date
    04-08-2015
    Location
    Zagerb, Croatia
    MS-Off Ver
    2013
    Posts
    5

    Re: I've created an Excel plugin for using SQL inside Excel

    Well, you don't have to be an expert, even with basic SQL knowledge, you can do lots of stuff you couldn't do (easily) with Excel alone (joins, more powerfull filtering/grouping/sorting, selective updating and deleting and a lot more). Not to mention the fact that SQL is scriptable so you can repeat operations easily, and share them with others.

    And what do you mean the music sucks?! I really liked the first one Well, TBH you're probably right, it sounded better than my voice alone, so I left it in.

  9. #9
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: I've created an Excel plugin for using SQL inside Excel

    Congrats on getting this on the front page of HN mate along with the great reception, noticed a while ago, nice work how you getting along with it?

  10. #10
    Registered User
    Join Date
    04-08-2015
    Location
    Zagerb, Croatia
    MS-Off Ver
    2013
    Posts
    5

    Re: I've created an Excel plugin for using SQL inside Excel

    Hi Kyle, thanks, I was quite happy about that! I originally posted on reddit a few days ago, and then someone from there posted in on HN, I owe the man a beer Both threads were very popular, and my website viewership jumped from 100/day to 10k/day! Just for a day or two, but still, an amazing few days. Anyway, I'm having fun with it, sold several licenses and am getting good feedback. My only problem is that marketing-wise I have no idea what I'm doing and I should probably hire someone who does How about you, find any cool open source stuff to work on lately?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. So I've created an Excel plugin for using SQL inside Excel
    By anakic in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-08-2015, 03:09 PM
  2. Visualization Plugin/Add-On Excel
    By markvee in forum Excel General
    Replies: 0
    Last Post: 01-15-2015, 10:43 AM
  3. [SOLVED] ActiveX Plugin needed in Excel 2000 missing from Excel 2003
    By cadcam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2006, 08:10 PM
  4. Excel plugin to make graphs look better
    By CM in forum Excel General
    Replies: 0
    Last Post: 10-17-2005, 07:05 PM
  5. [SOLVED] how can I get odbc plugin for Excel 2003 ?
    By Herve Brelay in forum Excel General
    Replies: 1
    Last Post: 01-29-2005, 09:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1