Microsoft 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
- Open a new Excel workbook.
- Open a website and Select with your mouse the data to import. Copy it, and paste into the workbook.
- 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”.
- 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.