Easily Export Ubuntu Evolution Contacts To Gmail

I decided to export all the contacts I have in Evolution today and import them into Gmail. I wondered if it would be hard to do (or even possible) and luckily I discovered it was a piece of cake. I’ll call it a 3-step process.

Step 1: Export Evolution Contacts

This step is super-simple. Open terminal and paste the following command:

evolution-addressbook-export --format=csv > evolution.contacts.csv

You now have a .csv file (spreadsheet) with all your contacts in it, located in your home folder.

Step 2: Clean Up Contact List

Open the evolution.contacts.csv file in OpenOffice or whatever spreadsheet program you use. I deleted any rows that I didn’t want to keep, and any columns that weren’t being used. I ended up with just a First Name, Last Name, and Email_1, Email_2 and Email_3 column, but you may choose to keep mailing addresses and phone numbers if you have data in those columns. I also renamed the first name and last name columns from given_name and family_name to First Name and Last Name. Gmail is very flexible about column names so the defaults might work, but I was certain that First Name and Last Name would be recognized by Gmail, so I just went with those. Once you’ve cleaned up the file, save it.

Step 3: Import Into Gmail

In the left sidebar of Gmail, click on Contacts. Once the Contacts page opens, click on Import in the upper right corner. Click the Browse button, choose the file you just saved from your home folder, and click on Import. Gmail will tell you if it deletes any duplicates or merges any together, and will let you know that how many it successfully imported.

That’s it! All done.

Be Sociable, Share!

bookmark digg this reddit this stumble this bookmark bookmark bookmark bookmark fave this furl this fark this sphinn this tweet this bookmark mixx this
tabs-top


3 Comments »

  1. Jim S. Says:

    I’m a newb, so please bare with me. i ran the script, but i have an error that states “invalid byte sequence in conversion input” i am running evolution 2.26.1. Only reason i am going to gmail is to use my palm pre effectively…wish i could stay with evolution.

    Any help or advice?

    comment-bottom
  2. WebChicklet Says:

    Bah, WordPress ripped out a dash in the command above and I didn’t notice. That should be TWO dashes before format, not one. I’ll try to fix it in the post.

    comment-bottom
  3. WebChicklet Says:

    Ok, I’ve fixed it. BTW, for anyone else who needs to put two dashes into a WordPress post, and not have WP strip it down to just one, see how here. Thanks to that post for the solution.

    comment-bottom

RSS feed for comments on this post. TrackBack URL

Leave a comment