Running SQL in an Excel Worksheet

[@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.

[@felixzumstein1302]

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

[@BobFlisser]

Glad you found it helpful!

[@silvio.ribeiro]

@@BobFlisser Great video. In case it's not clear, @felixzumstein1302 actually created SQLookup.

[@成佛提桶]

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

[@BobFlisser]

Thank you. I don't know if it's possible to create subtitles for every language.

[@成佛提桶]

@ only English

[@BobFlisser]

@@成佛提桶 That's a good point and something I should have been doing all along. So if you play this video now, you'll see it has closed captioning. And I'm going to try to provide captions to new videos I produce. And happy year of the snake.

[@gurhangundogan]

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

[@RicardoCamisa]

Thank you 🙏🏾

[@BobFlisser]

Glad you liked it!

[@sallyho146]

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?

[@BobFlisser]

I don't know those applications but if the reports you're pulling are in CSV or tab delimited, your best bet might be to use Power Query. That way, you can arrange columns and format them as you need before dumping it all into a worksheet.

[@javedahmed8343]

Is it supoorted in Excel 2016?

[@BobFlisser]

I don't think so. Only 365.

[@ravikashchand7941]

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

[@nudger1965]

up until the closing of the video, I was thinking the very same thing. I'm glad i'm not the only one thinking it seemed just as easy to use the filter function.

[@BobFlisser]

Filterby and Pivotby are great new functions. I think the purpose of Sqlookup is if you already have SQL statements and don't want to re-do them in regular Excel functions. There may also be users who are more comfortable in SQL than they are in Excel.

[@txreal2]

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

[@BobFlisser]

I doubt it. Excel's native functions will probably be faster since they don't have to be translated to SQL. I think this add-in is for convenience, not performance boost.

[@shanksingh7613]

wow just wow

[@benshi3529]

how to union two tables with same table headings?

[@BobFlisser]

I'm not a SQL expert, but if you have two tables with the same headers, you can use an inner join. Let's say your tables are called Customers and Orders and both have a field with the same data called Customer #. Try something like this: =SQLOOKUP("select [First Name] from Customers", "Customers", "select [order #] from Orders", "Orders", "inner join Customers on Customers[Order #] = Orders[Order #]") You might need to tweak the syntax.

[@mattmatt245]

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

[@BobFlisser]

I just tested it and Chat produced standard SQL. You'd need to tweak the syntax to include the correct brackets and quotation marks.

[@andybecker5001]

I think duckdb does it better than this option