How to export and edit Google Contacts

Martin Brinkmann
Dec 30, 2014
Updated • Jan 4, 2018
Companies, Google

Google maintains a list of your contacts automatically if you use company products such as Gmail, Google Plus and others.

This list grows over time and situations may arise where you may want to export the list of contacts, for instance for safekeeping or to import it in another program, application or web service.

This guide walks you through the steps of exporting all or select Google contacts.

The first thing you want to do is open the main Google contacts website:

You need to sign in to your Google account if you are not signed in already. Once done, all available contacts and people in Google Plus circles are listed.

google export

If you want to export all contacts, click on more on the page and then on export when the context menu is displayed. This opens the following popup menu.

The two core options that you have are to select which contacts you want to export and which format you want used for that.

export google contacts
Export Google Contacts options

The first option is simple: either select one of the available groups or keep all contacts selected instead. If you have selected contacts before, you can also select to only export those contacts.

Google supports three export formats that you can select between.

  • Google CSV is a specifically formatted comma separated values file that is ideal if you want to import the contacts back into a Google account. This is great for backup purposes for example.
  • Outlook CSV is the general purpose file. It is compatible with other programs such as Outlook, and the easiest to work with in editors.
  • vCard finally is designed for Apple products. Select it if you want to import the contacts to an Apple Address Book.

If you want to process the contacts in any way, select Outlook CSV. You can load the file in Microsoft Excel, Open Office or any other program that supports CSV files to edit it there.

Each contact is listed in a single row in the spreadsheet program so that it is relatively easy to remove contacts or edit information this way. Make sure you save the data as a csv file afterwards again.

Other options that you have are to split files if you need to do so, or sort files and export only a selection as a csv file.

This file can be imported again into a Google account or another application that supports the import of csv files.

How to export and edit Google Contacts
Article Name
How to export and edit Google Contacts
How to export all or some of your Google Contacts to edit and process them before importing them into a Google account or another application or service.

Tutorials & Tips

Previous Post: «
Next Post: «


  1. guenter said on February 18, 2020 at 1:30 pm

    … and all contact photos are gone. So I never use google contacts again. All these “How to export bla bla bla”-articles never mention the foto-disaster.

  2. Yash Chauhan said on July 1, 2017 at 1:24 pm

    Outlook CSV is edittable in Excel. Once can sort all the fields and also use as an Inquiry Handler

  3. Jack Becker said on August 12, 2015 at 11:06 pm

    Hi Martin,

    I’m trying to export a contact file named “other contacts” (1963 contacts). I click on the file then go to more go export. The file “other contacts” does not show up in the drop down window. any ideas?

  4. Victor said on June 26, 2015 at 4:48 pm

    The google exports only the main or first phone numbers, correct?
    Is does not sync if you label the numbers as mobile2, mobile3, etc or the label ‘main’, ‘others’, etc
    Could somebody explain me how to fix it?

  5. Brad Patterson said on January 2, 2015 at 11:06 am

    Hi Martin,

    Great post that covers the most important bases to keep your Google Contacts in order. Jumping in here with a comment in hopes that it’s valuable to your readers as well as my company has a solution to go beyond Google’s “auto-complete”. Basically, Evercontact, automatically updates all of your contacts based on email signature analysis in your incoming emails so that you’ll always have your contacts most recent telephone #, mobile, address, company, role etc. We’d be happy to set you up with a VIP trial if you’d like & feel free to reach out at anytime.


  6. George P. Burdell said on December 31, 2014 at 5:33 pm

    Joh, try right-clicking on your cell, or the column header above the cell, then choose Properties, then Numeric Format, then pick a format you like. Sounds like your cell has defaulted to Scientific Notation, which makes phone numbers look goofy. There is a Custom choice if one of the standard formats won’t work for you. Leading zeroes might disappear under any circumstances if the cell contents are considered by Excel to be a number, in which case you must put a non-numeric character in front of the digits to force the spreadsheet to see a character string instead of a numeric value. Alternatively, you can use Constraints to force character versus numeric interpretation. This advice based on Quattro Pro, not Excel, but might work for you anyway.

  7. Joh said on December 31, 2014 at 3:30 pm

    Here in South Africa the country code is +27.
    The land line and cellphone numbers start with a 0 (zero).
    If you export it as a CSV file, the zero is dropped.
    Any suggestions?

    1. Martin Brinkmann said on December 31, 2014 at 3:39 pm

      Are you sure they are dropped during export and not by the program you load them in? Numbers starting with 0 are preserved when I load them in Office 2013.

      1. Joh said on December 31, 2014 at 4:41 pm

        Martin I use Excel 2007. The number 082…4499 will show as 8.22E+08 in the “Mobile Phone” cell.
        If I click on the cell the value 82…4499 is shown.

      2. Martin Brinkmann said on December 31, 2014 at 5:12 pm

        Joh, this is not an issue of the csv file but how Excel interprets numbers. You can modify this, see: for example.

  8. Scott said on December 31, 2014 at 2:45 pm

    Hi, Martin! Thank you for the article. If I wanted to edit my contacts using Google Sheets, and then import the edited list back into my Google Contacts, would it be better to export my contacts as Google CSV or Outlook CSV, or would it not matter? I assume Google CSV would be best for working within Google Sheets, but I’ve been wrong once or twice before… :o)

    1. Martin Brinkmann said on December 31, 2014 at 3:28 pm

      Google CSV uses a weird format, I suggest you stick with Outlook CSV.

      1. Scott said on December 31, 2014 at 4:19 pm

        Thank you, Martin, I value your advice, as always.

Leave a Reply

Check the box to consent to your data being stored in line with the guidelines set out in our privacy policy

We love comments and welcome thoughtful and civilized discussion. Rudeness and personal attacks will not be tolerated. Please stay on-topic.
Please note that your comment may not appear immediately after you post it.