一、先做好excel表格
二、另存为UTF8 编码的逗号分隔值文件格式(csv)
三、python代码(csv2vcf.py)(经测试可直接使用)
import sys
import os
import re
def 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}