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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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.

2 replies

Answer 1 / 2
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 512
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
0
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.
0
Answer 2 / 2
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 512
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
0