10/06/2015
Original Poster
함께넘자문턱Import .csv file into 'contacts'. birthday field doesn't work.
1 Recommended AnswerI 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
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")
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
Was this answer helpful?
How can we improve it?
All Replies (2)
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")
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~
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.
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.