You Can Now Use SQL in Excel! (This Changes Everything)

[@CodingIsFun]

*Update:* Felix, the creator of SQLookup, has deployed a fix. The first example now works out of the box!

[@techgalaxy100]

Excellent info!!! Thanks so much.

[@CodingIsFun]

Glad it was helpful! Thanks for watching and taking the time to leave a comment! Cheers, Sven ✌️

[@pinkyshroff3436]

This is absolutely brilliant…I can now use my sql skills to get things done in excel…thx for sharing

[@CodingIsFun]

Glad it was helpful! Happy Excel-ing! -Sven ✌️

[@ricardo.alves.campos]

Awesome video as always. Thanks for showing us this add-in, it will be so useful !

[@CodingIsFun]

Thank you, Ricardo! Happy Excel-ing!

[@mikem7332]

Awesome, I used to turn to MS Access for some functionality but this changes everything.

[@CodingIsFun]

Thanks for watching! -Sven ✌️

[@TumishoMaoka]

Thanks for sharing, this is great tutorial 🎉🎉

[@CodingIsFun]

Thanks for watching! Glad you liked it! 🎉 Cheers, Sven

[@michaelkuhn6328]

Great video. This is game changing functionality!! Thanks for posting.

[@CodingIsFun]

You're very welcome! Thank you for watching and for the comment! -Sven

[@IvanCortinas_ES]

Great tutorial. Thank you for sharing it!!!

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment. -Sven ✌️

[@Hyposonic]

This has been possible for at least 10 years. Glad you're catching up.

[@CodingIsFun]

Yes, better late than never! 😊

[@cosmochaosmaker]

It was possible since VB Script exists. 🤦‍♂️

[@Hyposonic]

@@cosmochaosmaker Correct, but I was too lazy to go back and look it up. 😀

[@NB-lh9pj]

I just routed SQL through power query, then manipulate the data with dynamic array functions or Python.

[@torque6389]

Another great video!

[@CodingIsFun]

Thank you!

[@mazenalsakkaf]

Wow! SQL in Excel. The sky's the limit now.

[@CodingIsFun]

🚀

[@thebesttechnical3608]

The best excel tutorial. Straight to the point!

[@CodingIsFun]

Thank you!

[@kisho2679]

In which use cases is SQL needed in xls, instead of using its own data manipulation functionalities?

[@bc4198]

A lot of queries are easier to run in SQL than Excel, in that they are easier to write than the Excel syntax. For example, using SELECT and AND would be way easier than nested IF()s. I imagine it would also be better for dynamic data. Also, if you happen to know SQL already but not how to do certain things in Excel, then it would save you having to look that up. If you did it right and you also use SQL, the code could be interchangeable for you. Ultimately, a lot of our jobs would be better if we had full SQL, but our positions are just approved for Excel.

[@txreal2]

@CodingIsFun For testing, would SQLookup be significantly faster than regular Excel with 1 million rows of Orders table similar to above? Let's say with 2 additional columns: unit_price and total_amount. Then try to calculate total_amount, filter, etc.? Thanks.

[@txreal2]

at 2:00 How do I confirm that the new table is called "customer_table". I don't see it in Name Manager.

[@marciodiniz8268]

Obrigado!! Com dublagem automática em português ficou fácil de entender.

[@CodingIsFun]

Happy to hear that it was useful! Thanks for watching! -Sven ✌️

[@crabby786]

thx, thats incredible

[@CodingIsFun]

Indeed! 🤩

[@anisnjah2336]

Thinks, who to learn python in excel or sql? can we buld function with sql?

[@CodingIsFun]

Thanks for watching. Sorry, but I don't know what you mean. Cheers, Sven ✌️

[@amirzebbadshah7281]

I installed sqlookup but it is not working and giving #value error. Any suggestions

[@williansuarez3988]

¡Excelente!

[@CodingIsFun]

🎉

[@andybecker5001]

You can also do this with duckdb in excel now

[@felixzumstein1302]

That sound interesting! Do you have a link to the add-in or docs?

[@praveenkumawat2662]

Can you provide solutions for real-time data updates from sql or json data through formula

[@CodingIsFun]

Thanks for watching! I’m not entirely sure if I got your question right, but one option might be to connect to your database or JSON endpoint using Power Query. From there, you can export the Power Query results to an Excel table. Based on that table, you could run SQL queries with the add-in (if that fits your use case). Just keep in mind you’d need to refresh the table in Power Query first to ensure you’re working with the latest data. Hope that helps! Cheers, Sven ✌️

