Forum Discussion

Thoper4866's avatar
Thoper4866
Copper Contributor
Sep 25, 2023

Importing a table from Flightradar24

I am a supervisor working for an aircraft refueling company. I use excel to assign flights to my coworkers. I have made a practice of using copy and paste to get data from a table on flightradar24.com. I would like to automate that process by importing the table instead. I have watched the tutorials on importing tables from the web, but it just doesnt seem to work out with this website. 

https://www.flightradar24.com/data/airports/chs/departures. I was hoping one of you excel gurus could show me how.

Respectfully Submitted

Charting
excel

3 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 25, 2023

    Thoper4866 

    That could be done by Power Query, but with modern "From Web" connector which available now only in Beta version of Excel. Or in Power BI.

    • Thoper4866's avatar
      Thoper4866
      Copper Contributor
      Sep 25, 2023

      I am not familiar with power query. I will look into that immediately.  Thank you very much.SergeiBaklan 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Sep 25, 2023

        Thoper4866 

        Afraid that's copy/paste when. In simplest case Power Query doesn't require programming skills, just 4 clicks - Get Data, enter URL, select table, load. But all depends on your Excel version and do you need transform data or not.

Resources