How do I Import gmail contacts into a table file using excel for saving as an CVS file.

Hi William,

Based on your description, do you want to export Gmail contact to Excel and then import the contact to another Gmail?

If yes, try this method:

1. Go to the Contact tab in your Gmail account,
2. Select a group of contacts or specific contacts,
3. Click on More Export to start extraction process.
4. Choose option to export your Gmail contacts to a csv file.
5. Since csv files are supported by Excel, you can just click on the file and open it in Excel. If however, you come across any problems in opening it, you can solve them by importing csv file into Excel. Choose the Data tab and the From Text option, like you see in the picture.
6. After this, the Text Import Wizard will appear. It will lead you through several steps, one of which is choosing the type of delimiter. Once youre finished, youll have a list of Gmail contacts in your Excel document.

Please refer to this video about how to export Gmail contact into Excel:
https://www.youtube.com/watch?v=C8TyS7xkH2s

About how to import contact to another Gmail, please refer to this video:
https://www.youtube.com/watch?v=zniqxMxAJ8U

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su