How to pull airport flight time from web to excel?

[arceaf]

Hi,

I'm currently working on a project that requires real-time (or updatable) data to be transferred from the web onto excel.

I have a list of flights that are coming in next week. I need excel to pull the flight time, information, gate number, and arrival time of each flight. I also need excel to automatically update if any delays occur.

Can someone point me in the right direction as to how I can build this?

Many thanks for your help!

-Andy

 

[alvin-chung]

Hi Andy, try visit Get external data from a Web page - Excel - Office.com for details using web query.

 

[ssingh75]

Hi Andy,

Can you please let me know the website URL from where you are looking to donwload the above info?

 

[arceaf]

Hi Andy,

Can you please let me know the website URL from where you are looking to donwload the above info?

Sure! Here is the website: Massport - Flight Status - Arrivals

Thanks for your help!