Stay on top of everything that's important with Gmail's new interface. Learn more about the new layout.

/mail/community?hl=en-GB
/mail/community?hl=en-GB
01/08/2016
Original Poster
Lynn Ransom

I want to export my contacts to Google Sheets

I need to create a spreadsheet with my gmail contacts.   Is it possible to export them into google sheets?
Community content may not be verified or up to date. Learn more.
All Replies (2)
Somnath.
02/08/2016
Somnath.
Yes.

Simply export your contacts from your account in CSV format and then upload that CSV file in your Google Drive. Thereafter, you can open that file using Google Sheets. 

Here is how you can export existing Gmail contacts into a CSV file
  1. To export contacts, go to the old version of Google Contacts.
  2. In the top left, click More and then Export.
  3. Select which contacts to export.
    • "My Contacts" are contacts you’ve created yourself.
    • "All contacts" are contacts you’ve created and Other Contacts you’ve emailed.
  4. Select Google CSV format.
  5. To save your CSV file, click Export.
  6. In the top right, click your photo, then click Sign out.
Somnath.
02/08/2016
Somnath.
Hello Lynn, 

 I had some free time at my disposal, so I thought I'd prepare a tutorial to better assist you. 

The first screenshot is that of exporting your contacts.


Then you'd need to upload the saved Google.csv file in your Google Drive



Once the file is uploaded, right click on it, then select Open With, and then, Google Sheets



Your Google.csv file should now be open in Google Sheets. In my screenshot I had to hide several empty columns to help bring more information into view.




I hope this helps.

With my best wishes,
Were these replies helpful?
How can we improve them?
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google employee – Google product team members and Community managers
 
Community Specialist – Google Partners who help to ensure the quality of community content
 
Platinum Product Expert – Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert – Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert – Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert alumni – Former Product Experts who are no longer members of the programme
Community content may not be verified or up to date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you will need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.

false
Search
Clear search
Close search
Google apps
Main menu
Search Help Centre
true
17
false