Buzz
Discover the hidden technique of swiftly gathering data and reports from websites using Excel. Let's delve into exploring the feature of quickly and easily extracting web data with Excel.
1. For Excel 2007 - 2013
Step 1: Select the Data (1) menu => Get External Data (2) => From Web (3).
Step 2: Enter the website address you want to extract data from (1) => Go (2).
Next, click on Import.
Step 3: Choose New worksheet (1) => OK (2).
Afterward, the data retrieved from the website will be displayed on the Excel worksheet as shown in the example below.
2. Excel 2016 and later
Step 1: Navigate to the Data (1) menu => Get Data (2) => From Other Sources (3) => From Web (4).
Step 2: Choose Basic (1) => enter the website address for data extraction (2) => OK (3).
Step 3: Select the Anonymous (1) option => Connect (2) to access the website anonymously and retrieve data.
Step 4: Choose the data you want to extract (1) => Transform Data (2).
Step 5: Review and edit the data table you've extracted as needed. Click Close & Load to close the table and add the data to the current Excel file.
After successfully extracting the data, you'll have a data table similar to the one on the website.
With this method of extracting tabular data, you can quickly import data from websites without much editing. Wishing you success!
