Closed Thread
Results 1 to 9 of 9

Want to verify which mobile numbers are on whatsapp

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    81

    Lightbulb Want to verify which mobile numbers are on whatsapp

    I have home based sms marketing company and i always need active mobile numbers data.
    I attached an sample Excel File but it is a only sample file basically i have 333 million mobile
    numbers of my country.

    My basic need to verify which mobile numbers are on Whatsapp via MS Excel
    because each excel file have a million numbers in xlsx format.

    I installed Bluestacks in my PC and import 50000 numbers each time.
    I extract (Wa.db) from Whatsapp database folder and export wa_contacts as excel sheet.
    So i extract those numbers which shows value 1 in (is_whatsapp_user) column.

    But it takes too much time to import 50k mobile numbers each time.

    If the mobile number not registered on whatsapp so it shows 0 value
    if mobile number registered on whatsapp so it shows 1 value
    as whatsapp WA.DB doing in WA_Contacts

    I am not a developer or not know about languages even beginner in excel but i want to
    solve this issue can you please help me out.

    I also attached Wa_contacts file in excel format which i extracted from WA.DB
    In Wa_contacts mobile numbers showing in Column F and is_whatsapp_user showing in Column C
    WA_contacts.csv file just for idea that how whatsapp refine data in his software

    My basic need make the command, macro or anything else like that to
    show is_whatsapp_user values in my excel sheet as i attached Sample File in column B
    as Wa_contacts do in Whatsapp.

    Hope you understand
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,007

    Re: Want to verify which mobile numbers are on whatsapp

    Sounds to me like you will be sending out spam to private cell phone numbers. You will get NO help from me, and I would recommend that others follow the same approach.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-21-2012
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    81

    Re: Want to verify which mobile numbers are on whatsapp

    then please delete this thread
    Last edited by it_electronics2000; 05-06-2018 at 11:19 AM.

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,732

    Re: Want to verify which mobile numbers are on whatsapp

    Rule 08: Cross-posting Without Telling Us

    Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    No further help to be offered, please, until the OP has complied with this request.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,007

    Re: Want to verify which mobile numbers are on whatsapp

    Alan, perhaps you could make the same comment on the x-post site?

    I just feel that people (myself included) get enough unwanted and unasked for spam and other advertising crap on their phones, that it just would not sit right to assist in it's proliferation

  6. #6
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,732

    Re: Want to verify which mobile numbers are on whatsapp

    Ford--sent you a PM with details. I agree.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,007

    Re: Want to verify which mobile numbers are on whatsapp

    I responded, thanks

  8. #8
    Registered User
    Join Date
    12-23-2021
    Location
    Alaska USA
    MS-Off Ver
    2007
    Posts
    1

    Re: Want to verify which mobile numbers are on whatsapp

    Quote Originally Posted by it_electronics2000 View Post
    I have home based sms marketing company and i always need active mobile numbers data.
    I attached an sample Excel File but it is a only sample file basically i have 333 million mobile
    numbers of my country.

    My basic need to verify which mobile numbers are on Whatsapp via MS Excel
    because each excel file have a million numbers in xlsx format.

    I installed Bluestacks in my PC and import 50000 numbers each time.
    I extract (Wa.db) from Whatsapp database folder and export wa_contacts as excel sheet.
    So i extract those numbers which shows value 1 in (is_whatsapp_user) column.

    But it takes too much time to import 50k mobile numbers each time.

    If the mobile number not registered on whatsapp so it shows 0 value
    if mobile number registered on whatsapp so it shows 1 value
    as whatsapp WA.DB doing in WA_Contacts

    I am not a developer or not know about languages even beginner in excel but i want to
    solve this issue can you please help me out.

    I also attached Wa_contacts file in excel format which i extracted from WA.DB
    In Wa_contacts mobile numbers showing in Column F and is_whatsapp_user showing in Column C
    WA_contacts.csv file just for idea that how whatsapp refine data in his software

    My basic need make the command, macro or anything else like that to
    show is_whatsapp_user values in my excel sheet as i attached Sample File in column B
    as Wa_contacts do in Whatsapp.

    Hope you understand
    I also had a similar issue with WhatsApp and I am also looking for the same info which I think I will find this info from this forum thanks for starting this post.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,150

    Re: Want to verify which mobile numbers are on whatsapp

    Administrative Note:

    Welcome to the forum.

    If you do need any help, please start your own thread. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mobile Numbers in Different combination
    By gondal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-22-2016, 05:58 AM
  2. Deleting rows that don't contain mobile numbers from a list
    By greygat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2011, 11:58 AM
  3. Uk Mobile Telephone Numbers
    By Badvgood in forum Excel General
    Replies: 1
    Last Post: 05-13-2010, 12:54 PM
  4. Mobile Phone Numbers/ Cell Phones
    By pdiminski in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 02-16-2010, 02:06 PM
  5. Cant add a Zero infront of mobile numbers
    By PETER123 in forum Excel General
    Replies: 2
    Last Post: 10-27-2006, 03:55 AM
  6. [SOLVED] 0 on mobile numbers
    By shazemmo in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 09:10 PM
  7. mobile phones numbers
    By sparky in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1