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”).
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.
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.
Once the data is imported, make sure you hit the refresh button to view the most up to date information.