Previous Topic Next Topic

Unable to download complex tables data on webpage using Query

Closed
kl.rameet Posts 2 Registration date Tuesday April 25, 2017 Status Member Last seen April 30, 2017 - Apr 25, 2017 at 03:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 1, 2017 at 11:10 AM
Hello,

I am trying to figure out a way to download the data from this webpage, which has 4 collapsible sections but no luck whatsoever yet.

https://www.moneycontrol.com/stocks/data-bank/standalone/auto-2-3-wheelers.html

There are around 30 sections sharing same columns, for which data needs to be repeatedly downloaded, doing manually is painstakingly medieval.

Appreciate if you can take a look and help me with this.

Related:

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 25, 2017 at 11:30 AM
Hi kl.rameet,

The way to do this is going to the Data ribbon and then clicking on From the web. Here you can input the url. After the site loaded, click on the small yellow Arrow and click on the Import button.

Best regards,
Trowa
kl.rameet Posts 2 Registration date Tuesday April 25, 2017 Status Member Last seen April 30, 2017
Apr 30, 2017 at 11:41 AM
Hi TrowaD

I am unable to get the first column (company name) using the webquery/power query.

Appreciate if you can try and help me with this.
Answer 2 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 1, 2017 at 11:10 AM
Hi kl.rameet,

Let me show you the file where I imported the site.

The company names are located in A108:A117.

Here is the file:
http://ge.tt/1MSt1uj2

Does this look the same for you?

Best regards,
Trowa