[詢問] excel檔案無法匯入通訊錄
小弟有一份EXCEL的通訊錄,
分別以姓名、電話、電子通郵件信箱建立欄位後,另存為.CSV檔,
之後要上傳匯入GOOGLE通訊錄卻一直失敗,
後來我將現有的GOOGLE通訊入匯出看看,看到的是
EXCEL的A1欄
Name,Given Name,Additional Name,Family Name,Yomi Name,Given Name
Yomi,Additional Name Yomi,Family Name Yomi,Name Prefix,Name
Suffix,Initials,Nickname,Short Name,Maiden
Name,Birthday,Gender,Location,Billing Information,Directory
Server,Mileage,Occupation,Hobby,Sensitivity,Priority,Subject,Notes,Group
Membership,E-mail 1 - Type,E-mail 1 - Value,Phone 1 - Type,Phone 1 -
Value,Phone 2 - Type,Phone 2 - Value,Phone 3 - Type,Phone 3 - Value,Address 1
- Type,Address 1 - Formatted,Address 1 - Street,Address 1 - City,Address 1 -
PO Box,Address 1 - Region,Address 1 - Postal Code,Address 1 - Country,Address
1 - Extended Address
EXCEL的B1欄
,,,,,,,,,,,,,,,,,,,,,,,,,,(我建立的群組名稱) ::: * My Contacts,*
Home,(聯絡人的電子信箱),,,,,,,,,,,,,,,
匯出看到的通通擠在一個欄位,我不知道要怎麼把我現有的通訊錄匯入,
不曉得怎麼處理?
請問一下我該怎麼匯入我的EXCEL名單到GOOGLE的通訊錄?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 210.69.176.169
推
09/24 10:40, , 1F
09/24 10:40, 1F
→
09/24 10:40, , 2F
09/24 10:40, 2F
→
09/24 10:40, , 3F
09/24 10:40, 3F
→
09/24 11:30, , 4F
09/24 11:30, 4F
推
09/24 12:56, , 5F
09/24 12:56, 5F
→
09/24 21:00, , 6F
09/24 21:00, 6F
推
09/24 23:17, , 7F
09/24 23:17, 7F
→
09/24 23:17, , 8F
09/24 23:17, 8F
Google 近期熱門文章
PTT數位生活區 即時熱門文章