The Automator tip of the week walks you through one way to extract the contact information from Address book and put it into a format that you can upload to Gmail.
Gmail accepts csv files for importing contacts. Unfortunately Address Book does not export directly to csv. Why it doesn’t is a puzzle in it self, but thankfully we can get the same results through Automator with the use of some Microsoft Office actions.
To create a csv file Automator of your contacts in Address Book add the following actions to a workflow:
- Find People in Address Book, Set Whose to Name, is not equal to, and then use * in the input field – This tells automator to look through all the names in your address book and return everyone that doesn’t have a * in their name.
- Get Contact Information, Export Format: Spreadsheet (tabs) – This gathers all the information about each contact and puts it into a standard format we can work with.
- New Text File – I named it contacts.txt and saved it to my desktop – This will write the information from address book to a text file
- Import Text Files to Excel Workbook – Select New Workbook and mark the delimiters as Tab
- Save Excel Workbooks – Save Workbooks as contacts, on the desktop and select CSV(Comma Delimited) as the format
Import Address Book CSV File to Gmail
If everything was constructed correctly you should be able to run the workflow and 2 files will be written to your desktop. From here we can import our contacts.csv file into Gmail.
To import your contacts.csv to gmail:
- Login to Gmail
- Click Contacts
- Click Import
- Choose your contacts.csv file and click Import
- Follow the final instructions from Gmail and verify your contacts imported correctly
Now that we’ve showed how to complete this process with Automator, there is also an application – A to G that was built do extract Address Book Contacts and place them in a CSV file.
Importing Contacts from Gmail into Address Book is a bit easier.
35 Responses so far.
Maximilian
June 17, 2008 at 5:16 pmAll works well until the import to excel and safe excel workbook – as I cannot find such functions in my automator. Where can I get them or how to build them? Thanks Max
Dan
June 17, 2008 at 5:21 pmMaximilian, Do you have Microsoft Office installed? If not these steps won’t be available but using Numbers may also work.
I had Office 08 when I put this together.
Hiposaasa
August 10, 2008 at 8:37 amOOO, Interesting story))
How To Import Gmail Contacts to Address Book
November 15, 2008 at 6:01 am[...] Read this to Import Address Book Contacts to Gmail. [...]
mohammad ramzan
November 19, 2009 at 8:42 pmSatisfactory
David
July 6, 2010 at 10:29 amOf course now this article is a bit out-dated and Gmail has included the ability to import vCards from Address book =)
Import Gmail Contacts to Address Book on Iphone | Linux tutorials
August 13, 2011 at 9:36 pm[...] Read this to Import Address Book Contacts to Gmail. [...]
Anonymous
September 18, 2012 at 6:07 amAnonymous
September 19, 2012 at 2:56 pmAnonymous
September 20, 2012 at 10:17 amAnonymous
September 22, 2012 at 12:15 amAnonymous
September 22, 2012 at 9:44 amAnonymous
September 23, 2012 at 12:15 amAnonymous
October 3, 2012 at 6:59 amAnonymous
October 5, 2012 at 1:00 amAnonymous
October 13, 2012 at 7:35 pmAnonymous
October 14, 2012 at 11:21 pmAnonymous
October 16, 2012 at 10:43 pmAnonymous
October 26, 2012 at 9:24 pmAnonymous
November 5, 2012 at 12:20 pmAnonymous
November 10, 2012 at 5:21 pmAnonymous
November 17, 2012 at 7:03 pmȫѶ
Anonymous
November 22, 2012 at 3:41 amAnonymous
November 22, 2012 at 12:02 pmΪ
Anonymous
November 22, 2012 at 9:41 pmAnonymous
November 23, 2012 at 8:21 amAnonymous
November 24, 2012 at 8:43 amAnonymous
December 9, 2012 at 11:54 amΧ
Anonymous
December 11, 2012 at 10:37 amAnonymous
December 16, 2012 at 2:33 pmAnonymous
December 19, 2012 at 7:57 pmhttp://www.066078.comȫ
Anonymous
January 6, 2013 at 1:53 pm2013
Anonymous
January 8, 2013 at 7:56 pm289817880
Anonymous
January 11, 2013 at 1:18 pmAnonymous
February 14, 2013 at 2:33 amLeave a Reply
Get The Latest From Maciverse
Advertisement
Popular Articles
Apple Topics
Recent Posts
Copyright © 2012 Maciverse.com. All rights reserved.
Site powered by Go Fish Digital