Forum Discussion
Thoper4866
Sep 25, 2023Copper Contributor
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.co...
SergeiBaklan
Sep 25, 2023Diamond Contributor
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.
- Thoper4866Sep 25, 2023Copper Contributor
I am not familiar with power query. I will look into that immediately. Thank you very much.SergeiBaklan
- SergeiBaklanSep 25, 2023Diamond Contributor
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.