Importing Google Contacts
You can import your contacts into Google Apps with a CSV (Comma Separated Value) file. A CSV file is a plain text file that represents a table. Each line in the text file represents a row in the table. The values in each line (first name, last name, email address, etc.) are separated by commas. The first line in the text file may be a header row that identifies the columns; for example:
If you saved this sample text and imported it into Google Apps, you would have my name and email address in your contacts. It doesn't make much sense to create a CSV file to import a single contact. Google lets you import up to 3,000 contacts per CSV file; just put each contact on a separate line. If you have more than 3,000 contacts, you will have to create multiple CSV files.
You can create CSV files with any program that can create plain text files, such as Notepad, Wordpad, or a spreadsheet program that can save files in CSV format. (Microsoft Excel can do this.)
You can also import much more information than the contact's name and email address. The following table shows all of the contact values that Google recognizes. (I created it by entering a sample contact manually in Google Apps, then exporting that contact.) Here is a CSV template file that you can use if you want to import more than just first name, last name, and email address. This template will default to opening in Microsoft Excel on Windows systems. It contains all of the columns recognized by Google Apps' contacts. Using this template does require a basic knowledge of Excel. When you save it, Excel may warn you that some features cannot be saved in the current format (the CSV text format) and will offer to save it in Excel format for you. Ignore the warning and save it as a CSV file; you cannot import Excel files into Google Apps.
If you saved this sample text and imported it into Google Apps, you would have my name and email address in your contacts. It doesn't make much sense to create a CSV file to import a single contact. Google lets you import up to 3,000 contacts per CSV file; just put each contact on a separate line. If you have more than 3,000 contacts, you will have to create multiple CSV files.
You can create CSV files with any program that can create plain text files, such as Notepad, Wordpad, or a spreadsheet program that can save files in CSV format. (Microsoft Excel can do this.)
You can also import much more information than the contact's name and email address. The following table shows all of the contact values that Google recognizes. (I created it by entering a sample contact manually in Google Apps, then exporting that contact.) Here is a CSV template file that you can use if you want to import more than just first name, last name, and email address. This template will default to opening in Microsoft Excel on Windows systems. It contains all of the columns recognized by Google Apps' contacts. Using this template does require a basic knowledge of Excel. When you save it, Excel may warn you that some features cannot be saved in the current format (the CSV text format) and will offer to save it in Excel format for you. Ignore the warning and save it as a CSV file; you cannot import Excel files into Google Apps.
| Google Column Name | Sample Data |
|---|---|
| Name | John Doe |
| Given Name | John |
| Additional Name | R. |
| Family Name | Doe |
| Yomi* Name | |
| Given Name Yomi | |
| Additional Name Yomi | |
| Family Name Yomi | |
| Name Prefix | Mr. |
| Name Suffix | Jr., III, etc. |
| Initials | |
| Nickname | Johnny |
| Short Name | |
| Maiden Name | |
| Birthday | 02/26/1983 |
| Gender | |
| Location | |
| Billing Information | |
| Directory Server | |
| Mileage | |
| Occupation | Teacher |
| Hobby | |
| Sensitivity | |
| Priority | |
| Subject | |
| Notes | |
| Group Membership | * My Contacts |
| E-mail 1 - Type | Home |
| E-mail 1 - Value | johndoe@somedomainname.com |
| E-mail 2 - Type | * Work |
| E-mail 2 - Value | johndoe@someotherdomainname.com |
| Phone 1 - Type | Work |
| Phone 1 - Value | 123-555-1212 |
| Phone 2 - Type | Mobile |
| Phone 2 - Value | 123-555-1234 |
| Phone 3 - Type | Home |
| Phone 3 - Value | 123-555-8974 |
| Phone 4 - Type | Work Fax |
| Phone 4 - Value | 123-555-9632 |
| Address 1 - Type | Work |
| Address 1 - Formatted | |
| Address 1 - Street | 121 Main ST |
| Address 1 - City | Marion |
| Address 1 - PO Box | |
| Address 1 - Region | VA |
| Address 1 - Postal Code | 24354 |
| Address 1 - Country | USA |
| Address 1 - Extended Address | |
| Organization 1 - Type | Work |
| Organization 1 - Name | Smyth County School Board |
| Organization 1 - Yomi Name | |
| Organization 1 - Title | Third Grade Teacher |
| Organization 1 - Department | |
| Organization 1 - Symbol | |
| Organization 1 - Location | |
| Organization 1 - Job Description | |
| Website 1 - Type | Work |
| Website 1 - Value | www.scsb.org |
fill as google
prefix
first_name
middle_name
surname -- last_name
suffix
company
job_title
department
email
phone
country
street_address_1
street_address_2
city
pincode
state
po_box
label - home,work,other
birthday
event
website
relationship --like father , mother
chat -- like select fb google talk etc
internet call -- home,work,other
custom field -- any to write
notes
Post a Comment