Exporting Website Data into Excel?

Hi all,

I have been trying to find a way to pull some data from a website into excel. Ultimately, I would like to import all these Libor Interest Rates here (https://www.wsj.com/market-data/bonds) into excel and have some way to schedule this task daily. I tried using "Get External Data from Website" on the Data tab, but I just get a bunch of script errors and nothing works.

Can anyone help point me in the right direction of the best way to do this?

I'm using Excel 2010.

Thanks,

In case of you dont have PQ, you can use the below code for the query you need;

Please Login or Register  to view this content.

.

Dude, alansidman, that is exactly what I need.

Yeah, I couldn't do it with the older version that does not include Power Query.

Here is another question, which may not be specific to Excel.

I want to generate a daily excel file which obtains the updated rates. Is there a way in Excel to do this or would I need to setup some kind of external script? I'm not too familiar with how I would setup a command prompt/batch file to execute such a thing, but I'm sure there is a way.

Haluk, also very nice and works for my older version.

Thanks to you both!

Haluk,

How does the script know to pull the Libor Rates? I don't see where the script is getting that information from the site. What if I wanted to use this script to pull other data, such as the Consumer Rates on the same page?

Thanks,