How to Use an MS Excel Web Query

By pegwinn | 0 Comments | Rating: 0 | |

Using an MS Excel Web Query you can bring the full power of the internet directly into your spreadsheets. By the time you finish this article, you will be able to create dynamic spreadsheets using external sources from the internet.

Let's Begin

Difficulty: Moderate and all you need is Microsoft Excel 2000 or Newer and A Working Internet Connection.

MS Excel Web Query Step1

Open Microsoft Excel and select DATA from the top line menu. Then click IMPORT EXTERNAL DATA. Then click NEW WEB QUERY.

Tip: The keyboard shortcut for step 1 is Alt DDW.

MS Excel Web Query Step2

A minibrowser window will open and you will enter the URL of the data you will query. The minibrowser will allow you to click links and navigate to another site if you need to.

MS Excel Web Query Step3

You will see yellow arrows pointing to data you can import. Click the arrow for your data and it will become a checkmark. Click IMPORT. You'll get a message asking you where your information should go. Then the active cell will change to a dashed border.

MS Excel Web Query Step4

Click OK and your MS Excel Web Query is completed. You can format or sorted the information and work with it using formulas or as reference points.

MS Excel Web Query Step5

You will need to refresh your data from time to time as circumstances and information change. To refresh step 3 info, you will right click in the MS Excel Web Query information area. Your context menu will pop up. Select the bottom option that says REFRESH DATA. All your step 4 formatting will remain even with updated data.

Flag this Article

Flag Type: Spam/Inappropriate/Duplicate Grammar/Spelling/Formatting Flag Severity: 1 2 3 4 5

Reason for flag - be as descriptive as possible

Comments

Media

Step One Menu Selection

Step Two Minibrowser

Step Three Cell Selection

Step Four Raw Data

Step Five Refreshing Data