Downloading Matmid statement to Excel
Oct 9, 2009 | 5:59 am
#1
Original Poster
Join Date: Jun 2004
Location: Israel (some of the time)
Programs: BA GGL, CCR; AF/KLM FB Silver; M&M LH FTL; LY GLD; HH Diamond; SPG Gold; A-Club Silver; Avis PCI
Posts: 2,054
Downloading Matmid statement to Excel
Hello
I tried copying the e-clubs Matmid statement to Excel but it's built badly from an HTML perspective meaning it's not possible to do that in any reasonable way.
I wanted to load all of my records into Excel to keep a tab and perform some statistics. I also wanted to use it to calculate when points will expire which the Website does not show you - maybe it does just before they expire but I was looking to do something more sophisticated.
Anyone had more success downloading into Excel?
Thanks
economyman
I tried copying the e-clubs Matmid statement to Excel but it's built badly from an HTML perspective meaning it's not possible to do that in any reasonable way.
I wanted to load all of my records into Excel to keep a tab and perform some statistics. I also wanted to use it to calculate when points will expire which the Website does not show you - maybe it does just before they expire but I was looking to do something more sophisticated.
Anyone had more success downloading into Excel?
Thanks
economyman
Oct 10, 2009 | 6:07 am
#2
Join Date: Dec 2007
Location: Israel
Programs: AA EP, DL DM, FB PL, LY PL, BA Bronze, HH Diamond, PC Royal Ambassador, BW Platinum
Posts: 983
Copy from the beginning of the statement table to its end,
Then past it to the Excel, Then save it as CSV (to discard all the images/html
stuff), Then close the file, Open the CSV and enjoy...
This is what i do whenever need this...
Then past it to the Excel, Then save it as CSV (to discard all the images/html
stuff), Then close the file, Open the CSV and enjoy...
This is what i do whenever need this...