everydayExcel Newsletter Header

Extracting Data from the web

extract data from web Extracting data from the web could be as easy as just copy and paste. But sometimes, the data does not turn up the way we see it on the web. One reason is the way the data is organised on the web using the different html languages available. If this is happening to you, you may want to know that this problem could be solved using Web Query, a relatively unknown function in Excel. Not only can Web Query extract data neatly from the web, it can also help to extract updated data on a regular basis. For example, there is a report that I came across that is updated on a weekly basis. If I am to pull the data once, I would have used copy and paste. But because the report is updated weekly, I choose to pull the data using Web Query. After I have seup Web Query, all I have to do is to open my Excel file and it would go to the designated url by itself to get the latest data. If you are currenly facing a similar problem, you may want to find out if Web Query is the function you are looking for all this while. You can go to https://www.advanced-excel.com/cot.html to learn how Web Query is setup step by step.

Ask us an Excel question and get your question answered by our team of Excel experts

Click on this link to post your question.

Upcoming Courses

Skills Futures CreditFor Individuals - If you are a Singaporean aged 25 and above, you are given $500 in your newly created Skills Future Credit Account. The credit in the account is meant for you to pay for WDA approved courses for the purpose of upgrading yourself without company sponsors. You can pay for our courses using your Skills Future Credit.

For Companies - If your company is a Singapore registered company with 3 or more Staff paying CPF, you are eligible to claim for PIC (Productivity and Innovation Credit in short). PIC allows you to claim back 60% of the course fees in cash or offset 4 times of the course fees against your profit (i.e. pay less taxes). Your company is also eligible to claim SDF for most of our courses. more details are available on the PIC website.

Hidden Secrets in Data Analysis with Excel 2007/2010 - 14 & 15 Mar 2016 (confirmed)

Business Analytics Reporting with PowerPoint 2010 - 3 & 4 May 2016 (confirmed)

The Hidden Key to Excel Reporting and Charting - 23 & 24 May 2016 (confirmed)

Unleash the Power of Excel PowerPivot for Data Insights - 21 & 22 Mar 2016 (confirmed)

Learning the Magic of Macros 2007 (Excel VBA) - 28 & 29 Apr 2016 (confirmed)

Breakthrough Performance for HR in Excel 2007/2010 - 17 & 18 Mar 2016 (confirmed)

Dynamic Real-Time Forecasting with Excel 2007/2010 - 16 & 17 Jun 2016 (confirmed)

For the details of the courses, please refer to our Excel courses page.

Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.

Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.

Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"


Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.