WhatsApp group ke contacts Excel mein kaise export karein
Apne WhatsApp groups aur chats ke members ko naam aur number ke saath Excel, CSV ya phone contacts mein download karo.
WhatsApp mein group ke members ki list download karne ka koi button nahi hai. Export contacts yeh teen steps mein karta hai: groups ya chats chuno, check karo kaun shaamil hai, aur file download karo.
1. Export contacts kholo
Wapes ki Home screen par Export contacts dabao. Upar teen steps dikhenge: Choose, Review aur Download.
2. Chuno ki contacts kahan se lene hain
Wapes aapke active groups aur chats dikhata hai, sabse naye pehle. Aap:
- Ek saath kai groups select kar sakte ho. Agar koi ek se zyada group mein hai, toh woh sirf ek baar aata hai.
- Group kholke members ek-ek karke chun sakte ho, search aur Admins filter ke saath. Ho jaye toh Done dabao.
- Apni contact book export kar sakte ho: pehli row, Mi agenda completa (aapki poori contact book), aapke saare saved contacts le aati hai.
Group export karne ke liye admin hona zaroori nahi.
3. Review karo aur download karo
Total dekhne ke liye Continue dabao, phir format chuno:
- Excel (.xlsx) ya CSV, in columns ke saath:
nombre(naam),telefono(phone),grupo_origen(kis group se aaya) aures_admin(admin hai ya nahi). Column ke naam Spanish mein hain. Ektiene_whatsappcolumn bhi hai jo abhi khali aata hai. - Contacts (.vcf): seedha phone ya Google Contacts mein import karne ke liye.
- Copy: sirf numbers copy karta hai, kahin bhi paste karne ke liye.
Naam woh hota hai jo aapki contact book mein saved hai. Agar saved nahi hai, toh woh naam jo us insaan ne WhatsApp par rakha hai, aur woh bhi na ho toh number. Numbers country code ke saath aate hain, + ke bina.
Agar koi member “Number unavailable” dikhe
Communities aur kuch bade groups mein WhatsApp kuch members ke numbers chhupa deta hai. Wapes unhe nikalne ki koshish karta hai, aur jab nahi nikal pata, toh member Number unavailable dikhta hai.
Members ek-ek karke chunoge toh yeh select nahi honge. Par agar poora group export karo ya sabko select karo, toh file mein number ki jagah @lid par khatam hone wala code aata hai. In rows par message nahi ho sakta: list use karne se pehle inhe delete kar do.
Kitne contacts export kar sakte ho
| Plan | Har export mein contacts |
|---|---|
| Free | 20 tak |
| Standard | 200 tak |
| Pro | Koi limit nahi |
Limit har export par hai, din ke hisaab se nahi. Agar aapke selection mein limit se zyada contacts hain, toh Wapes aadha export nahi karta: group kholke kam members chuno, ya plan badlo.
Excel se bulk message tak
Formats ke neeche Load into Bulk send in contacts ke saath bulk sender kholta hai. Dhyan do: yeh sirf numbers bhejta hai, naam nahi. Agar {{naam}} se personalize karna hai, toh Excel download karo aur Bulk send mein Load contacts se upload karo.
Bhejne se pehle ek baat yaad rakho: ek hi group mein hone ka matlab yeh nahi ki un logon ke paas aapka number saved hai ya woh aapke message ka intezaar kar rahe hain. WhatsApp ke liye har ek nayi chat hai, aur bahut saare aise logon ko likhna jo reply nahi karte, numbers restrict hone ki sabse badi wajah hai. WhatsApp ki limits padho aur dheere shuru karo, jaise Pehla bulk message bina block hue mein bataya hai.