Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm currently running 5.2.x on OS X 10.6.8 and I need to some deep searching of the past history in a conversation with a colleague. Skype tells me the term I'm looking for is in the long-running chat we've had, but good luck getting it to show you the specific chat entry in time without manually scrolling backwards through months and months of back-and-forth.

I'd like to export the conversation as some format I can access programmatically (HTML, XML, etc.). The HTML export options that used to be present in Skype for OS X seem to have disappeared as of the 5.0 release.

Is there a way to export chat history in Skype 5.2.x for OS X?

share|improve this question
up vote 13 down vote accepted

If you have the OS X Developer Tools installed you can use this terminal command:

sqlite3 ~/Library/Application\ Support/Skype/<YOUR SKYPENAME>/main.db "SELECT author,timestamp, body_xml FROM messages WHERE dialog_partner = '<OTHER SKYPENAME>'" > ~/Desktop/skype_chat_history.txt
share|improve this answer
    
This is excellent! That you can interface with their DB using sqlite3 is a very good bit of information. Thank you! – Ian C. Sep 21 '11 at 13:58
    
Very nice. From this I found during 2012 I spend 4.7 days talking to my SO. – Luca Spiller Jan 7 '13 at 21:48

It's a complete UI fail that you can't search within a conversation.

This isn't what you're after, but one approach I've taken is to copy and paste the entire conversation into a real editor and search there.

share|improve this answer
1  
Actually getting the Skype UI to show me the whole conversation takes...a long, long time. So long I killed it after an hour of watching it spin. But not a bad approach really. – Ian C. Jul 19 '11 at 16:40

There is a nice web-based (and thus platform-independent) tool for exporting Skype history: skypebrowser.com

It's quite handy if you don't want to mess with SQL or install any third-party software.

share|improve this answer
    
Hmm. You have to give you Skype database to a third party website. That's not a great thing. – Ian C. Apr 14 at 15:26
    
@IanC. I'm not saying it's the safest way, I'm saying it's the easiest and most convenient one. You obviously shouldn't trust any third-party software to access confidential data (not just your skype database; any browser addon that displays your email messages, prints a page you're viewing, etc.) But there are many cases when you can choose convenience over safety. – geppertuo Apr 21 at 7:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.