If you ever had to add multiple email contacts you'll know it's just a pain because for every contact you'll have to open a seperate form in the Add Contact tab in Gmail and fill out the blanks. Well there's one way here that can make your life a lot simpler especially if you're ok with spreadsheets.
Basically, you want to collect or your data about your contacts into excel for example, if you have your contacts in CSV format you are almost done!
However, if not you'll need to write down all these emails in one column in excel or notepad.
The next step is to go to Gmail and add one contact to your address book, just one is enough, after that you can easily export your address book in "Google CSV Format". After opening that file in excel, you'll be able to see at the very top all the headers and there you'll find your one email you've saved online.
What's left is the easy part where you just paste all the emails you want under the email header (but take care the emails don't have commas, they should all be in one column) and, for that matter, you can add any additional information under the respective header and save...but be sure you save as CSV...finally, import your file back to Gmail and your address book will be good and ready.
0 comments