Home > Tips and Tricks > Import list of emails into Yahoo

Import list of emails into Yahoo

Today someone asked me how to import a huge list of email addresses into their yahoo contacts

1. List of email addresses was in a MS Excel Sheet
2. They needed to import all these emails into a custom “list” or a “group”

I searched and came across this – hope it helps someone ( link is from Yahoo itself )

https://ca.help.yahoo.com/kb/SLN5840.html?impressions=true ( see the To prepare a new .csv file: section – the columns might have changed )

We can import addresses if we can create a CSV ( comma separated ) file and match the column names to Yahoos address format given above

Its basically these fields

Field Example Note
First Jean
Last Chrétien
Email pm@pm.gc.ca
Category Unfiled
Distribution List Everyone
Yahoo! ID jean
Home 613-555-1212
Work 613-555-1212
Pager 613-555-1212
Fax 613-555-1212
Mobile 613-555-1212
Other 613-555-1212
Primary work
Alternate Email 1 pm@yahoo.ca
Alternate Email 2 pm@gov.ca
Personal Website pm.gc.ca/ http://” not required
Business Website http://www.parl.gc.ca/ http://” not required
Title Prime Minister of Canada
Company Government of Canada
Work Address Parliament Hill
Work City Ottawa
Work Province Ottawa
Work Postal Code K1A 0A4
Work Country Canada
Home Address 24 Sussex Drive
Home City Ottawa
Home Province Ontario
Home Postal Code K1A 0A3
Home Country Canada
Birthday 1/11/1934
Anniversary 6/23/1990
Custom 1 Aline Chaîné field will be called “spouse”
Custom 2 France,Hubert and Michel field will be called “kids”
Custom 3 Elmo field will be called “pets”
Custom 4 Poutine field will be called “favourite food”
Comments Ask for ride in his plane.

So create an MS Excel Sheet with the fields you require – for example lets say you have 2 contacts and want to import them
Then your excel sheet would look like this ( i am including few fields )

First Last Email
John Doe  john-doe@gmail.com
Jane Doe  jane-doe@yahoo.com

The first row in the sheet must actually contain the field names (like First Last Email and others from the table if you want)
From the second row on-wards you can fill in the data


  1. Prepare the MS Excel Sheet with the correct field names and data
  2. Save the Excel as a CSV
  3. In Office 2010 you can do File ->Save As -> CSV (MS DOS)
  4. Log into Yahoo
  5. Navigate Contacts -> Import Contacts -> Others
  6. On the next screen you will see a series of checkboxes
  7. Only select A desktop email program (Outlook, AppleMail, etc…) 
  8. A file upload option will appear – upload the CSV file you just created
  9. Agree to the terms and and click Continue
  10. Yahoo will parse your CSV file and show you all the contacts that it will import
  11. You can click import and all the addresses will be imported to a “list” called “Desktop”
  12. In between Yahoo will show you any errors and will ask you to notify all the imported contacts of your address – skip that
  13. Once the import has happened, go back to your “Contacts” page and you will see a “Desktop” just above your “Lists”
  14. Click on that and all your imported contacts are there
  15. Assign them to whatever list you need and enjoy !!
