Premium Only Content

Easily Import Data from Web to Excel (2 Practical Examples)
12 Dec 2019 Excel Power Query (Get & Transform)
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
You'd like to bring data from a web page into Excel? Instead of copying and pasting, use "Get and Transform" (Power Query) from the "Data" tab. This way you can import website data properly into Excel. Once you create a web query you can automatically get the latest data in Excel. You just have to refresh your query and update the query settings so it runs a refresh at specific intervals defined by you.
Getting data from a web page has never been easier. Just Open Excel, go to the "Data" tab and click on "From Web". Enter the web address of the external page you'd like to import. Power Query opens and tries to find the html tables on that web page. Select the correct table and transform your data. This step gives you the ability to customize your output. You can for example, fill in the blanks by automatically copying down the top values. You can remove the columns you don't need and clean up the data. Once done, you can view the data in an Excel table, as an Excel Pivot Table or create a connection to the query.
Note: Importing web data with Power Query this way requires the tables on the web pages to be in HTML format - otherwise they're not recognized in the Navigator view.
00:00 How to Import Data from Websites to Excel
01:15 Importing Crude Oil Spot Prices to Excel
04:59 Getting the Latest Weather Data into Excel
07:25 Bonus - Using Emojis in Power Query
______ Check out _______
Frédéric Le Guen's blog post on adding emojis to your reports: https://www.excel-exercise.com/add-emojis-to-your-charts-formulas/
Oz's video - Emojis, Excel, Power Query & Dynamic Arrays: https://youtu.be/c-tnA1zfrzs
⯆ DOWNLOAD the workbook (scroll to the bottom of the blog post): https://www.xelplus.com/import-data-from-web-to-excel/
Check out the Power Query Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
-
LIVE
The Dana Show with Dana Loesch
29 minutes agoThe Dana Show LIVE on Rumble! | 04-01-25
267 watching -
LIVE
Viss
2 hours ago🔴LIVE - PUBG Fueled with Tactics, Adrenaline, and Gasoline! - PUBG
270 watching -
LIVE
Benny Johnson
1 hour agoELECTION-MAGEDDON: Trump Vs. Obama 2028?! Third Term Matchup | MAGA on The Ballot
5,585 watching -
1:01:21
VINCE
4 hours agoScott Presler On The Ever-Important Wisconsin Election | Episode 12 - 04/01/25
192K136 -
LIVE
LFA TV
14 hours agoLFA ALL DAY LIVE STREAM 4/1/25
3,699 watching -
57:23
BonginoReport
6 hours agoEpstein Victim Reportedly on Deathbed—Still No Files - Early Edition w/Evita (Ep.172) - 04/01/2025
129K206 -
2:05:59
Matt Kohrs
9 hours agoApril Fools Market Trickery, Breaking News & Trading $1M || The MK Show
38.6K1 -
2:58:37
Wendy Bell Radio
7 hours agoIt's Another Bad Day To Be A Liberal In America
68.8K37 -
1:20:05
Dear America
13 hours agoElon Accused Of Shorting Child Support?! + Trump Hosts Kid Rock & AG Bondi Sends STRONG Warning!
68K12 -
58:36
2 MIKES LIVE
4 hours agoTHE MIKE SCHWARTZ SHOW with DR. MICHAEL J SCHWARTZ 04-01-2025
41.1K1