Date: Jul 28, 2022
- Open the website you want to get the data from and copy the URL.
- Then open Excel and either. ...
- Position the cursor to the cell you want to start the data copy into.
- Click on the menu option "Data" from the top menu bar and select "From Web"
- Paste the URL into the field and click "OK"
How do I extract data from a website into Excel?
Select Data > Get & Transform > From Web. Press CTRL+V to paste the URL into the text box, and then select OK. In the Navigator pane, under Display Options, select the Results table.
Can Excel pull live data from a website?
You can easily import a table of data from a web page into Excel, and regularly update the table with live data.