采集软件 采集数据后导出格式为Excel（某些软件不支持导出txt的按照此操作进行提取 纯手机 号）
1、打开Excel表格，删掉多余项目，只留 名字电话 这一列数据，保存。
2、全选，按Ctrl+H替换数据中 : ; - 符号为 空白，一次输入一个符号，点击确定。
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_21","w":"553.73","h":"257.03","dataType":"png","c":"word/media/image1.png","imgOriW":670,"imgOriH":311})
3、符号去掉后如下图，然后新建一个txt文档，复制数据到txt里，保存。![](https://wkrtcs.bdimg.com/rtcs/image?w=366.00&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_21","w":"366.00","h":"139.22","dataType":"png","c":"word/media/image2.png","imgOriW":744,"imgOriH":283})
4、打开Excel手机号码提取器
![](https://wkrtcs.bdimg.com/rtcs/image?w=389.00&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_21","w":"389.00","h":"227.63","dataType":"png","c":"word/media/image3.png","imgOriW":863,"imgOriH":505})
注意，文件类型选择TXT格式
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_21","w":"553.73","h":"237.00","dataType":"png","c":"word/media/image4.png","imgOriW":1187,"imgOriH":508})
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_40","w":"553.73","h":"321.27","dataType":"png","c":"word/media/image5.png","imgOriW":879,"imgOriH":510})
5.复制提取出来的手机号码
6.打开通讯录转换器
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_40","w":"553.73","h":"299.60","dataType":"png","c":"word/media/image6.png","imgOriW":878,"imgOriH":475})
7.注意，红框标注的不能删除修改，命名方式随意![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_40","w":"553.73","h":"441.33","dataType":"png","c":"word/media/image7.png","imgOriW":921,"imgOriH":734})
8.打开转换器，选择文件，![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_40","w":"553.73","h":"360.13","dataType":"png","c":"word/media/image8.png","imgOriW":878,"imgOriH":571})
9.注意生成的文件格式，
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_40","w":"553.73","h":"300.27","dataType":"png","c":"word/media/image9.png","imgOriW":1099,"imgOriH":596})
10.用微信发送到手机![](https://wkrtcs.bdimg.com/rtcs/image?w=528.00&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_21","w":"528.00","h":"629.00","dataType":"png","c":"word/media/image10.png","imgOriW":528,"imgOriH":629})
![](https://wkrtcs.bdimg.com/rtcs/image?w=523.40&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_40","w":"523.40","h":"930.53","dataType":"jpeg","c":"word/media/image11.jpeg","imgOriW":1080,"imgOriH":1920})
打开方式---联系人
![](https://wkrtcs.bdimg.com/rtcs/image?w=240.00&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_57","w":"240.00","h":"426.69","dataType":"jpeg","c":"word/media/image12.jpeg","imgOriW":550,"imgOriH":978})
![](https://wkrtcs.bdimg.com/rtcs/image?w=226.68&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_57","w":"226.68","h":"403.00","dataType":"jpeg","c":"word/media/image14.jpeg","imgOriW":520,"imgOriH":924})
这就是刚才导入通讯录的数据，微信里面一个个
添加就行！
![](https://wkrtcs.bdimg.com/rtcs/image?w=403.29&md5sum=6939ca7e4c01487b218b6d4629d12e60&sign=50bb8e0db6&rtcs_flag=2&rtcs_ver=4&l=webapp&bucketNum=437&ipr={"t":"img","r":"r_57","w":"403.29","h":"717.00","dataType":"jpeg","c":"word/media/image16.jpeg","imgOriW":924,"imgOriH":1643})
本文来源：https://www.2haoxitong.net/k/doc/0b39814a148884868762caaedd3383c4bb4cb405.html
文档为doc格式