Power Query (web page to Excel) - when there is no table?

[GabrielAIK]

Hi,

I would like to fetch data from an Internet page to Excel, but the problem is that the web page in question does not have a table that is importable.

Is it still possible to fetch the data, or is there no hope?

I'd like to fetch information from a website called Avanza.

E.g. this stock: https://www.avanza.se/aktier/om-aktien.html/82987/nokia-oyj

If you scroll down you see something called "Mäklarstatistik" (Broker statistics). I want to sort this by "Köpt" and then fetch the top 5 rows to Excel.

Is this possible?

Thanks!

 

[Norie]

That data is in a table.

What's happening when you try to access it using Power Query?

 

[GabrielAIK]

Oh alright!

I thought there needed to be a yellow arrow next to the table, for me to be able to select it. However, I cannot see such an arrow.

I can access the website using Power Query, but it looks just as if I opened it through a regular Chrome session.

 

[GabrielAIK]

I think I fixed it?

I imported the whole website to a sheet, and then just removed all rows that I did not want. Then I went to the "Köpt"-column, and in Excel sorted from Largest to Smallest.

Should be it? I will double check later on when there are updated trades

 

[Norie]

When I use goto Data>New Query>From Other Sources>From Web and enter the URL you posted I, eventually get to a Navigator page.

The Navigator page has 2 tabs, Table View and and Web View, and when I select Table View I get a list of tables.

The table you want, I think, is Table 0.

 

[GabrielAIK]

When I use goto Data>New Query>From Other Sources>From Web and enter the URL you posted I, eventually get to a Navigator page.

The Navigator page has 2 tabs, Table View and and Web View, and when I select Table View I get a list of tables.

The table you want, I think, is Table 0.

Perhaps I have another version. I cannot find a Navigator page in my "New Web Query". Where do you see it?

 

[Norie]

These are the steps I followed.

1 Opened a new instance of Excel.

2 Went to the Data>Get & Transform tab, this might be different on different versions of Excel.

3 Selected New Query>From Other Sources>From Web.

4 In the From Web dialog I entered the URL you posted and clicked OK.

5 This opened the Navigator dialog I mentioned, where I selected Table 0 and clicked Load.

 

[GabrielAIK]

These are the steps I followed.

1 Opened a new instance of Excel.

2 Went to the Data>Get & Transform tab, this might be different on different versions of Excel.

3 Selected New Query>From Other Sources>From Web.

4 In the From Web dialog I entered the URL you posted and clicked OK.

5 This opened the Navigator dialog I mentioned, where I selected Table 0 and clicked Load.

Alright, thanks!

Seems we have different versions.

My steps:

1. Open Excel
2. Press on the Data tab
3. Press "From Web"
4. In the Adress-field, I enter the link: https://www.avanza.se/aktier/om-aktien.html/82987/nokia-oyj
5. Press Go

Then it looks like this: https://i.imgur.com/NeHxJSa.jpg

 

[Norie]

That doesn't look like Power Query.

Which version of Excel do you have?

 

[GabrielAIK]

That doesn't look like Power Query.

Which version of Excel do you have?

I am using Microsoft Office Professional Plus 2016