Excel - Get Data from Web

A surprising feature of Excel allows you to get real-time data from websites and load it into your spreadsheets. You can set it to automatically refresh the data directly from the source web page. I show you how it works and give you a few sample websites that you can use to load data.

Don't miss other great Excel training videos:

Contents 0:00
1. Stock Market Indexes 0:45
2. Mortgage Rates 2:06
3. Current Weather 2:45
4. Currency Exchange Rates 3:02
5. National Debt 3:41
6. Top TV Shows 4:07
7. Highest Grossing Movies 4:43

#seletraining #excel #tipsandtricks

[JavedIqbal-efyx]

Very important feature particularly the last website. Thank you for sharing such beautiful features

[wayneedmondson]

Hi.. such a great tip. Already using it to get lists I used to copy and paste from the web or re-type (arghh!!). Thanks for the useful information and tutorial. Thumbs up!

[anangambarman]

Straight to the point no bs, amazing guide!! Thanx man!

[SeleTraining]

I'd love to see what Websites others are using to link to Excel for data. Share your recommendations here.

[daniel.h]

Thanks for an awesome video. Please do a microsoft sharepoint video.

[andreeapalici]

How can we use the advanced url in the "From Web" in excel?

[garylhaas]

With difficult websites you can set up macros to 1) save webpage to a file on your PC OR 2) copy and past webpage to an Excel sheet - then Power Query can be used to extract data

[JNVideos]

For example:
1st column 26.91 = May 2019 and
2nd column 6.09 = Dec 2019
3rd column then when i calculate above both figure like (26.91+6.09 = 33) i need it in 3rd column as (26.91+6.09 = December 2019) please tell me the formula

[hunterjones]

Is there a way to load data from a secure site that requires a login? I'd love to auto import data from my financial services websites for stock portfolios etc.

[golfsltx]

im trying to find mailing address based on (Compnay Name, City, State, and Phone Number) is there a way top tell excell to grab the address from the internet?

[jgbalboa]

Hello Sele, I tried getting the lottery's past winning numbers from the web, but nothing works. Is there a reason why every lottery site I tried does not work? I need a refreshable table that shows the past winning numbers without me having to copy/paste as values.

[turbochimps]

Hi Sele! Trying to get a table from web, but only want the first 10 rows. Is that even possible?

[m.sulemanhabib]

1:14 i only see document here. even though i tried the same website as shown in video

[faisalshaikh]

Hello..this stuff is really useful..
But is it possible to keep the old data and get new data after I hit enter.
Like everytime we refresh, the old data should be der plus new data also should appear in new coloum or somthing..?
Is this possible..?

[mirceadancismas]

Hello . It is possible to work with the data imported from web ? ( Stock price * numbers of stocks = asset?) Thank you

[ajaykumardwivedi]

After select Load option Data is not Loading in workbook in excel 2019.
Any Solution of this problem

[jasonklee]

I'm having trouble importing the data in on the mac version of excel

[johnvirago]

I have Windows 10 and I am using Chrome OS and Excel 2016. When I try the suggested import process it doesn't work. 1) The Data table has no relationship to the website. 2) in the Web-view the following message is visible with yellow background: "Table highlighting is disabled because this page uses Internet Explorer's Compatibility Mode" I tried the same process with Internet Explorer, the same result! What is the problem? I am suspecting a setting issue, but I have not been able to ID it. Thanks for your advice in advance!

[syaifullaffandi]

i find it impossible to get data from the web site which ask login authentication. would you give me some advice?

[tarshitsvlogsbybittu]

I'm facing underlying connection was closed issue in excel 2019. However I'm able get the data from web in excel 2016. Could u please help resolve this issue in excel 2019