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.]
The file would look something like this:
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
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.
I understand! Thank you very much
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").
Please tell , is name , email columns in .xls work as csv file? and text file with only emails in sequence wont work?
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, email@example.com, "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.
Thanks. Please specify for q mentions to convert txt file with emails only( not name , address ) , to convert to .csv