工具/原料
电脑 QQ
方法/步骤
1、打开要提取的QQ群，点击上方的“设置”。
/iknow-pic.cdn.bcebos.com/0d338744ebf81a4c863abe92d92a6059252da665"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0d338744ebf81a4c863abe92d92a6059252da665?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/0d338744ebf81a4c863abe92d92a6059252da665"/>
2、点击“成员”。
/iknow-pic.cdn.bcebos.com/7af40ad162d9f2d3e66576b4a7ec8a136327cc71"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7af40ad162d9f2d3e66576b4a7ec8a136327cc71?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/7af40ad162d9f2d3e66576b4a7ec8a136327cc71"/>
3、如果是QQ群的管理员，会出现“高级管理”，点击“高级管理”。
/iknow-pic.cdn.bcebos.com/b219ebc4b74543a90b0fa89710178a82b9011450"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b219ebc4b74543a90b0fa89710178a82b9011450?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b219ebc4b74543a90b0fa89710178a82b9011450"/>
4、自动在浏览器中打开一个网页，网页中列出qq群成员的列表和信息。
/iknow-pic.cdn.bcebos.com/b151f8198618367a42f92d8620738bd4b31ce57d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b151f8198618367a42f92d8620738bd4b31ce57d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b151f8198618367a42f92d8620738bd4b31ce57d"/>
5、按键盘的“Ctrl+A”键，将内容全部选中。
/iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fdaa15f52ed888d43f87942745"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fdaa15f52ed888d43f87942745?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fdaa15f52ed888d43f87942745"/>
6、按键盘的“Ctrl+C”键复制。
/iknow-pic.cdn.bcebos.com/94cad1c8a786c91739270062c73d70cf3bc75740"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/94cad1c8a786c91739270062c73d70cf3bc75740?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/94cad1c8a786c91739270062c73d70cf3bc75740"/>
7、打开excel，按键盘的“Ctrl+V”键粘贴。
/iknow-pic.cdn.bcebos.com/e1fe9925bc315c6012ca39b483b1cb1349547709"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e1fe9925bc315c6012ca39b483b1cb1349547709?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/e1fe9925bc315c6012ca39b483b1cb1349547709"/>
8、粘贴后，qq群成员的列表和QQ号等信息显示在excel中。
/iknow-pic.cdn.bcebos.com/b3119313b07eca8097466bbc9f2397dda144832e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b3119313b07eca8097466bbc9f2397dda144832e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b3119313b07eca8097466bbc9f2397dda144832e"/>
9、点击excel”开始“右侧的“查找和选择”点击“选择对象”，用鼠标框选多个图片，按键盘的删除键，再保存excel文件，qq群成员的QQ号提取完成。
/iknow-pic.cdn.bcebos.com/3812b31bb051f81910405111d4b44aed2e73e700"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/3812b31bb051f81910405111d4b44aed2e73e700?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/3812b31bb051f81910405111d4b44aed2e73e700"/>