Link a specific sheet from an excel file available in a website to my excel sheet

[deepaksunil93]

Hi All,

I am trying to get the real time data from the excel file in the below website on my working excel file.

https://www.eia.gov/petroleum/gasdiesel/


So if you go to the website, then you can see two excel files with the name "full history" that i need to link to my excel workbook. I only need one sheet from each workbook.

Can anyone help me with the same?

Thanks in advance!
Deepak