How Do I Export Yahoo mail contacts to Thunderbird?

Why won't Yahoo mail export contacts to .csv file?

  • Either it is a bug, or Yahoo decided to disable the feature. I'm trying to create a csv file with all of my yahoo contacts. I hit the "export all" the file for a yahoo.csv, screen shows a file downloads but no contact data is included in the excel file. Its just an empty excel file that includes headers...ie first name, last name, address, email etc...but none of the contacts' data is included. All of the export options fail to include the contacts in the file.

  • Answer:

    The problem happens when you are trying to export contacts that have been imported from Facebook or another system.  You can either open each contact, make a small change and save it, or you can choose to print them.  This will give you a pdf that can be copied and pasted into a spreadsheet.  It takes a little while to reformat it, but ultimately a lot faster than opening each contact and resaving it.

Celeste Grupman at Quora Visit the source

Was this solution helpful to you?

Other answers

I just tried exporting all my contacts in a CSV and it worked perfectly fine. Are you sure that its not MS Excel that's failing to parse the CSV? Try opening the CSV in a simple text editor. Otherwise, it might be a temporary issue. Make sure you're on the latest version of Yahoo Mail.

Parth Shah

For those still having problems exporting and getting a blank csv file with only the header, I found a workaround. If you display your address book for printing, rather than exporting, you will have all of your contacts and email addresses on one page. Rather than copy/pasting all of this information manually, I wrote a script to extract that data and put it in a csv file for you. My script is over here. http://campkludge.org/?q=yahoocontactexport or  https://gist.github.com/joincamp/39e02914178aef6c13ee once that domain expires.

Jonathan Camp

I just spoke with ATT tech support and Yahoo mail support. I was told that Yahoo no longer supports exporting to contacts to a .csv file. However, you can use a pull from Yahoo, ATT, SBC, or Rocketmail directly into a mail client. That makes no sense to me why you can do one and not the other. Maybe it is a bug they have right now.

Tom Cotter

As others have mentioned, Yahoo tag each contact that has been imported from Facebook so that you can't export it. You could manually edit each contact, but with the help of a bookmarklet it's very easy to convert Yahoo contacts including Facebook ones in one click- http://iag.me/socialmedia/how-to-transfer-your-facebook-friends-to-twitter-and-other-networks-an-update/

Ian Anderson Gray

If you are importing something from Facebook or any other source then they will not be exported into CSV. Here is a beautiful workaround for that.  It also explains with an example of exporting Facebook contacts to CSV with the help of Yahoo Contacts. http://www.funbutlearn.com/2013/01/export-your-facebook-friend-list-to.html

Hari Das

Try http://www.mailboxlabs.com/app It will extract contacts from multiple Email Service provider like Gmail+,Outlook and also you can extract contacts from any Mail service using its IMAP feature.

Harshad Sonawane

I agree with Parth here, the export works fine and I opened in Excel 2007. It does show all my contacts under the correct headers. Like Parth said, please use the latest version of Yahoo mail(Minty).

Hari Shreedharan

After searching for various solutions, I thought of playing with the HTML page and seeing if I can run some regexes on it. Here is what I did: 1. Go to Actions -> Print All... 2. Use Detailed View and click "Display for Printing" 3. Run this command: echo "Name,Email" > yahoo.csv;cat address-book.html | grep -P "<b>|<div>" | grep -v "<div></div>" | sed -e 's/<b> //g' -e 's/ <\/b>//'g -e 's/<div>//g' -e 's/<\/div.*//g' | while read a && read b;do echo $a,$b;done >> yahoo.csv 4. Import into Gmail (or other services) This worked for me, but you may need to play with the regex a little. The important thing is to ensure that all your contacts have an email and a name.

Gautham B Pai

They are correct that it's because they are facebook contacts. Here is how to extract them and I've added a handy Macro to put your contacts in table format. Just get them all in one column first. Sub fix_Yahaoo_Export() ' ' Fixes Print All Export from Facebook to Yahoo. You can then import to other programs like Gmail. ' First put all your names in 1 column. 'When finished choose to show only nonblank cells in a table. lastrow = Range("a6500").End(xlUp).Row  Range("a1").Select     ActiveCell.Offset(1, 0).Range("A1").Select         'Loop    Do While ActiveCell.Row <= lastrow     Selection.Cut     ActiveCell.Offset(-1, 1).Range("A1").Select     ActiveSheet.Paste     ActiveCell.Offset(3, -1).Range("A1").Select     Loop     End Sub

Joe Che

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.