Problem in importing data from a website

[Ali Karfarma]

Hello everyone, i wanna import data from a website into an excel sheet, first i login into the website, then i go to the page that data is there and copy the URL. In excel using DATA > FROM WEB i copu the URL, however the login page is loaded. What should i do?

 

[Ali Karfarma]

i mean "paste", when i paste the URL and Click on OK, the login page of website is shown and not the page i wanted.

 

[alansidman]

What happens when you click ok and let Excel complete the steps?

 

[Ali Karfarma]

What happens when you click ok and let Excel complete the steps?

i copy the URL : Bourse View (picture 1) then i click ok
wxcel shows me the login page of website with URL: Bourse View (picture 2 & 3)

 

[alansidman]

You have shown me pictures, when you transform the data, does it give you what you what you expect? It looks like it puts a table in Power Query. This is what is supposed to happen. You can then mash up your data in Power Query and then close and load it to Native Excel.