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

Discover the ease of importing data from websites directly into Excel. Our tutorial demonstrates how to use Excel's 'Get and Transform' feature (aka Power Query) to seamlessly connect, transform, and load web data for analysis.

✨ Key Highlights:
▪️ Simple & Dynamic Data Import: Learn how to import various types of data, such as petroleum spot prices and weather forecasts, in a few clicks.
▪️ Data Refresh with a Click: Experience the convenience of refreshing imported data with just a click, ensuring you always have the latest information.
▪️ Practical Examples: Follow two real-world examples to understand how to dynamically link Excel to web data sources for continuous updates.
▪️ Transforming Data in Excel: Discover how to clean and adjust data within Excel using Power Query, including filling down empty cells and adding emojis for enhanced visualization.
▪️ Auto-Refresh Options: Explore how to set your Excel file to automatically refresh data at regular intervals or when the file is opened.

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 _______

🚩Let’s connect on social:

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

[akyuvar]

what i like about Leila is, she has a sense of art beside Excel technics.

[excelisfun]

Best part of the video is when you said; "it is just part of Excel"! That seems to be our main job as Excel Trainers, to convince Excel users that Power Query is the greatest Excel Invention since the PivotTable : )

[dhirajkanrajjain]

i have been trying to learn different skills over the past few months. But all where left incomplete half way in the journey. Today started with your videos. Have been practicing them since morning. Very effective. Concise, to the point and more importantly they address real time work challenges. Thank you very much

[madclown]

Leila is a combination of an artistic and techy person.. also, the best thing about her is she gives credit to whom she got the idea.

[JCLEACHIANALITICS]

Hi Leila. My name is Julio and I live in Brazil. I'm studying a lot about Excel. I need to give my career a boost and I believe that Excel will help me a lot.
I love your channel and the way you teach. Congratulations.

[markc]

Nice. I learned something new. I also wanted to applaud you for giving credit for the work you borrowed from someone else. So many YouTubers just steal and claim content as their own

[sarahbelle]

This is amazing! Exactly what I've been wanting to do with large budget and actual datasets. 🎉

[Antagraber]

While carefully reviewing all your videos (after discovering your amazing channel), I realize about this functionality. So, ... I only can say to you, Thank You Very Much. Based on it I got a bunch of ideas that will make me progress in my complex reporting.

I often say that if EXCEL would suddenly disappear, the whole world would have a deep impact at all levels.
In the same way, I want to say that your video courses, your teaching skills, and advice make the world get a bit better.

Faithfully Yours.

[nitinkhandelwal]

I am a regular watcher of technology videos but the you explain things is just awesome thank you so much your initiative

[angelol]

Thank you, Leila, for making things easy.

[ateeqahmad]

THANKS FOR ALL YOUR WONDERFUL VIDEOS! yes, I am shouting from the rooftops about your wonderful teaching skills!

[neorvo]

I am learning not only Excel, but how to organize a video about a concept or concrete theme, and try to explain in a short time. Really impressive Leila, you have a special touch.

[shahzadsiddiqui]

Mind blowing...! Saving money to buy your black belt course and add value to my life.

[aneliadinovska]

Thank you, Leila, I love the way you present things in such a simple and clear way!

[valdannofernandes]

THIS IS ONE OF THE BEST VIDEOS I´VE EVER SEEN ABOUT EXCEL POWER QUERY. THANKS A LOT.

[waleadeniji]

Amazing....
I was given such task before which I couldn't... You just made my day
Thank you Leila

[Softwaretrain]

Thumbs up for the last trick.
It was amazing to use emojis in power query.
Thanks

[DonCereonCustoms]

That was literally phenomenal... Excel is really a power tool for entrepreneurs such as myself.

[blessingadeyemi]

Thanks so much for your videos, Leila. They have been so timely and have enabled me to make so much progress with my project.

[kirangurung]

Great video. Thanks. Plz make video about how to do data entry feom web to excel for beginners