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 | www.httl.com.vn/en | firstclass.httl.com.vn/en

Categories: Mail


Leave a Reply

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