How to Import Web Data into Excel

Importing data into Excel from a webpage is an excellent way to work with data. If you are researching a topic and find a useful table of information, bringing it into Excel allows you to sort, edit, aggregate, and analyze it.

Did I mention Something unique in the Video?
In this section, I try to put any citations, references, and links that might be useful to the subject of the video.

Join me on my podcast where I share ideas on how we can take a science-based approach to learning. On the podcast, I share ideas, book reviews, best practices, and more about learning.

Links I like to share:
Skillshare: I have courses on Skillshare and am adding more
A free course I created on Excel - I'm planning to create some more courses - let me know what you think. It's a work in progress.

My Favourite Gear
Here is my Amazon Store - I try to keep it updated 😁
Canada
US Store

Social Links

About…me.
Hello there - I'm glad you've taken the time to look at my videos and this description box!
My name is Frank and I've been teaching post-graduate programs in technical subjects for almost 25 years. My Master's Degree is in Learning and Technology (from Royal Roads University in Victoria, BC - where they filmed the X-Men movies!).

I'm a Microsoft Certified Trainer (since 1998), a Cisco Certified Academy Instructor (since 1999), and have a lot of different technical certifications (I even had my own consultancy and was a member of the Apple Consultants Network for a few years. I like technology a lot.

I've been fascinated with learning and how to improve learning for years. Especially how to leverage technology for learning. From productivity Applications like Teams, OneNote, Excel, and the entire Microsoft Office suite to tools such as Mindmapping, Metaverse, VR, AR, and more - I like to see how we can use tools to leverage our ability to teach and learn.

Learning and Technology YouTube is about helping students and teachers improve their learning by leveraging technology tools. Whether remote teaching, distance learning, hybrid teaching, or completely in the classroom - we can use technology to enhance our skills. This channel is dedicated to developing teaching and personal productivity when it comes to learning and technology. Thank you for watching!

Note: some of the links to other sites may be affiliate links that I get a referral fee for.
#excel #data #importdata

[johnczech]

Well done sir! Thanks! Very interesting!

[RockyMountainTesla]

How about updating or inserting data into an Azure Database from Excel? I will be using VBA likely to execute SQL statements in the future and I’m wondering what nuances exist for Azure specifically.

[Dedicated_.]

When I do this, excel doesn’t recognise the tables in the Wikipedia page and therefore I can only import the whole page, any fixes for this ?

[ajclever]

Do you happen to know how to import data from a website when there is a subscription? I personally have access through a subscription but when I try and import the data into excel, excel is blocked because the site does not recognize excel with a subscription to the data?