Know how to import excel contacts into google contacts gmail

Do you have a list of contacts in Excel that you would like to import into your Google Contacts?

Google contacts supports importing data from CSV files, Outlook, Yahoo!, Hotmail and more.

Watching: Know how to import excel contacts into google contacts gmail


Open your Excel spreadsheet.Make sure your column headings are in row 1 and your first contact is in row 2.The Name field can be a single column, or you can use separate columns for first name, middle name and last name.There must be a column for email address.If you have a Notes column, it will be imported into the Contact”s Notes field.



Excel may warn you that your file contains features not supported by CSV format. Click OK.Note the location of your saved file.



The import process supports a Notes field. However, the maximum size for a contact is 128 KB. So if a contact exceeds this size, the Notes field might be truncated.

You can upload up to 3,000 contacts at a time. If you have more than 3,000 contacts to upload, you”ll need to create more than one CSV file to upload.

See more: Gmail How Do I Mark A Gmail Message As High Priority? Highlight An Important Email Message

Here”s a tip from our Senior Technical Trainer.

She writes:”When I need to import data into a program, the first thing I do is export a record from the destination app. I figure, surely the app can import it”s own file. Right? After I export a record, I do not rearrange, delete or rename any columns.I simply use that file as a template for my import.”

See Also:  8 conseils pour écrire le parfait mail de départ

So try these steps if all else fails…

Open a contact in Google Contacts and complete all the fields you care about or create a new one and fill it with dummy dataExport that contact to a csv or Excel fileOpen the exported file and use it as a template for importing your data.

See more: Davismail, New Gmail Account

In other words, copy your data into a file Google creates when you export a contact.

Categories :

DJL Training, Inc. | PO Box 72362 | Durham NC 27722 | |

Categories: Mail

Leave a Reply

Your email address will not be published. Required fields are marked *