Problem in importing data from a website

Ali Karfarma

New Member
Joined
Jan 4, 2025
Messages
3
Office Version
  1. Prefer Not To Say
Platform
  1. Windows
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?
 
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.
 
Upvote 0
What happens when you click ok and let Excel complete the steps?
 
Upvote 0

Attachments

  • Screenshot 2025-01-04 225028.png
    Screenshot 2025-01-04 225028.png
    120.7 KB · Views: 12
  • Screenshot 2025-01-04 224912.png
    Screenshot 2025-01-04 224912.png
    31.4 KB · Views: 12
  • Screenshot 2025-01-04 225433.png
    Screenshot 2025-01-04 225433.png
    111.4 KB · Views: 13
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,917
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top