Creating a spreadsheet of Skype PC to PC calls

[caybee 21]

We used a program that gave us a spreadsheet of our Skype PC to PC voice/video calls that came out looking like an itemized phone bill. Call logs using the paid Skypeout service to dial a regular telephone are (last time I checked) saved in your account page on Skype's website. The following method is for the PC to PC voice/video calls. I know the website is still there, but I haven't tried downloading the program again (I used it last January). Doesn't actually prove anything since a spreadsheet can be faked, and the parties are listed by their Skype username unless you called an actual phone number, but we did end up with 75 pages, single-spaced, tiny font and the random call times and lengths.

1) Go here: link

Ignore most of what's on the page and scroll down a little.

There is a screen shot of the Skype Exporter. Under this picture, it

says, "Download the Skype Export Utility." Click on that to

download and install the Skype Exporter program. When you run the

program, Skype will warn you that another program is trying to

access Skype; give it permission to do that.

2) Run Skype Exporter. You will see two tabs: "Contact List" and "Call

List." Click on "Call List." A list of all your incoming, outgoing,

and missed Skype calls should start appearing on this tab. It may

take a very long time (an hour or more) for this to finish.

3) When it stops, click on "export." Pick a file name and location, and save

in .xml format. You can then open this file with Excel. It will be

a read-only file, so you can then save it under another name so you can

work with it. There will be a lot of empty columns there that you

can delete to clean up the file, but some of the columns will show

the length of the call, the date, the time, and whether the call was

placed, received, or missed.

I had to play with it a bit to get it to print properly (without wrapping),

but it worked in the end, and it was very easy to see the thousands

of hours we spent talking before the interview.

Too bad the CO never looked at it.

[Rinda and Chris 0]

Another option is listed on the skype support pages at http://forum.skype.com/index.php?showtopic=87531 . This worked with version 4.0 and produced better output. Note that you must have the skype window open and click on the authorization prompt that appears at the top to allow the external program to access skype data.