Détails des Données

 


To convert a contact list into gmail contact using a simple method
CSV contacts are delimited with , only in gmail.
Clean the original source contact list
Delete all accents & embedded chars such as é è à ô ' " , ;
Format the source contact list using Excel with the following user-friendly header (7 columns):
Prenom,Nom,Email,TelMobile,TelBureau,TelDomicile,Notes
the above header will be mapped later on to the gmail contact header:
Given Name,Family Name,E-mail 1 - Value,Phone 1 - Value,Phone 2 - Value,Phone 3 - Value,Notes
Once the formatting in Excel is done check again for unwanted chars such as é è à ô ' " , ;
then
Export contacts.xls to contacts.csv
Replace all ; with ,
Replace excel header:
Prenom,Nom,Email,TelMobile,TelBureau,TelDomicile,Notes
with gmail header:
Given Name,Family Name,E-mail 1 - Value,Phone 1 - Value,Phone 2 - Value,Phone 3 - Value,Notes
finally
Import contacts.csv into gmail contact
Gmail contacts will store the data in a Libellés tab
At this stage the Contacts tab will be empty
Still in gmail contacts, transfer the contents of the newly created Libellé tab to the Contact tab
Check the gmail contacts
A smartphone using the same gmail email address will synchronise automatically all the contacts


To convert a contact list into gmail .csv format (more complicated)
Export any contact from a gmail account to .csv to get the right column format data
Open the created gmail header in Excel
Copy paste the name, email etc... from the data to be converted using Excel and with the gmail header columns dislayed
For all contacts, insert "* My Contacts" into the field "Group Membership"
From MS Excel export to csv
Replace all the ";" with ","
.csv file is now ready for a gmail contact import

Options:
Column "E-mail 1 - Type" can be "* Home"
Column "Phone 1 - Type" can be "Main" or "Mobile"


keywords: convertion convertir converting importer exporter messagerie mail email e-mail samsung android

ID 292

Retour