一、先做好excel表格

二、另存為UTF8 編碼的逗號分隔值文件格式(csv)
三、python代碼(csv2vcf.py)(經測試可直接使用)

import sys import os import redef csv2vcf_android(csv_filename, encoding='utf-8'):"""csv格式文件轉換為安卓適用的vcf格式文件"""# 1.讀取csv文件with open(csv_filename, 'r', encoding='utf-8') as f:ftext_list = f.readlines()f.close()# 2.將cvs轉換為vcf格式vcards = ''for line in ftext_list[1:]:tel_numbers = ''name_tel_list = line.strip().split(',')if name_tel_list[0]:tel_name = name_tel_list[0] # 姓名org = name_tel_list[1] # 單位for tel in name_tel_list[2:]: # 電話tel_numbers += f'TEL;CELL:{tel}\n'vcard = f'BEGIN:VCARD\nN:{tel_name}\nORG:{org}\n{tel_numbers}END:VCARD\n'vcards += vcard# 3.保存轉換后的vcf格式文件(fpath, temp_fname) = os.path.split(csv_filename)(fname, fextension) = os.path.splitext(temp_fname)with open(f'{fpath}{fname}_android.vcf', "w", encoding=encoding) as f:try:f.write(vcards)finally:f.close()def csv2vcf_ios(csv_filename, encoding='utf-8'):"""csv格式文件轉換為ios適用vcf格式文件"""# 1.讀取csv文件with open(csv_filename, 'r', encoding='utf-8') as f:ftext_list = f.readlines()f.close()# 2.將cvs轉換為vcf格式vcards = ''for line in ftext_list[1:]:#tel_numbers = ''name_tel_list = line.strip().split(',')if name_tel_list[0]:tel_name = name_tel_list[0] # 姓名xing = tel_name[0] # 姓ming = tel_name[1:] # 名 #print(xing,ming,len(ming))org = name_tel_list[1] # 單位short_tel = name_tel_list[2]long_tel = name_tel_list[3]vcard = f'BEGIN:VCARD\nVERSION:3.0\nN:{xing};{ming};;;\nFN:{ming} {xing}\nORG:{org};\nTEL;TYPE=CELL;TYPE=pref;TYPE=VOICE:{long_tel}\nTEL;TYPE=WORK;TYPE=VOICE:{short_tel}\nPRODID:-//Apple Inc.//iCloud Web Address Book 2021B82//EN\nREV:2020-11-26T19:51:27Z\nEND:VCARD\n' vcards += vcard# 3.保存轉換后的vcf格式文件(fpath, temp_fname) = os.path.split(csv_filename)(fname, fextension) = os.path.splitext(temp_fname)with open(f'{fpath}{fname}_ios.vcf', "w", encoding=encoding) as f:try:f.write(vcards)finally:f.close()filename = sys.argv[1] csv2vcf_android(filename) csv2vcf_ios(filename)

總結

以上是生活随笔為你收集整理的手机通讯录整理excel2csv2vcf的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。