{"id":329,"date":"2016-07-18T11:34:28","date_gmt":"2016-07-18T11:34:28","guid":{"rendered":"https:\/\/www.acquireforensics.com\/blog\/?p=329"},"modified":"2016-07-29T11:38:15","modified_gmt":"2016-07-29T11:38:15","slug":"export-skype-contacts-csv-file","status":"publish","type":"post","link":"https:\/\/www.acquireforensics.com\/blog\/export-skype-contacts-csv-file.html","title":{"rendered":"Export Skype Contacts to CSV File &#8211; Complete Guide"},"content":{"rendered":"<p>In this article the topic Export Skype Contacts to CSV file format would be discussed. As you know,\u00a0upon creating a Skype account the first activity is to create a contact directory for that\u00a0account.<br \/>\nYou can search for contacts in Skype by providing one of these credentials: name, email address, Skype name and in case of android and blackberry smart phones, a phone number is required with country code.<br \/>\nIn Skype, You can see the location for a contact on contact card.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-330 size-full\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/1.png\" alt=\"export skype contacts to csv - contact profile\" width=\"678\" height=\"301\" \/><\/p>\n<h2>Best Features of Skype Contacts<\/h2>\n<ul>\n<li style=\"text-align: justify\"><strong>Send Contacts &#8211;<\/strong> A nice and probably underused feature of Skype which provides the facility to forward any contact from your contact list to other Skype users. When you forward Skype contacts, you have to choose which contacts you want to send.<\/li>\n<li style=\"text-align: justify\"><strong>Backup and Restore Contacts &#8211;<\/strong> It\u2019s a good idea to backup your Skype contacts even though the list is maintained at Skype\u2019s central repository. To backup the contacts just <strong>Run Skype<\/strong> and then navigate to <strong>Contacts<\/strong> which you can find at top. And then select <strong>Advanced<\/strong> then select <strong>Backup contacts to file<\/strong> and then <strong>select the desired location<\/strong> in your machine and hit <strong>save<\/strong> button for backup.<\/li>\n<\/ul>\n<h2>Some Software is Convenient to\u00a0Export Skype Contacts into CSV File<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-332\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/contacts-to-csv-1.jpg\" alt=\"export skype contacts to csv\" width=\"632\" height=\"357\" \/><\/h2>\n<h3>Follow below given procedure to export Skype contacts<\/h3>\n<p><strong>STEP 1:<\/strong> Firstly, <strong>Download and install SQLite Forensics Explorer<\/strong> into your computer. Then follow the given <strong>steps to export Skype contacts to CSV<\/strong>.<\/p>\n<p><strong>STEP 2:<\/strong> Go to<strong> start menu<\/strong>, then click <strong>All programs<\/strong> and choose <strong>SQLite forensic explorer<\/strong>.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-333\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/3.png\" alt=\"export skype contacts to csv - start menu\" width=\"878\" height=\"619\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/3.png 878w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/3-768x541.png 768w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><\/p>\n<p><strong>STEP 3:<\/strong> Now, click on <strong>Add file<\/strong> option and then click on <strong>Add file button<\/strong> to upload a Skype contacts SQLite file.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-334\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/4.png\" alt=\"export skype contacts to csv - add file\" width=\"912\" height=\"556\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/4.png 912w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/4-768x468.png 768w\" sizes=\"auto, (max-width: 912px) 100vw, 912px\" \/><\/p>\n<p><strong>STEP 4:<\/strong> When you click on <strong>Add file<\/strong> button, you will see a pop up window to <strong>browse<\/strong> and <strong>select the Skype contacts SQLite file<\/strong>.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-335\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/5.png\" alt=\"add sqlite file - export skype contacts to csv\" width=\"913\" height=\"556\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/5.png 913w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/5-768x468.png 768w\" sizes=\"auto, (max-width: 913px) 100vw, 913px\" \/><\/p>\n<p><strong>STEP 5:<\/strong> Now click on <strong>browse<\/strong> button and <strong>select<\/strong> the Skype contacts SQLite file.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-336\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/6.png\" alt=\"browse for file - export skype contacts to csv\" width=\"909\" height=\"554\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/6.png 909w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/6-768x468.png 768w\" sizes=\"auto, (max-width: 909px) 100vw, 909px\" \/><\/p>\n<p><strong>STEP 6:<\/strong> Now click on <strong>Add<\/strong> button to start the scanning process of SQLite file.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-337\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/7.png\" alt=\"Add - export skype contacts to csv\" width=\"910\" height=\"554\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/7.png 910w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/7-768x468.png 768w\" sizes=\"auto, (max-width: 910px) 100vw, 910px\" \/><\/p>\n<p><strong>STEP 7:<\/strong> You can also click on<strong> Tabular tab<\/strong> to see the <strong>preview<\/strong> of Skype contacts.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-340\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/8-1.png\" alt=\"tabular - export skype contacts to csv\" width=\"911\" height=\"554\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/8-1.png 911w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/8-1-768x467.png 768w\" sizes=\"auto, (max-width: 911px) 100vw, 911px\" \/><\/p>\n<p><strong>STEP 8:<\/strong> You can also click on <strong>Hex tab<\/strong> to analyze the contacts in binary format and where you can see record bar which displays the complete <strong>chat report<\/strong>.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-339\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/9.png\" alt=\"Hex - export skype contacts to csv\" width=\"908\" height=\"555\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/9.png 908w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/9-768x469.png 768w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><\/p>\n<p><strong>STEP 9:<\/strong> To <strong>analyze and categorize<\/strong> the data, software provides the color schema feature. Which differentiates among <strong>unallocated, Active, Deleted &amp; secured data<\/strong>.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-341\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/10.png\" alt=\"categorize - tabular - export skype contacts to csv\" width=\"953\" height=\"555\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/10.png 953w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/10-768x447.png 768w\" sizes=\"auto, (max-width: 953px) 100vw, 953px\" \/><\/p>\n<p><strong>STEP 10:<\/strong> Now click on <strong>Export<\/strong> button to export the Skype contacts into CSV file format.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-342\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/11.png\" alt=\"Export - tabular - export skype contacts to csv\" width=\"904\" height=\"553\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/11.png 904w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/11-768x470.png 768w\" sizes=\"auto, (max-width: 904px) 100vw, 904px\" \/><\/p>\n<p><strong>STEP 11:<\/strong> After clicking on export button, you will see a pop up window which allow you to select Export option such as <strong>Active Records<\/strong>, <strong>Deleted Records<\/strong>, <strong>All Media files<\/strong>. Just select <strong>CSV<\/strong> format option.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-343\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/12.png\" alt=\"select options - tabular - export skype contacts to csv\" width=\"902\" height=\"553\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/12.png 902w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/12-768x471.png 768w\" sizes=\"auto, (max-width: 902px) 100vw, 902px\" \/><\/p>\n<p><strong>STEP 12:<\/strong> Now <strong>browse<\/strong> the file and hit <strong>save<\/strong> button.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-344\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/13.png\" alt=\"Browse - tabular - export skype contacts to csv\" width=\"908\" height=\"553\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/13.png 908w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/13-768x468.png 768w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><\/p>\n<p><strong>STEP 13:<\/strong> After successful Export option you will see an <strong>Export successfully<\/strong> message.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-345\" src=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/14.png\" alt=\"Export Successful - tabular - export skype contacts to csv\" width=\"902\" height=\"551\" srcset=\"https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/14.png 902w, https:\/\/www.acquireforensics.com\/blog\/wp-content\/uploads\/2016\/07\/14-768x469.png 768w\" sizes=\"auto, (max-width: 902px) 100vw, 902px\" \/><\/p>\n<h3>Conclusion<\/h3>\n<p>In this article we have discussed about how to export Skype contacts to CSV file format using SQLite Forensic Explorer. We exported all contacts into CSV file format because CSV file is easily accessible in Microsoft Excel and LibreOffice Calc applications.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article the topic Export Skype Contacts to CSV file format would be discussed. As you know,\u00a0upon creating a Skype account the first activity is to create a contact directory for that\u00a0account. You can search for contacts in Skype by providing one of these credentials: name, email address, Skype name and in case of [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":350,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-329","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-file-format"],"_links":{"self":[{"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/posts\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":1,"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/posts\/329\/revisions"}],"predecessor-version":[{"id":433,"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/posts\/329\/revisions\/433"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/media\/350"}],"wp:attachment":[{"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/media?parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/categories?post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.acquireforensics.com\/blog\/wp-json\/wp\/v2\/tags?post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}