[@DinoAMAntunes]

Hi Very good, we can connect to a databse directy and still works?

[@CodingIsFun]

Thanks for watching! If I were connecting to a database, I’d use Power Query and insert the SQL statement directly while loading the data. Power Query simplifies things by managing database credentials for you. While you could handle all transformations in Power Query, I’d personally recommend adding them to the SQL script upfront to make sure you’re only pulling the data you actually need. Once you have the data, you could still export it as a table and use the add-in for SQL analysis. Hope that helps! Cheers, Sven ✌️

[@djsouljah]

Great feature! This should just be built into excel instead of an add-in though. Most I.T intrastructures prohibit installing add-in so not everyone will be able to take advantage of such features.

[@felixzumstein1302]

You can also self-host the add-in, which is much easier to handle with IT security.

[@s.umapathysatchithanandam6353]

dear Sir i couldn't get the result even i used your same tables and query

[@mnesevati]

Hi, is it a lifetime payment or a annual subscription?

[@CodingIsFun]

Thanks for watching. It's explained in the video :)

[@cartoonistgautam1965]

Can we get SQLLOOKUP addin in Excel 2010 ?

[@CodingIsFun]

Thanks for watching! I haven’t tried it in Excel 2010. Feel free to give it a try.

[@jeffwilson8246]

How does this work on larger files. 500k row tables

[@CodingIsFun]

Thanks for watching. It works the same way as demonstrated in the video. I went ahead, tested it, and even recorded a demonstration for you. Here’s the video: kzbin.info/www/bejne/aZ7Ek4CiaLeKo7ssi=XgH6uRiyg0egxl3q Cheers, Sven ✌️

[@1yyymmmddd]

You can do SQL in Power Query in which case you do not need to rely on odd apps made by unknown public.

[@mattmatt245]

Wouldn't it be we easier to just use power query in all those examples ?

[@CodingIsFun]

Thanks for watching! If Power Query works better for you, that's great! I personally use PQ mainly for loading and transforming data (like connecting to a DB with SQL), but for analysis, I prefer Excel formulas, PivotTables, or even SQL formulas now (with the add-in as shown in the video). - Sven ✌️

[@kabaduck]

Video not working on android

[@CodingIsFun]

KZbin works on Android. Try updating your app or restarting your device.

[@FabriceFagny0412]

Ne fonctionne pas sur Office 2021 !

[@leewism]

SQL has been available for years and years in Excel with Power Query

[@CodingIsFun]

That's correct!

[@darthgnome4393]

I might be off by a couple of years but as far as I remember accessing DB data from Excel via ODBC has been there forever. Unless for a very specific case (tbo I can't think of one), this whole thing is a really bad idea for anything even slightly professional. It's unmanageable and restricting.

[@nies_diy986]

Nops only for small size records Excel sheet limited to 1 million records only in one sheet

[@gurok2]

Couldn't you do SQL already with VBA?

[@garyallan69]

And power query

[@imapi387]

And for 15 + yeard at leats. Yes.

[@CodingIsFun]

Yep, you can also use SQL in VBA, but VBA doesn’t work in the web version of Excel. Not sure about your use case, but for loading data into Excel, I’d rather use the built-in capabilities of PowerQuery, where you can load and transform your data using SQL. However, when it comes to analyzing the data, like for quick ad hoc tasks, I usually rely on Excel formulas, PivotTables, etc. Now, with this add-in, you can mix in SQL statements as well (just like a normal Excel formula). It’s like adding another tool to your toolbox, giving you even more options depending on what works best for the task. -Sven

[@dfparker2002]

Please add datasource description. SQL is worthless without a table!

[@arnaVck]

Gamechanger

[@CodingIsFun]

🚀

[@dcdien07]

sq lock has the disadvantage that the expression cannot exceed 255 characters.

[@CodingIsFun]

Thanks for watching! I think, an Excel cell formula can actually contain up to 32,767 characters. -Sven ✌️

[@berndgomann1626]

Warum deutsche Titel? Wenn dann alles in Englisch ist? Dislike

[@CodingIsFun]

Ich glaube, KZbin übersetzt das automatisch. Der KZbin-Titel ist auf Englisch: "You Can Now Use SQL in Excel! (This Changes Everything)". Beste Grüße, Sven

[@Rice0987]

In Excel 2021 ltsc it crashes.