TIPS - Import a Table From The Web

Summary

Import a Table From The Web

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.

Details

Details

Article ID: 8623
Created
Wed 10/18/23 10:49 AM
Modified
Wed 10/18/23 10:49 AM