Web pages often contain information in tabular format that is perfect for analysis in excel. There are 2 ways to import such tabular data from webpage to excel.
- Copy and Paste the tabular data to excel
- Fetch tabular data using Excel's inbuilt feature
The earlier approach of copy/pasting seems easy to us but it's not that much effective when you need the data in excel sheet to be synced with the web page continuously. Here comes the latter approach of using excel's inbuilt feature in picture.
This post covers the second approach - Fetching data from web page to excel. Excel has inbuilt support to parse and import the tabular information from web pages to excel sheet. It is highly effective way to keep data synced between web page and local excel sheet. Based on your needs, you can configure your sheet to be synced -
- At specific time intervals
- When the sheet opens
Follow the few easy steps to import tabular data from web page.