/mail/community?hl=en-GB
/mail/community?hl=en-GB
10/06/2015
Original Poster
함께넘자문턱

Import .csv file into 'contacts'. birthday field doesn't work.

I use 'google contacts'. It great~!
and  when I edit and back up 'contacts',
I export .csv file on my desktop and edit(with Google drive).

but, when I import .csv file. there's a problem.

birthday field go to custom field.

I ask to google korea. but there no answer.


Please. solve it~!
Community content may not be verified or up to date. Learn more.
Recommended Answer
Was this answer helpful?
How can we improve it?
All Replies (2)
Martin E.L.
10/06/2015
Martin E.L.
Hi,

Thanks for using the Gmail Help Forum. I did some research for you, and it seems like birthdays do not import correctly as a .CSV file. But i did manage to find a solution that may help you:

1. Create a dummy contact in gmail contacts with an entry in all fields needed
2. Export this contact (into google.csv)
3. Open google.csv to understand the structure of the fields (in rows) how you have to organize your contacts to import
4. Export your contacts from your mail-program into a csv or text file
5. Edit this file in excel to bring it into the structure of the google.csv
6. Birthdays: The only exception, Don't use the birthday row but you need two: "Event1 - Type" and "Event1 - Value" (birthday won't work); for type you use "Birthday" and for value you need to bring the date into a string (don't use excel date format; it wont work, transform the date into a string using the TEXT formula of excel; use the format "YYYY-MM-DD") in the format "YYYY-MM-DD" (if you enter the date directly in Excel start with a ' otherwise Excel recognizes your input as date and it won't be imported)
7. Once you have finished, and only then, save the file in Windows-CSV format (if you do it earlier and go back to edit this file again you will get trouble with special characters)
8. Import this file into gmail-contacts

note for groups: you can have more than one group by separating them with " ::: " (ig "*friends ::: *my contatcs")

Hope this works.

Best,
Martin
16/06/2015
Original Poster
함께넘자문턱
It works~
file format was the problem~

so thanks, martin
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google employee – Google product team members and Community managers
 
Community Specialist – Google Partners who help to ensure the quality of community content
 
Platinum Product Expert – Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert – Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert – Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert alumni – Former Product Experts who are no longer members of the programme
Community content may not be verified or up to date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you will need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.

false
Search
Clear search
Close search
Google apps
Main menu
Search Help Centre
true
17
false