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

Advertisements

About Steve Chase

I want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant. Please contact me on my new website at www.sequentiasolutions.com
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:

WordPress.com Logo

You are commenting using your WordPress.com 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