Unable to download complex tables data on webpage using Query

[Closed]
Report
Posts
2
Registration date
Tuesday April 25, 2017
Status
Member
Last seen
April 30, 2017
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
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

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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
Posts
2
Registration date
Tuesday April 25, 2017
Status
Member
Last seen
April 30, 2017

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.
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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