Login
Password

Forgot your password?

How to Use an MS Excel Web Query

By Edited Sep 8, 2016 0 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
Step One Menu Selection



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
Step Two  Minibrowser



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
Step Three  Cell Selection



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
Step Four Raw Data



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
Step Five Refreshing Data


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.



Thanks For Reading!


Advertisement

Comments

Add a new comment - No HTML
You must be logged in and verified to post a comment. Please log in or sign up to comment.

Explore InfoBarrel

Auto Business & Money Entertainment Environment Health History Home & Garden InfoBarrel University Lifestyle Sports Technology Travel & Places
© Copyright 2008 - 2016 by Hinzie Media Inc. Terms of Service Privacy Policy XML Sitemap

Follow IB Technology