GMail 聯絡人匯入 CSV 範本 Contact Template

現在人手上有一份聯絡名單,並且想要匯入Google GMail也是合情合理的對吧? 😀

但是!

每次總有個但是(不然就不會有這篇文了),一般來說會做以下嘗試來挑戰Google大神的實力

  1. 直接把名單轉CSV檔後上傳(因為只吃CSV檔或vCard格式)
  2. 通常上面方法失敗後會以為把欄位轉成英文也許可以
  3. 如果上面又失敗,會乾脆試著把Google 聯絡人的聯絡人資料匯出來比照著改

欄位資料如下

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,
E-mail 2 - Type,
E-mail 2 - Value,
Phone 1 - Type, (EG Work, Home , Mobile etc)
Phone 1 - Value,
Phone 2 - Type,
Phone 2 - Value,
Phone 3 - Type,
Phone 3 - Value,
Phone 4 - Type,
Phone 4 - 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,
Address 2 - Type,
Address 2 - Formatted,
Address 2 - Street,
Address 2 - City,
Address 2 - PO Box,
Address 2 - Region,
Address 2 - Postal Code,
Address 2 - Country,
Address 2 - Extended Address,
Organization 1 - Type,
Organization 1 - Name,
Organization 1 - Yomi Name,
Organization 1 - Title,
Organization 1 - Department,
Organization 1 - Symbol,
Organization 1 - Location,
Organization 1 - Job Description,
Website 1 - Type,
Website 1 - Value,
Custom Field 1 - Type,
Custom Field 1 - Value

到第三步驟其實會改的人應該就可以把一些基本資料掛上了,不過如果聯絡人欄位有個 公司電話 也要填入的話,照上面欄位去填會發現資料只會跑到 附註 無法正確對應顯示欄位。

參考 Google 的說明文件: 建立或編輯 CSV 檔案 也無交代電話欄位的填法,只好自己多try一下,後來找到下面的欄位是可行的,筆記一下!

First Name  Last Name   Birthday    E-mail Address  Home Address    Home Phone  Mobile Phone    Business Phone

GMail聯絡人CSV範本

關鍵就是 Business Phone 這個關鍵字,跟Google在用的 Work 有點差異,上面這些欄位照圖示填入應該已經可以滿足大多數的需求了(吧)

Facebook 功能:

Share: