Excel has a surprising feature that allows you to load real-time data from
the web. I'll show you how it works and we'll take a look at some example
websites that you may find useful. You
can copy and paste or import data into Excel from a variety of sources but
wouldn't it be nice if you could load real time data from the web so it
updates automatically. The trick - go to the Data tab, choose Get Data, From Other
Sources, From Web. Now enter the URL for a website that contains the data. Not all
websites have data in a form that can be used with this tool but let's look at
some examples. Say we want to load real-time stock market data into Excel. Open
up a browser. Search for CNBC stock market. Click on this link and you'll see
the US market data. All you need to do is copy and paste that link into the URL,
hit OK, and it brings up a list of the tables with data in them that are
contained on that website. You can click on them to see what's stored in each one
and when you find a table representing the data, and in this case the actual
stock market indexes, hit load and there you have the index data. Now the nice
feature of using this tool is you can refresh this data anytime you want and
now you have a table in your Excel spreadsheet that you can use to look up
data. That's what makes it useful. If you don't want to update this data manually
click the down arrow under refresh, choose connection properties, you can
check this box and pick how many minutes you want to use between updates. Check
this box if you want to refresh the data when you open your file. Hit OK and now
they're set to update automatically. Now what other types of data are helpful?
Let's take a look at home mortgages. Go to bankrate.com, pick mortgage rates.
Make sure you select from the list here so that it displays data. Copy that URL.
Will come back in here and we'll take the shortcut under the data. The From Web
option. Paste that URL. Hit OK. We'll pick the bank rate table and hit Load and now
you have your updated rates. How about the latest weather. Look at the 10-day. Copy
and paste that and we'll pick the table with the data and load. I mentioned this
in previous post, but you can get the current exchange rates. Go to the rates
table for US dollar and copy this URL.
Find the right table and load. Now you have US dollar currency conversions to
a number of different countries. Or the national debt.
Top TV shows on Rotten Tomatoes.
Or the highest-grossing movies of all time.
I found Wikipedia to be very helpful because it contains a lot of tables of
data for a variety of different topics so search for the topic on Wikipedia,
find the table, copy the URL, and post it into Excel and you'll be able to get
that data. The key is when you get it make sure that the
forms contain tables of data on the website, otherwise it won't work. And
that's just a handful of examples of websites that you can load into Excel
with table data. Please share any other ones that you come up with in the
comment section below the video and thanks for watching!
Hey, if you want to see more videos like this one please subscribe and if you've
enjoyed this video be sure to click the thumbs-up and leave a comment. I really
do appreciate your support!