How do I import data from a website that requires login?

Hey there, my name is Ajibola and I'm excited to help you out today!

To import data from a website that requires login into Excel, follow these steps:

1. Head to the Data tab in Excel.
2. Click Get Data and choose From Web.
3. In the From Web dialog box, type in the website's URL and click OK.
4. A browser window will pop up within Excel, showing the webpage.
5. If the webpage requires login credentials, fill in your UPN (User Principal Name) and Password in the designated fields.
6. Once you've entered your login credentials, click the Load button to import the data into Excel.

If the webpage isn't editable in Excel or if the UPN and Password fields can't be edited, it may mean that the website doesn't allow direct data import or requires additional authentication methods. In these cases, you may need to look into alternative methods or reach out to the website administrator for further assistance.

If you have any further questions or need additional assistance, please feel free to ask. I'm here to help!

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Kind regards

Thank you for the assistance

Hello,

Unfortunately, I don't have any further troubleshooting to offer.

There are many knowledgeable users active on the forum and I hope that someone else can offer further insight on your issue.

Thanks

Hello,

Unfortunately, I don't have any further troubleshooting to offer.

There are many knowledgeable users active on the forum and I hope that someone else can offer further insight on your issue.

Thanks

Thank you for reply...I am using excel 2021 lts, how do I enable full html options to access login, because it is accessible in excel 2013 - only that links are not clickable (Excel 2013 has options in webview to change formatting--- see image below)