Skip to content

How to Quickly Add or Import a Table From a Website into a Microsoft Excel Sheet

    This guide provides quick instructions so you can easily add/import a table from a website and have it appear properly formatted on your Excel worksheet. You can avoid trying to manually copy and paste tables from websites with this simple trick!

    There’s a lot of built in table functionality in Microsoft Excel, but you might not be aware that if another website already has a table you can import that table from the site directly into your Excel sheet. This will retain all data and formatting without you needing to manually adjust after the fact.

    Another big benefit of getting the Table Data from a Website vs Copying and Pasting is that you can easily just Refresh your Excel workbook if the website makes an update, and then your table will be automatically updated too since it’s pulling the info from a source.

    Using this method allows you to optimize and organize the data without stressing on getting it into the sheet properly. Excel has an easy function to get that data into your sheet. Continue with the guide below to quickly copy or import Web Data into Microsoft Excel.

    Import Table into Excel – Simple steps

    1. Access the website that has the data you want to copy into Excel.
    2. Copy the website’s URL.
    3. Open Excel (either a new file or existing one where you want the data).
    4. Click the Data tab, then click Get Data.
    5. Click From Other Sources, then click From the Web.
    6. Paste the web address in the URL field, then click OK.
    7. Click Anonymous, then Connect. Excel will connect to the website.
    8. Select the web data (in the left column) that you want add to your worksheet, then click Load.
      • When you click an option, it will show a preview of the data so you can confirm it.
    9. The data will load perfectly and cleanly into your Excel worksheet. You can now organize and format as needed.

    Import Table into Excel – Guide with images

    1) Access the website that has the data you want to copy into Excel.

    Here’s an example of a table on a website

    2) Copy the website’s URL.

    3) Open Excel (either a new file or existing one where you want the data).

    4) Click the Data tab, then click Get Data.

    5) Click From Other Sources, then click From the Web.

    6) Paste the URL in the URL field, then click OK.

    7) Click Anonymous, then Connect. Excel will connect to the website.

    8) Select the web data that you want add to your worksheet, then click Load.

    When you click an option, it will show a preview of the data so you can confirm it.

    9) The data will load perfectly and cleanly into your Excel worksheet. You can now organize and format as needed.