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
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:
- Why won't yahoo chat let me in the chat rooms?Best solution by Yahoo! Answers
- Why won't Yahoo messenger with voice download?Best solution by Yahoo! Answers
- Why won't Yahoo let me sign up in Yahoo messenger?Best solution by Yahoo! Answers
- Why won't Yahoo Mail let me attach photos?Best solution by answers.yahoo.com
- Why won't Yahoo! let me access my Yahoo! page?Best solution by uk.answers.yahoo.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.