How can I import a .docx file with comma-separated email addresses into Gmail contacts?

Drsunil V April 26, 2014
Pinterest Stumbleupon Whatsapp

How to import docx file containing email addresses in comma separated way into Gmail contacts?

[Note: The docx file has comma-separated email addresses that OP wishes to import into his Gmail contacts.]

  1. Oron J
    May 1, 2014 at 9:23 am

    The file would look something like this:
    “E-mail Address”
    drsunil@somplace.net
    nowhereman@nowhereland.com
    jimi@hendrix.org
    ...

    • Drsunil V
      May 4, 2014 at 5:39 pm

      hi. I mean the source file is docx with only emails separated with ;

      and it is to be easily converted into a file format which can directly import into google contacts ( preferably imported emails as Google Contacts Group ). Pl note the source file does not mention name field

    • Bruce E
      May 5, 2014 at 4:04 pm

      Your source file will require conversion. The first line will be a header row with the names of the fields that are represented by the following lines of data. Even if each line only contains an email address, the header row must contain the field name "E-mail Address" in order for the import to work. Each line after that will contain a single email address.

      If this is an action that will be done many times, you may consider writing a VBA script to do the conversion for you. By doing that, you could also get fancy and set it up to reject anything that doesn't fit the proper format of an email address and automatically write the .CSV file. If this is a one-off project, it would be quicker to just manually edit the file.

    • Drsunil V
      May 5, 2014 at 5:18 pm

      I understand! Thank you very much

  2. Oron J
    April 26, 2014 at 10:13 am

    You need to save it as a text file first, then import it as any CSV file (for instructions, click on the cog in GMail, choose Help and search for "import contacts as a csv file").

    • Drsunil V
      April 29, 2014 at 5:28 pm

      Please tell , is name , email columns in .xls work as csv file? and text file with only emails in sequence wont work?

    • Oron J
      April 29, 2014 at 5:44 pm

      The file has to be in CSV format, which is text only format (sometimes called "ASCII"). Each column has to be separated by a comma from the previous one, and each row separated by a carriage return (i.e. pressing the "enter" key). You can create in in Notepad if you like, as long as the content adheres to this format:

      "First Name", "Last Name", "E-mail Address", "Home Address", "Mobile Phone"
      Dr, Sunil, drsunil@somplace.net, "1 some street, some city", "0123 456 789"
      and so on.

      If you already have the table in Excel, you just need to save it as... in Comma Separated Values (CSV) format and Excel will save it in the right format, ready for import.

    • Drsunil V
      April 30, 2014 at 5:37 pm

      Thanks. Please specify for q mentions to convert txt file with emails only( not name , address ) , to convert to .csv

Ads by Google