Import Data from Website to Excel 2010

Data from a website can be imported into an Excel spreadsheet. Say you want keep up to date with currency rates, mutual funds, or sports stats. Now you can keep your eyes on those numbers that are on a website, but instead of using your favorite web browser, you can just open up your trusty spreadsheet. Once you have successfully imported the data, all you need to do is right click and select “refresh” or click the refresh button from the Data tab. Let’s take a look at the figure below which presents the location you will want to start within Excel (data tab then click “From Web”).

Excel web query

Once you click the “From Web” button a browser opens up overlapping the Excel window. Type your website in its address bar. When you reach the destination, you will see if your data is importable if it has a little arrow pointing to it. Once the arrow is clicked, then click the import button which is in the lower right corner. In the example below, I searched for MSFT stock, then clicked in front of the Prev Close: 29.19.

import button

You then will see a dialog box that confirms where you would like to pick the data range. Click OK if you want the data to begin in the A1 cell.

import data dialog box

Once the data is imported, make sure you hit the refresh button to view the most up to date information.

Refresh the Data


About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at
This entry was posted in Excel and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s