Google contacts supports importing data from CSV files, Outlook, Yahoo!, Hotmail and more.
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.
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.”
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.
DJL Training, Inc. | PO Box 72362 | Durham NC 27722 | www.httl.com.vn/en | firstclass.httl.com.vn/en