How to export only Name Email and Phone number from Google Contacts

Years back, there was a trick which allowed to export Google Contacts in the much cleaner way, i.e. in case you only wanted some particular fields, using the print option of Google Contacts. It seems Gmail team updated something and it no more works. So the questions hit back, How do I export contacts from contact book where it contains only Name, Email, Phone number or only fields which one requires. Right now, when you try to export, it has tons of fields which are either empty or just not needed. So in this post, I will share the trick to export only Name, Email and Phone number from Google Contacts. In the end, I will use any of the standard CSV editors to get the job done. 

How to export only Name Email and Phone number from Google Contacts

  1. Export Google Contacts
  2. Download a CSV editor
  3. Edit CSV File.

Export Google Contacts

  • Go to Google Contacts following this url: http://www.google.com/contacts
  • Next, select a group or set of contacts and click on More Button. Then export in CSV format.

How to export only Name Email and Phone number from Google Contacts

Download CSV Reader and Editor

Now download any popular CSV editors like  CSV File View or CSVed (Unicode supported).

How to export only Name Email and Phone number from Google Contacts

Editing the CSV File :

Next, open the CSV file you imported from Google contacts in any of these editors. Look for an option where it allows you to view only particular columns or hide specific columns. Once done, you can export with only selected fields.

You will have to explore options in the software which can help you do it quickly. As an example, CSVed comes with an advance exporter which can even help you create templates, export for Excel, HTML etc.

Final Result :

After you do this, you will finally have a CSV file which will only have fields which you require, and you can cleanly import it anywhere you want. I hope this helps.


About Ashish Mohta

A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. His expertise are in Windows 7, Microsoft Office, Software, Mobile Apps and Video Posts.

One comment

  1. Thank you for sharing this… it’s really help

Leave a Reply