Export all my gmail contacts into an excel

Asked By Arabella 10 points N/A Posted on - 10/23/2013

Hi,

Export all my gmail contacts into an excel

I want it in a nice columned way so i can sort and work on which ones i need to delete etc.

Can i have the step by step process.

Good day

• Status: Open
• Question Views: 699
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: Internet

Best Answer by Aron Hank

Go To Solution

Answered By Jessica simons 0 points N/A #198897

Export all my gmail contacts into an excel

For this the CSV Format is the easiest way to full fill your problem. Following steps can easily taken to export contacts from Gmail to excel.

1. Go to the contact tab in your Gmail account. (Click on the arrow near the Gmail logo.)
2. Select the contacts that you need to export.
3. Click More in the appeared bar.
4. Then click on export .
5. Choose options from the appeared window.
6. Now Open the Excel Application
7. Go to the Data tab
8. Then click on " Form text"
9. After that Import Wizard will open
10. Complete the Wizard

Now you have done exporting contacts!!!

About Jessica simons

Questions
0

Answers
19

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 10/27/2013
• Question Category: Internet

Best Answer

Best Answer

Answered By Aron Hank 0 points N/A #198896

Export all my gmail contacts into an excel

You can easily export your Gmail contacts into an Excel. The trick is to export your contacts in.csv format. .csv stands for comma separated value. Then, you can open the file using Microsoft Excel and your contacts are exported. Following are the steps.

1. In Gmail, Navigate to Contacts.

2. Now, Select the contacts you want to export; else you can select all the contacts or some particular contact group also.

3. On the Right hand corner, find More, drop-down to click on export.

4. Select the export format as the CSV format.

5. Now, you can easily click on the file to open it in excel.

6. You can also open Microsoft Excel, Navigate to Data tab > From Text to get external Data from Text. The wizard will start, follow the steps and get all your contacts exported in excel. 

About Aron Hank

Questions
0

Answers
100

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 11/11/2013
• Question Category: Internet