TIPS - Import a Table From The Web

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.