Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

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'd like to convert my Skype chat history to a collection of text files for archival purposes. Ideally, I'd like to have a command (e.g. script or app) so that I could do this on a regular basis.

Any one have any idea on how to go about doing this?

share|improve this question

Your Skype chat history is stored inside a file named main.db located by default at:


Open the File

These files are binary files and can be viewed using:

  • a Hex editor like ghex;

  • or a regular editor like GVim;

  • BUT for an efficient analysis, you should use a SQLite editor like Sqliteman:

    Performing a query to select the intended data, you can export the results to CSV, HTML, XLS, SQL and other formats.

Backup the File

You can use a simple cp command to copy the folder to somewhere else you want it to.
You can put this command in a cron.daily if you want it to run daily.

share|improve this answer describes how to do it, but I believe it assumes a Windows install of Skype. Basically, everything is in your ~/.Skype folder, and you'll need to read the sqlite database corresponding to your account. It shouldn't be too hard to make a script to do it, but I'm not aware of any that currently exist.

EDIT: has a working version of the link:

share|improve this answer
Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference. Unfortunately, the referenced link is no longer valid. – minerz029 Dec 25 '13 at 7:27

Try the software called "Skyperious" which can be clones/ downloaded from HERE. They have installable software for Linux, Windows as well as for Mac.

share|improve this answer
Wonderful and useful interface. Great job. – Aditya M P Dec 22 '14 at 13:01

There's a good and free windows program that works great with Wine:

Tested it on Lubuntu 13.10 & Wine 1.7.10, really awesome utility.

share|improve this answer
Works good! Don't forget to configure Wine to show files starting with dots, then you can open ~/.Skype/SKYPEUSERNAME/ – Leksat Jan 15 '14 at 13:27

If you're not afraid to upload your Skype database to the web, there is an online tool that allows exporting chats from main.db into html files:

Seems to work OK with small databases.

share|improve this answer

Skype log view reads skype files u can also simly copy all. Open ur skype chat window to the person u want the istory on make sure the display is set to show from the beginning and select all tohighlight copy and past to an text editor.

share|improve this answer

You should be able to simply:

  1. Right click in a chat window → Select All
  2. Press Ctrl+C to copy.
  3. Paste it into a file of your choice.

The output will be something like this:

[7:39:36 AM] username1: hello
[7:39:46 AM] username2: hello to you as well

Originally from here.

share|improve this answer

Your Answer


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.