Body
IMPORT A TABLE FROM THE WEB
Excel users sometimes need to insert or import a table from the web. Here are some steps to do that:
- Copy the URL.
- Select Data > Get & Transform > From Web.
- Click CTRL+V to paste the URL into the text box, then press OK.
- Use the Navigator pane under Display Options, then choose the Results table.
- You can preview the results in the pane to the right called Table View.
- Choose to Load your results through Power Query, which changes the data, loading it as an Excel table.
