Scraping with Excel#

You’ll learn how to import tables on the web using Excel, covering:

• Data Import from Web: Use the query feature in Excel to scrape data from websites.
• Establishing Web Connections: Connect Excel to a web page using a URL.
• Using Query Editor: Navigate the query editor to view and manage web data tables.
• Loading Data: Load data from the web into Excel for further manipulation.
• Data Transformation: Remove unnecessary columns and transform data as needed.
• Applying Transformations: Track applied steps in the sequence for reproducibility.
• Refreshing Data: Refresh the imported data to get the latest updates from the web.

Here are links used in the video:

• Chennai Weather Forecast
• Excel Scraping Workbook

If you use Excel on Mac, the process is a bit different. See Importing External Data Into Excel on Mac.