Easily Import Data from Web to Excel (2 Practical Examples)

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.

Example 1- Importing crude oil spot prices to Excel: 01:15
Example 2 - Getting the latest weather data into Excel: 04:59
Bonus - using emojis in Power Query: 07:25

______ 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 from the bottom of the blog post here: Will be available soon

Check out the Power Query Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-

★ My Online Excel Courses ► https://courses.xelplus.com

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL 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

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

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!

#MsExcel