04 - Import Data from Web in Excel Using Power Query

In this video, I will show you how to import the data from the web into Excel using Power Query. For this video, I take an example of Wikipedia and how you can quickly import a table from Wikipedia to Excel.

For Power Query to work efficiently with importing data, it's best to have structured data such as a table.

#Excel #PowerQuery #ExcelTips

[Swizzletwice]

Excellent presentation. Organized, to the point, well-explained. Thank you.

[jamesperry]

Finally, i got connected with the right Power Query guru. Tysm.

[silvestrecamposano]

Thank you very much for simplifying the concepts that I could hardly grasp..

[ocsoutstandingconsultingse]

This is what I have been looking for and am so happy to finally find it after many frustrating attempts. Thank you!!!

[akshayaispisces]

First of all, I have to admire your teaching technique. You make it very simple for even layman to learn the subject. Not all subject experts are good at teaching. You are great at both - subject knowledge as well as teaching. Keep up the good work.

[Thiyaguhih]

I can understand your hardwork behind the every videos sir.

[tndqhnm]

thank u very much you are teaching very well if it is possible you can teach us other softwares like R and stata

[abhishekprasad]

great video, thanks for providing this type of content.

[samehznatii]

Thanks sir for this Great course which gonna help me so much in my work, Appreciated <3

[k.t.]

Excellent content! I would gladly buy one of your online courses

[otroleonarbe]

Thanks for posting this videos. One question. How did you fix the date when it's prior 1900, I can see in Excel that it shows as a negative number in the cell but displays

[chiemerieoguejiofor]

Hello.
I keep getting a Data.error message whenever i attempt to import data from the web.
Errors like - 'remote name could not be resolved' and 'could not create SSL/TSL secure channel'.

Please i need help on this, any solution??

[alwayspositive]

Great video- can we extract data from our bank statement example balance in the different accounts- by using power query "from web' function ?

[gorakhanathk]

Thanks for a good series of learning. The data from some websites cannot be pulled by the method you have explained. Is there any other advance method to pull data from such websites. Are there any legal issues if we pull data?

[putras]

Hello Sumit Bansal,  Thanks for the explanation. From your example, is it possible to have the hyperlinks (film's tittle) from the Wikipedia table still active after it loaded to excel ? Thanks.

[arulkavi]

You tube pictures are dim and unreadable, though you are explaining beautifully

[nickdecock]

First of all, thank you for your useful videos. They help me a lot!

Is it also possible to import data from webpages that are protected by credentials?
For example: I want to import my running activities from Strava to Excel to analyse those.

[pradnyakamble]

Guys pls like this vedio, we are getting free knowledge and that to in a very simple way.

[Arunkumar-dxoe]

Hi, thank you for this video. I'm trying to import data from web using power query but the options are not coming in the navigator. Could you please guide me on this.

[aneelkumar]

i found an issue while extracting data from the web as DataSource.Error: The request was aborted: Could not create SSL/TLS secure channel, please tell me how to fix it