Downloadable Flight History

[pika1000]

I know you can buy an extended flight history, but for the one that is available as is (aka, not paying for it), can we have the ability to download it in an Excel spreadsheet format?

[lieberma]

@pika1000

I know you can buy an extended flight history, but for the one that is available as is (aka, not paying for it), can we have the ability to download it in an Excel spreadsheet format?

Copy and paste worked wonderfully for me. Million ways to do it, but steps I took were:

Select the text by highlight the flight history starting with the column headers
right click
copy.
Go into Excel and past and viola, all exported.

For multi-page histories, proceed to the next page and repeat as required.

Neat thing that happened for me was the hyperlinks retained for the airports and individual flights and in the first two rows, the cells were colorized.

[damiross]

@pika1000

I know you can buy an extended flight history, but for the one that is available as is (aka, not paying for it), can we have the ability to download it in an Excel spreadsheet format?

Here’s what I said on 25 Nov 05 in the topic Printing Flight Activity History, followed by an addendum.

@damiross

I copy the flight history data into an Excel spreadsheet by highlighting the flights, pressing control-c, then control-v into Excel. This seems to work better with Internet Explorer and Excel 2003. In Excel 2000, the date is on a separate row from the rest of the data for a given flight. If you are familiar with Excel macros, you can create a macro to combine the two rows into one.

What I have done is created an Access database that I import the Excel spreadsheet into so I can organize the flights better.

Copying-and-pasting from Firefox to Excel doesn’t work. (editor’s note: see Addendum below)

Pasting into Word 2000 doesn’t work. However, you can paste it into WordPerfect. Be sure to use landscape for the page setup.

Finally, the data pasted into Quattro Pro only gives the URL, not the actual data.

Addendum
It is possible to copy from Firefox and paste into Excel. You will need to use “paste special” rather than “paste” after copying the data. In the options for “paste special,” select “text.”

Don’t have to use the “paste special” when copying from Opera.

Note that “paste special text” will strip off all hyperlinks and font colors.