Running SQL in an Excel Worksheet

Online course: Excel 365 for Busy People

Corporate training for Excel and other Microsoft and Adobe applications:

Between the Sheets, Episode 71: Running SQL in an Excel Worksheet
It’s now possible to run Structured Query Language (SQL) directly in an Excel worksheet. It requires a free add-in that installs with just one click. In this video, we create a few Select queries, create an alias, use Where, Sortby and Or operators and see a couple of other cool features.

SQLite:

SQLookup Website:

[jasongins]

I've long hoped for SQL in Excel. I installed this the other day and agree dealing with the quotes is maddening. I think it would be tough to write anything complex without the help of the auto complete and function highlighting that an actual SQL editor provides, but for something simple you can get the results right on your worksheet without having to deal with exporting and importing CSVs from an SQL editor. Pretty cool, thanks for the video on how to use it. Subscribed.

[felixzumstein]

Great video, thanks Bob! (I created that thing ;)

[成佛提桶]

👍👍 Very well said, hope with subtitles, I am from China，

[gurhangundogan]

Thank you very much, for now it seems that Power Query cannot use queries as data.

[pitsanupruethtithirathamro]

Hi Bob, Are there function about insert into, update, delete for sqlookup?

[sallyho]

Hi Bob - how is using sql in excel different from using pivot table?
Also, I pull data reports monthly from out RHR application. I have to pull by each level of care for death for senior living industry from the EHR application. Are there better ways to pull the data reports monthly?

[txreal]

For testing, would SQLookup be significantly faster than regular Excel with 1 million rows in a table similar to above?
Thanks.

[mattmatt]

Can you just copy and paste complex SQL created by ChatGbt ? Will it work ?

[ravikashchand]

Wouldn’t FILTERBY and PIVOTBY be easier solutions to running data filters for tables already in Excel?

[benshi]

how to union two tables with same table headings?

[andybecker]

I think duckdb does it better than this option