Import contacts from text file into Contacts.app

[m021478]

I have a lengthy plain text document with a list of people I work with that I need to import into my Mac's Contacts.app. There are several hundred people on the list and there's no way I'm doing this manually. Here is the precise format that the people are listed in in the document:

First Name | Last Name | <Email Address>,

John Doe <johndoe@gmail.com>,
Thomas Edison <tedison@ge.com>,
Barack Obama <barakobama@whitehouse.gov>,
Vladimir Putin <warmonger@kgb.ru>,

Anyone know of a third party program or a script that could somehow parse this list and create either individual vCards, or a single vCard containing everyone on the list that I could then import into contacts... And if there is some other clever way of doing this other than by way of vCard, that would be fine too.

Any suggestions would be greatly appreciated... Thanks!

 

[kryten2]

I have a lengthy plain text document with a list of people I work with that I need to import into my Mac's Contacts.app. There are several hundred people on the list and there's no way I'm doing this manually. Here is the precise format that the people are listed in in the document:



Anyone know of a third party program or a script that could somehow parse this list and create either individual vCards, or a single vCard containing everyone on the list that I could then import into contacts... And if there is some other clever way of doing this other than by way of vCard, that would be fine too.

Any suggestions would be greatly appreciated... Thanks!

Clean up your text file with something like TextWrangler or even TextEdit and save it as a comma-separated value (CSV) file with the extension csv. Import it into Contacts.

First Name,Last Name,Email Address

John,Doe,johndoe@gmail.com
Thomas,Edison,tedison@ge.com
Barack,Obama,barakobama@whitehouse.gov
Vladimir,Putin,warmonger@kgb.ru

Info : Contacts (Mavericks): Export and import contacts

 

[Pharmscott]

If you have Excel available to you, I think it's can be done for free. Paste the data into a new Excel sheet. It will probably put all 3 "values" in one cell, row after row. Then use Text to Columns feature to split each value into 3 cells. Last, export/save it as a *.csv file and Contacts will accept it for import.

Tips on *.csv import: http://support.apple.com/kb/PH15080