Nov 27, 2023 · Unfortunately, I was unable to extract data from a URL that requires authentication using any other function. However, you can try using the "Get Data From Web" feature to see if it works for you. To do that, Go to Data / Analysis tab, select From Web option, enter your url on the dialog box, click OK.

Sep 28, 2023 · 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.

Apr 15, 2021 · Go to Data>From Web to enter your URL, click OK, then select Basic to enter your login credentials to have a check. For more information, you could refer to the Other Sources : Web section of Import data from external data sources .

Jan 6, 2018 · When I tried to get data from the web page in excel, the steps and results were as follows: step 1 : put in the cookie and value in the header Step 2 : authentication failed, then pressed the Back button

Feb 23, 2023 · If get data from web is not working for you, it is suggested to sync the SharePoint folder to local one drive and get data from your local folder. For error "We couldn't authenticate with the credentials provided. Please try again", you can check below link. Excel Power query unable to authenticate my credentials - Microsoft Community. Best ...

Jul 31, 2012 · In modern Excel you can use Get & Transform to connect to Web API with authorisation. Select Data tab, then in the Get & Transform group New Query -> From Other Sources -> From Web (Note: do not confuse this with ' From Web ' button which is directly in the Get External Data group).

Apr 22, 2025 · API endpoint URL and any required authentication details. Step 1: Open Excel and Use Power Query to Connect to the API. Open a blank Excel workbook. ... Go to the Data tab >> from Get & Transform Data >>select From Web. In the Form Web dialog box >> insert the following API in the basic connection.

Mar 24, 2025 · To load data from a web site with Power Query Desktop: Select Get Data > Web in Power BI or From Web in the Data ribbon in Excel. For more information, go to Where to get data. Choose the Basic button and enter a URL address in the text box. For example, enter https://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States.

The web connector for Excel (AKA Get Data From Web) is a powerful tool that allows you to connect to websites and import data into your Excel workbook. The Web connector leverages the strength of Power Query in Excel to import data. You can also refresh your data connection to get the latest updates from the selected websites.

Sep 10, 2019 · How do I use Excel's Get Data > From Web (Data > Get Data > From Other Sources > From Web) feature when the desired web page is behind a login? You need to authenticate since it's protected,, by Login method,, find the method on Login page if you are not member,, some sites allows Gmail/Facebook Ids to login or instantly create an Id!