Run SQL queries in EXCEL (just like a normal Excel formula 🤯)

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Did you know that you can use an SQL formula in Excel? Learn in this video how to run SQL queries in Excel. You don't have to be a programmer to be able to get the most out of SQL. In this video, you'll learn how to add the SQL formula to your Excel application. In particular, we will use the Python package xlwings and the xlwings Excel add-in. After setting everything up, I will walk you through some practical examples and share my tips and tricks for using SQL in Excel.

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Intro
00:31 – Installing the dependencies
00:57 – First SQL Example
03:07 – More SQL sample queries
06:47 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[plavali_znaem]

The content of this channel is sooo underrated!! It’s not the first time I search for something very specific and end up here finding exactly this and more over my expectations!! 🎉🎉

Weiter so, Sven! Danke sehr!

[TonySitterly]

I love SQL and hate pivot tables - This is awesome!
Thanks!

[alanmusic]

This is just AMAZING! Is so much better than using python/pandas on the termina!!! I dont know why people arent talking about this.... I was searching for something like this and you were the only video I found. Keep it up!

[kuuuyajim]

Wow! This is similar to the FILTER function but more advanced and easier to do if you know or prefer to use SQL for filtering. I can't think of a use case for my current job but it's a handy piece of knowledge to have. Thank you very much for sharing! 😉

[mubafaw]

Exactly what I was looking for. Thanks😊👍

[samaritanx]

Hi Sven, one more golden feather... shown great thing.. 💌

[hamzakrack]

Thanks man this is huge and it saves me a lot of time, but why excel doesn't have this included (or a similar feature) is beyond my understanding

[andybecker]

This is great! No idea this could be done

[sergeysergey]

Very cool! I think Microsoft have to update Power Query tool for python and sql dialects. Pandas, sql have same language structure in my opinion.

[PirieHart]

(1) How do you configure conditional formatting for output from the SQL() function?
(2) Does the SQL() function support UPDATE or other SQL statements?
Thank you for a very useful video!

[soutasimportagencies]

Thank you very much for the excellent tutorial.

[berbarmoumen]

❤❤❤😂😅 Merci beaucoup pour votre aide. From Algeria

[chaitanyadeshmukh]

This so much fun. Will definitely use it. 💯

[hasanmougharbel]

Hey there,
God bless your efforts.
I have only a general enquiry as a new sql learner.
Suppose i created one table on sql management studio for data entry purpose...
How can i compile this sql table into a windows application? In what compiler should i placed it?
The reason i am asking that i would like to discover how an sql application is finally presented as an application...
THanks for taking care of this

[grev]

Is it possible to use variable declaration? Example, cell A1 has value as date
declare @date_s date = A1
select * from table a where a.DateDocument = @date_s

[alexrosen]

Extremely useful since I work a lot in Excel. Many thanks

[jrabaona]

Why does Joseph Slatter write a book untitled "Subscribe" ? 😆😆😆 just jokin, thanks a lot for your amazing work

[rianne]

Because of company policy, I have Sophos install and when I create the query, it shuts down Excel, because of 'malicious behavior'...

[andfanilo]

Well I can again tell my students that learning SQL will get them anywhere, even using Excel 😃

[gamenotfound]

Great video! Just a question, how did you empty the worksheet from cells and automatically format the query result? Thanks!