Flightradar24 Blog

Using the New Flightradar24 KML and CSV Export Tools

Tracking all 119 Emirates A380 flights in and out of Dubai on 15 April

Using the New Flightradar24 KML and CSV Export Tools

Share this article

With the release of the new Flightradar24 we added a host of great new features, but the biggest additions to our historical data are CSV and KML files. In addition to our standard online playback, premium subscribers are able to download CSV and KML files for offline use. CSV files provide a detailed record of a flight’s position and flight information, while KML files offer that information in a file suitable for use in a program like Google Earth.

Using the new CSV and KML file export tool, we’ve been able to bring Flightradar24 data to life in new ways, from the Bombardier C Series route proving trials for SWISS to following a single aircraft for a year to following an entire fleet for day.

All 338 flights to and from DFW flown by N800AN
All 338 flights to and from DFW flown by N800AN

Downloading CSV and KML Files

CSV and KML files are available to users with a Silver, Gold, or Business subscription via our aircraft and flight data pages. Downloading either file type is as easy as clicking the appropriate button for the flight in which you are interested.

An example aircraft data page. CSV and KML file export buttons are available for each flight.
An example aircraft data page. CSV and KML file export buttons are available for each flight.

CSV and KML files are available for all flights within your account’s history range. For Silver subscribers, that means 90 days of CSV/KML files are available. For Gold subscribers, 365 days; and for Business subscribers, three (3) years.

Learn how to build a FR24 ADS-B receiver and get a free Business subscription

 

Working with CSV Files

An example CSV file from Qantas 9, from Dubai to London.
An example CSV file from Qantas 9, from Dubai to London.

CSV files each have six (6) columns containing time, position, and movement information. The first column in each CSV file is a timestamp listed Unix Epoch time. The timestamp counts the number of seconds from the beginning of the Unix Epoch on 1 January 1970 (UTC). This formatting is very useful for computers and helps us ensure accuracy in our data, but to be more useful to humans, a small conversion is required.

To convert the Unix Epoch time stamp into a Date + UTC format, apply the following formula, where A2 is cell containing the Epoch Unix timestamp:

=(((A2/60)/60)/24)+DATE(1970,1,1)

The result will then need to be converted the result to a Date + Time display format in your spreadsheet application.

The next column in the file is the flight’s Callsign which contains the three-character ICAO airline identifier. The third column contains Position data, reported as latitude and longitude. The final three columns are Altitude (in feet), Speed (Ground Speed in Knots), and Direction (heading).

 

Working with KML Files

Tracking all 119 Emirates A380 flights in and out of Dubai on 15 April
Tracking all 119 Emirates A380 flights in and out of Dubai on 15 April

KML, or Keyhole Markup Language, files are used to display geographic data in a program like Google Earth. KML files allow you to see flight data in four dimensions when viewed in Google Earth. Our KML files contain two subfolders, Route and Trail. Route is an animated playback of the flight and Trail is the file containing the colored flight trail (as seen in the image above).

KML files are extremely useful for comparing multiple flight histories, like our look at the Emirates A380 fleet or American Airlines’ first 787. Multiple KML files may be combined in Google Earth to examine multiple flight paths from the same aircraft or same flight number, or any combination you can imagine. It’s also possible to save multiple KML files together as a KMZ file so you don’t have to open each KML file individually if you want to work with the data in the future.

 

Using the Data

With the utility of CSV and KML files, we’re excited by the possibilities and we’re looking forward to seeing what our users can do with the data. If you’re working on a project with our CSV or KML files, we’d love to hear about it. You can contact us here, or find us on Twitter or Facebook.

On The Radar Logo

Get the latest aviation news delivered to you

Get the latest aviation news delivered to you

Flight tracking and aviation industry news direct to your inbox

Aviation news comes quickly, so join more than 600,000 others who receive weekly aviation industry and flight tracking news from Flightradar24 direct to their inbox.

Share this article

Useful flight tracking glossary

View our glossary of terms which you may encounter either on our site or in aviation in general that we hope enriches your flight tracking experience.

About Flightradar24

Flightradar24 is a global flight tracking service that provides you with real-time information about thousands of aircraft around the world.
Latest video

FINALLY flying the 737MAX! Onboard Alaska Airlines 737-9 JFK to Seattle in First Class

On The Radar Logo
Get weekly updates on Flightradar24 and have the latest aviation news land in your inbox.

How flight tracking works

Flightradar24 combines data from several data sources including ADS-B, MLAT and radar data.
Search the blog
Trending articles
Follow us
Latest AvTalk Podcasts
Related news

Say hello to the new Bookmarks widget

We’re proud to release our new Bookmarks widget! You can now bookmark individual aircraft, flights, airports, and locations and quickly access them in the new

Flight tracking top 10 aircraft

Explore the top 10 most tracked aircraft and find out why these particular aircraft draw so much interest.

Help to grow our flight tracking coverage

We are continually looking to improve our flight tracking and the airports below are where new receivers will add the most coverage. Apply for a receiver today and if accepted you’ll receiver a free Flightradar24 Business Subscription.

Free ADS-B Receiver
Flightradar24 logo
Try the full Flightradar24 experience free for 7 days
Remove ads and unlock over 50 additional features
On The Radar Logo

Get the Flightradar24 Aviation newsletter

Flight tracking and aviation industry news direct to your inbox

Aviation news comes quickly, so we want to bring more of the aviation world to you with our weekly Flightradar24 aviation newsletter - On The Radar.

On The Radar Logo