How to Import Data from the Web in Excel

In this step-by-step tutorial, learn how to import and dynamically connect web data to your spreadsheet in Microsoft Excel. To import data from the web into your workbook, you need to ensure that there is a table of data on the web site that you would like to import. Once you import your data, if the data changes, you can refresh it. You can even configure Excel to refresh in the background, on pre-defined intervals, or every single time you open your spreadsheet. At the end, we also look at how you can use Power Query to transform your data before importing. This way any changes you make are applied anytime you update your data. By the end of this video, you’ll have a strong understanding of how to import data from the web into Excel.

• Additional resources
  • How to use Microsoft Power Query: https://youtu.be/0aeZX1l4JT4
• Timestamps
  • 0:00 Introduction
  • 0:46 Find web site with data to import
  • 1:25 Import web data into Excel
  • 3:20 Refresh web data
  • 4:31 Transform data
  • 6:18 Wrap up