Another Thing You Didn’t Know About Excel: Integrate Online data Into Your Spreadsheets

07 July 2009 Categories: Internet tools

excel2007Microsoft Excel has a really cool feature that allows you to import data directly from a website. That feature is called “web query” and you can use it to integrate live information into your spreadsheets or just look at data and analyze it in a different way than it was originally presented on the website.

In this post we’ll learn how to built an excel query in a couple of clicks. As an example, I’ve created a single spreadsheet with the top 1,000 twitters (based on data from Twitterholic), which you can download.

Create an excel web query

  1. Open a new Excel workbook.
  2. Open a website and Select with your mouse the data to import. Copy it, and paste into the workbook.
  3. At the lower right end of the pasted area you will see the “Paste Options” button, which looks like that . Click it and choose “Create Refreshable Web Query”.
  4. A new window will open, called “New Web Query” (see image below) . Once it is done loading, little yellow boxes with an arrow inside them will show up. Click the arrow next to the data you which to import.
  5. New Web Query window

    New Web Query window