As a Mac User I don't have access to the downloadable timetable application, which means that if I want to do anything offline, I'm stuck with navigating the PDF.

So I decided to do something about it, and wrote a script to extract all the data from the PDF into a format I could actually play with. I expect others might also like this, so I've made the raw data available as a CSV file (zipped to bring it down from 3M to 600k!)

I'm not entirely convinced I successfully caught all the weird edge cases, so if you notice any errors, please let me know.

It's nothing fancy, but being able to open it in Excel and filter on the various columns is still quite useful, and of course it opens up any number of other possibilities. I'm also considering building a little mini-application that makes it easier to play with, so if anyone has any suggestions for that, I'm all ears.


[Update: Sorry for the non-functional link initially. It seems Wordpress doesn't allow direct links to files unless they're published within a post. Should be working OK now.]

One thing that the PDF doesn't give that the PC tool appears to is routing details, listing only the number of stops, rather than what they are. Is that information available anywhere en masse, or would it be a matter of looking up each individual flight for details?

Great Work!

Interesting, saved it for future reference. Can't help but wonder if this breaks the fair use of the tool, but, quite fun to just see at a glance which flights have, for example, a A380 on them, and exactly where each airline flies.

Now, if only you could enhance to include the available classes (F, C, Y+, Y etc) it would be great for redemption planning!

Well, I got the data from the PDF, rather than the tool, and I can't see anything in the document that might imply that I shouldn't do this. I don't see why it should be problematic: it's all published factual data, and they do claim that they're "committed to delivering to you the latest flight schedules from the Star Alliance members on multiple platforms Anytime, Anywhere". All I'm doing is filling in a gap until they get around to doing so themselves!

If someone can point me at a source for that data I'll gladly include it!

Ahh, I didn't realise that they did a downloadable PDF (Now I've found the link :P) - I thought you'd written a screen-scraping tool that just queried the staralliance.com website!

As for the class availability, I don't have a clue I'm afraid without screen-scraping other websites.

Thanks salvadors

Unitl I saw this, I had no idea that SK started flying NRT-BGO (Bergen, Norway) nonstop.

Cool, many thanks!

Great work and I really can use this.

Is there any chance that the OP would be willing to release the source for the script used to parse data out of the PDF? I'd love to be able to update my CSV when the *A timetable is revised.

This is very useful. I am going to load it up into a database and play with it.