Categories: Tips and Tricks
  1. jamal
    September 10, 2011 at 8:52 AM

    Thank you for the information.

    my problem is that when i import some contacts from CSV file to yahoo e-mail, then they are imported without their categories (lists)!!!!!!!!! why?????

    what i need is to import the contacts side by side with their categories (lists)!!!!!!!!!!!!

    what is the solution?????



  2. September 13, 2011 at 1:27 PM

    Hi Jamal

    Try using the “Category ” field in your CSV and assign it the one you want.

    If this does not work then you will need to do it the round about way

    Collect all your contacts that belong to the same “Category” and import them
    They will be available to you in your contacts as “Desktop” after import
    You can select all of them at once and assign the required category

    This becomes a pain if there are many categories to work with

  3. koza
    May 17, 2012 at 6:20 PM

    There are about 3000 received e-mails in my Yahoo inbox.How can I get a list of snders’ e-mails adresses at once? Thanks..

  4. koza
    May 17, 2012 at 6:21 PM

    Is there any way to add these 3000 mails to the contact list easily?

    • May 17, 2012 at 6:27 PM

      yes there is –
      just log into to yahoo mail
      select all the received mails ( using the check-box on the top )
      click on the settings icon ( a small gear like icon – found in both top and bottom bar )
      select “Add Senders to Contacts” option
      or you can just select all emails and press “Ctrl + A”

  5. Doug
    November 17, 2012 at 11:06 PM

    Naveen, when I do this, I successfully get the e-mail addresses and mobile numbers…however the First and Last name does not come through. Any ideas??

    • November 17, 2012 at 11:45 PM


      I initially thought that yahoo has upgraded their CSV file column names – but they have not – i just tried a very simple import and it works fine.
      My sample file looked like this ( in a text editor – save this into a file called test.csv )


      Try to import this and see if the names populate ( there might be something with the CSV file you are importing – that is all i can guess ) – if this does not work, then you can send me a sample of your file and i will try to check it out

      • Doug
        November 17, 2012 at 11:48 PM

        Thanks…after several attempts, I found that it had a simple formatting on the name headers. I removed that and it worked great.

  6. Jeanne
    April 22, 2013 at 7:48 PM

    Do you need a software program like Outlook to do this? I have a large database of businesses in a CVS file (excel) and I want to import them to my gmail or yahoo contacts without using the software if this is possible. Any suggestions? I use Go Daddy for my hosting of websites and personalized email addresses. Could I use them instead?Thanks!!!

    • April 23, 2013 at 4:58 PM


      You dont need outlook or any other software. if you have Excel or its open source equivalent, then you can import your contacts. The only thing to do is to format the contacts in the right way

  7. artisan chandeliers
    June 3, 2014 at 4:29 AM

    Hi. I tried this and my emails don’t show up in my contacts… Only the first and last names. Any ideas?

  8. Mozammel Hossain
    November 21, 2014 at 5:41 PM

    I was able to import but on the left side when I click “Email contact” all e-mail address show -up in “To”. How do I bring them in “bcc”?

    • November 21, 2014 at 5:46 PM

      quick way : on the right side you should see CC – click it then click BCC – copy paste all address from To to BCC

  9. Myra
    December 1, 2014 at 8:30 PM

    I’m adding contacts one at a time. When I try to assign the contact to a list, I get an error message. Happens constantly!

  10. kamboj
    December 6, 2014 at 6:23 AM


  11. Robert Dawson
    February 10, 2015 at 3:15 PM

    Naveen – I cannot get the .csv contact import to work at all. No matter how simple the input file, the system hangs or displays the “There is a problem…” error message. I have verified and reverified that the format is correct. Appeals to Yahoo help have gone unanswered. Any suggestions?

    • February 10, 2015 at 5:02 PM

      @Robert Dawson – i just tried a simple file import and it was successful. Here is the sample file. Copy paste it into a file with csv extension and try to import it.


      If this imports and your file does not, then there might be a problem with the file you created.
      Does it have spaces in the fields, Example is first name “John Junior”
      If there are spaces, you should make sure that all fields are enclosed in double quotes

      Let me know how it goes

      • Robert Dawson
        February 10, 2015 at 5:56 PM

        Test file did NOT import – same results as before. Just on hunch, switched to IE browser (was using Firefox), and when attempting import get a system message about opening or saving “FileImportContact.json from us-mg6.mail.yahoo.com”. Open fails because Windows doesn’t know what program to use, and Save does nothing.

      • February 10, 2015 at 6:29 PM

        How are you importing the file ? I did this
        Log into yahoo mail
        Click contacts -> Click Import Contacts
        In the File Upload Section Click Import New -> then import

        Make sure that the extension is .csv and not .csv.txt

        If nothing works, post your sample file on http://pastebin.com/ and give me the link – i can try to upload

      • Robert Dawson
        February 10, 2015 at 8:35 PM

        Test file submitted (http://pastebin.com/VX5abj7N)

    • February 10, 2015 at 8:47 PM

      I was able to import the file without issues. I dont know if its because your csv file is getting corrupted somehow. The only things i can recommend are
      1. Try to first export some contacts from yahoo in CSV format – then use the file – add your contacts and import ( see link in post )
      2. Try a different browser
      3. Try with only a few column headers at first ( First Name, last name and email )

      • Robert Dawson
        February 11, 2015 at 1:44 PM

        Did all that you suggested – used Yahoo csv export file, different browser, few columns – but no luck, Obviously a problem on this end, but I’m stumped.

  12. Josh
    February 13, 2015 at 7:02 PM

    thank you for this post! I have been trying this for weeks, and yahoo just keeps “importing contacts” and never finishes. Do you think the file is too large, or something else going on?

    • February 13, 2015 at 8:01 PM

      how large is your file ?
      according to this page, you can have a maximum of 5000 contacts https://help.yahoo.com/kb/import-sln15928.html
      also make sure your file formatting is proper

    • Bob
      February 13, 2015 at 10:15 PM

      Any luck? I had EXACTLY the same issue – Yahoo “importing contacts” w/o end. Sent Naveen my simple 3-line test file and he was able to import it w/o problem. Thought it was definitely a problem on my end, but if you’re seeing the same thing, then I’m not so sure. Sure hope you have better luck with a fix then I did.

  13. Fred
    September 5, 2015 at 6:17 PM

    I am having the same problem – i.e. json. I am using IE and have turned on enhanced security on my account.
    Are either of these actions possible cause?
    Could it be AV software / Browser add-ins?

    • September 5, 2015 at 6:53 PM

      can you try with a different browser
      if tht does not work, try switching off all browser extensions and try

      • Fred
        September 5, 2015 at 7:14 PM

        I have noticed that if I answer CANCEL to the Json Open or Save prompt that the contacts seem to import. So the enhanced security is probably not a factor.

        I was trying to use Notepad to edit the file and switched to Excel only for editing.
        Not sure if Excel does anything special that Notepad doesn’t (or vice versa) – e.g. inserting or removing a trailing CR/LF or EOF.

        I am trying now to fine tune my two-line test file to try to get the correct Category / Lists when importing.

        It will be reassuring to figure out this problem once and for all since Import / Export is the only way to do bulk-edits. Editing using the GUI gets old after updating about two or three contacts.

        For now, I am making some headway. I am continuing to play with it and will report back if I find something definite.

      • Fred
        September 6, 2015 at 4:50 AM

        So all my tests seem to indicate that the import is very, very sensitive to the field names. The JSon open or save prompt is still coming up and appears to be hanging, but, 1. I choose to save it and 2. when I open another browser tab, the import is done (provided that the field names are correct) – I did an export to see what the fields were. I couldn’t get the Category field to work on Import, but that was not a show stopper for me. The only List that resulted from my imports was a list named – Desktop.
        The JSON file that is saved contains the following:
        Dunno if this helps anyone, but I got over my hump. Thanks for the moral support.

      • Fred
        September 6, 2015 at 5:17 AM

        The Email field appears to be a Key field. The Import does not tolerate duplicated entries for the Email field and there are no error messages that I could see.

      • Fred
        September 6, 2015 at 5:37 AM

        …and the field names are cAsE-sEnSiTiVe !! Good Bye for now.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: