手机通讯录excel转换vcf

需求，实现批量导入手机联系人的测试功能：

准备工作：

1.将联系人名字和手机号保存为文本格式，逗号分隔，如下：

张三,180*****427

李四,180*****429

王五,189*****456

......

保存为phone.txt(举例)

 

2.运行一下代码，将输出文件保存new_phone.vcf(举例)

import quopri

exp = """BEGIN:VCARD
VERSION:2.1
N;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE:{};;;
FN;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE:{}
TEL;CELL;PREF:{}
TEL;CELL:{}
END:VCARD
"""

with open("phone.txt","r",encoding="utf-8") as f:
    with open("new_phone.vcf", "w", encoding="utf-8") as f2:
        while True:
            res = f.readline()
            if not res:
                break
            try:
                phone = res.split(",")[1].strip()
                name = res.split(",")[0].strip()
                q_name = quopri.encodestring(name.encode("utf-8")).decode()
                print(f"phone:{phone},name:{q_name}")
            except:
                print("跳过此号码")
                continue
            new_vcf = exp.format(q_name,q_name,phone,phone)
            f2.write(new_vcf)

生成的文件如下图所示：

3.手动将生成的文件拖到手机，打开联系人，从文件导入手机