{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Settings","BOT","Example_Data","Placeholders","Phonenumber_Validator","Phonenumber_Replicator","Backend_Settings","CountryCodes"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":39,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Settings","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,2],[9,1,9,2],[0,1,0,2],[19,0,19,3]]}
[null,"WhatsApp Blaster",null,null,null,null,"SelectionDropDown","Type","MultiplicatorValues","lstSendingMethod","list_date_format","list_date_format_examples"]
[null,null,null,null,null,null,null,null,2,"Default","m/d/yyyy","1/27/2024"]
[null,"General",null,null,null,null,"X","Media",3,"Screen Lock Compatible","d/m/yyyy","27/1/2024"]
[null,"License Key:",null,"       Required",null,null,null,"Document",4,null,"yyyy-mm-dd","2024-01-27"]
[null,"Keep Login Credentials (avoid scanning the QR code):","Yes",null,null,null,null,"Text",5,null,"d-mmm-yyyy","27-Jan-2024"]
[null,"Use Default Chrome Installation:","Yes","       Set It Up",null,null,null,null,6,null,"mmmm d, yyyy","January 27, 2024"]
[null,"Custom Chrome Path:",null,null,null,null,null,null,7,null,"ddd, mmm d, yyyy","Sun, Jan 27, 2024"]
[null,"Sending Method:","Default",null,null,null,null,null,8,null,"mm-dd-yyyy","01-27-2024"]
[null,null,null,null,null,null,null,null,9,null,"d-mmm-yy","27-Jan-24"]
[null,"Delay Times",null,null,null,null,null,null,10,null,"yyyy/mm/dd","2024/01/27"]
[null,"Default Delay Time (in milliseconds):",4000,null,null,null,null,null,11,null,"dd mmmm yyyy","27 January 2024"]
[null,"Random Delay Time Between Messages:","Yes",null,null,null,null,null,12]
[null,"Min Delay (in milliseconds):",1000,null,null,null,null,null,13]
[null,"Max Delay (in milliseconds):",2000,null,null,null,null,null,14]
[null,"Delay Time For Sending Attachments (in milliseconds):",2000,null,null,null,null,null,15]
[null,null,"1000 milliseconds = 1 second",null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,19]
["All Rights Reserved | Do Not Redistribute | Visit pythonandvba.com for more tools and resources",null,null,null,null,null,null,null,20]

{"sheet":"BOT","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Send to unsaved recipient?","Number","Text","Type","Media/Document Caption\n[OPTIONAL]","Status"]
[null,null,"+6999999999999","Check out the documentation here: https://pythonandvba.com/go/whatsappblaster-message-details-documentation","Text"]
[null,null,"+6999999999999","C:\\Users\\Username\\Desktop\\image(1).jpg;C:\\Users\\Username\\Desktop\\image(2).jpg","Media","I am a caption 🎉"]
[null,null,"+6999999999999","C:\\Users\\Username\\Desktop\\example_document.pdf","Document"]
[null,null,"+6999999999999","To insert a line break, use the pipe character | This is the second paragraph","Text"]
[null,null,"+6999999999999","You can also send a *bold text* by wrapping your text with asterisks (*)","Text"]
[null,null,"+6999999999999","You can also send a ~strikethrough text~ by wrapping your text with tildes (~)","Text"]
[null,null,"+6999999999999","You can also send an _italic text_ by wrapping your text with underscores (_)","Text"]
[null,null,"+6999999999999","You can also use {{placeholders}} in your messages or captions. See the 'Placeholders' sheet for more details.","Text"]
[null,null,"+6999999999999","If you don’t have a recipient’s name, you can still greet them by using a fallback placeholder like:\n“Hi {{name|there}}!”\nIf no name is defined, it becomes “Hi there!”","Text"]
[null,null,"+6999999999999","Hi there! 😊🎉 Use emojis by pressing Win + . (dot) on Windows!","Text"]
[null,null,"+6999999999999","To vary your messages, use spintext like this:\n“[[Hello|Hi|Hey]] {{name|there}}, [[thanks for being a customer|we appreciate your business]]!”\nOne option from each [[...|...]] block is chosen randomly.","Text"]
[null,"X","+4912369874614","Line 1 punctuation: #$%^&*()[]{}:; ' \" ?|Line 2 in Arabic: السلام عليكم ورحمة الله وبركاته|Line 3 in Chinese + Lantern + Trophy: 你好，世界! 🏮 🏆|Line 4 in Japanese + Cherry Blossom: こんにちは世界 🌸|Line 5 in Hebrew: שלום עולם!|Line 6 in Russian: Привет, мир!|Line 7 in Greek: Γεια σου Κόσμε!|Line 8 random emojis: 🤯🦄🤖🍕🔥🚀🌀|Line 9 special math chars: ∑ ∆ ∞ ± ≠ ≈ √ ∫|Line 10 accented letters: Å, æ, ß, Ñ, ü, Ø","Text"]

{"sheet":"Example_Data","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Send to unsaved recipient?","Number","Text","Type","Media/Document Caption\n[OPTIONAL]","Status"]
[null,"+6999999999999","Check out the documentation here: https://pythonandvba.com/go/whatsappblaster-message-details-documentation","Text"]
[null,"+6999999999999","C:\\Users\\Username\\Desktop\\image(1).jpg;C:\\Users\\Username\\Desktop\\image(2).jpg","Media","I am a caption 🎉"]
[null,"+6999999999999","C:\\Users\\Username\\Desktop\\example_document.pdf","Document"]
[null,"+6999999999999","To insert a line break, use the pipe character | This is the second paragraph","Text"]
[null,"+6999999999999","You can also send a *bold text* by wrapping your text with asterisks (*)","Text"]
[null,"+6999999999999","You can also send a ~strikethrough text~ by wrapping your text with tildes (~)","Text"]
[null,"+6999999999999","You can also send an _italic text_ by wrapping your text with underscores (_)","Text"]
[null,"+6999999999999","You can also use {{placeholders}} in your messages or captions. See the 'Placeholders' sheet for more details.","Text"]
[null,"+6999999999999","If you don’t have a recipient’s name, you can still greet them by using a fallback placeholder like:\n“Hi {{name|there}}!”\nIf no name is defined, it becomes “Hi there!”","Text"]
[null,"+6999999999999","Hi there! 😊🎉 Use emojis by pressing Win + . (dot) on Windows!","Text"]
[null,"+6999999999999","To vary your messages, use spintext like this:\n“[[Hello|Hi|Hey]] {{name|there}}, [[thanks for being a customer|we appreciate your business]]!”\nOne option from each [[...|...]] block is chosen randomly.","Text"]
["X","+4912369874614","Line 1 punctuation: #$%^&*()[]{}:; ' \" ?|Line 2 in Arabic: السلام عليكم ورحمة الله وبركاته|Line 3 in Chinese + Lantern + Trophy: 你好，世界! 🏮 🏆|Line 4 in Japanese + Cherry Blossom: こんにちは世界 🌸|Line 5 in Hebrew: שלום עולם!|Line 6 in Russian: Привет, мир!|Line 7 in Greek: Γεια σου Κόσμε!|Line 8 random emojis: 🤯🦄🤖🍕🔥🚀🌀|Line 9 special math chars: ∑ ∆ ∞ ± ≠ ≈ √ ∫|Line 10 accented letters: Å, æ, ß, Ñ, ü, Ø","Text"]

{"sheet":"Placeholders","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4],[4,1,4,2]]}
[]
[null,"Placeholders"]
[null,"Placeholders let you automatically insert details into your messages.\n1. Number-Specific Placeholders\nThese change for each phone number. For example, if you use {{name}} and assign \"Alice\" for one number and \"Bob\" for another, each message will show the correct name.\n2. Global Placeholders\nThese are the same for every message. For example, if you set {{business_name}} to \"Sunshine Bakery,\" every message will show that name.\n3. Fallback Text\nYou can add a default value using a pipe (|). For example, {{name|friend}} will show the customer name if available. If not, it will use \"friend.\"\nTip: Use Test Mode to check your messages before sending them to real recipients."]
[]
[null,"Date Formatting:"]
[null,"Placeholder Date Format:","d-mmm-yyyy"]
[null,"Date Format Example:",{"$f":"IFERROR(VLOOKUP(DATE_FORMAT,tbl_date_formats[#Data],2,FALSE),\"Date format not found\")","v":"27-Jan-2024"}]
[]
[null,"Placeholder Type","Receiver Number (for number-specific only)","Placeholder_Tag_1","Value_1","Placeholder_Tag_2","Value_2","Placeholder_Tag_3","Value_3","Placeholder_Tag_4","Value_4","Placeholder_Tag_5","Value_5","Validation"]
[null,"global",null,"{{sender_name}}","Sven","{{website}}","www.pythonandvba.com",null,null,null,null,null,null,"OK"]
[null,"number-specific","+49123456789","{{name}}","Michael Johnson","{{appointment_date}}","2025-04-07","{{reference}}","REF-12345",null,null,null,null,"OK"]
[null,"number-specific","+4987654321","{{name}}","Sarah Williams","{{appointment_date}}","2025-04-08","{{reference}}","REF-67890",null,null,null,null,"OK"]

{"sheet":"Phonenumber_Validator","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,2],[1,3,1,6]]}
[null,"Phone Number Formatter & Validator"]
[null,"This tool prepares your phone numbers for WhatsApp messaging: \n• Formats numbers to international standard (E.164) \n• Validates numbers to ensure they can receive messages \n• Shows country, type and timezone information \n",null,"How to use: \n1. Enter numbers in the \"Input\" column \n2. Select default country (for numbers without country code) \n3. Click \"Format & Validate\""]
[null,"Settings:"]
[null,"Default Region:","United States"]
[]
[null,"Input","Output","Valid","Status","Country","Type","Timezone"]
[null,"(212) 555-1234"]
[null,"415-555-6789"]
[null,"8005551212"]
[null,"+1 (305) 555-7890"]
[null,"1-800-555-0199"]
[null,"+44 7700 900123"]
[null,"+33 1 23 45 67 89"]
[null,"+49 30 1234567"]
[null,"020 7946 0958"]
[null,"6175550123"]

{"sheet":"Phonenumber_Replicator","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2]]}
[]
[null,"Phone Number Replicator"]
[null,"This tool helps you replicate phone numbers in a table. Simply input the phone numbers, specify how many times each number should be replicated, and generate the output list. This is helpful if you need to send texts, media, or documents to multiple contacts, making it quick and easy to prepare your list."]
[null,"Settings:"]
[null,"Choose how many times to replicate each number:",2]
[]
[null,"Input","Output"]
[null,"+12125551234"]
[null,"+14155556789"]
[null,"+18005551212"]
[null,"+13055557890"]

{"sheet":"Backend_Settings","index":6,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Retrieve latest XPaths:",true]
["XPath Version:","Version_A"]
["Connection Mode:","WinHTTP"]
["When pasting, keep original cell format:",true]
["Chrome User Data Folder:","D:\\YT_Tutorials\\00_Digital_Products\\03_WhatsApp_Blaster\\02_WhatsApp_Blaster_PRO_Version\\0_Releases\\v1.0\\ChromeUserData"]
[]
["Last Xpath Retrieved:","2025-08-24T17:53:52"]
["XPathName","XPathValue","Version","LastUpdated"]
["xPathInvalidPhoneNumber","//*[@id='app']/div/span[2]/div/span/div/div/div/div/div/div[2]/div/button","Version_A","2024-10-04"]
["xPathTextInputField","//*[@id='main']/footer/div[1]/div/span/div/div[2]/div[1]/div/div[1]/p","Version_A","2024-10-04"]
["xPathSearchInputField","//*[@id='side']/div[1]/div/div[2]/div/div/div/p","Version_A","2025-02-28"]
["xPathNoContactFound","//*[@id='pane-side']/div[1]/div/span","Version_A","2024-10-04"]
["xPathAttachmentButton","//span[@data-icon='plus-rounded']","Version_A","2025-04-07"]
["CSSClassModalPopup","[data-animate-modal-popup]","Version_A","2024-11-11"]
["xPathMultipleAttachmentButton","//span[@data-icon='plus']","Version_A","2025-01-05"]
["xPathDocumentAttachmentButton","//span[contains(text(), 'Document')]","Version_A","2025-01-26"]
["xPathMediaAttachmentButton","//span[contains(text(), 'Photos & videos')]","Version_A","2025-01-26"]

{"sheet":"CountryCodes","index":7,"n_rows":243,"n_cols":4,"rows_kept":243,"cut":false,"hidden":true,"merged":[]}
["CountryName","CountryCode",null,"TrueFalse"]
["United States","US",null,true]
["Canada","CA",null,false]
["France","FR"]
["Spain","ES"]
["Italy","IT"]
["United Kingdom","GB"]
["Germany","DE"]
["Australia","AU"]
["New Zealand","NZ"]
["India","IN"]
["Grenada","GD"]
["American Samoa","AS"]
["Antigua and Barbuda","AG"]
["Anguilla","AI"]
["Barbados","BB"]
["Turks and Caicos Islands","TC"]
["Bahamas","BS"]
["Northern Mariana Islands","MP"]
["Trinidad and Tobago","TT"]
["Cayman Islands","KY"]
["Virgin Islands, British","VG"]
["Saint Vincent and the Grenadines","VC"]
["Saint Lucia","LC"]
["Guam","GU"]
["Virgin Islands, U.S.","VI"]
["Saint Kitts and Nevis","KN"]
["Montserrat","MS"]
["Dominica","DM"]
["Dominican Republic","DO"]
["Jamaica","JM"]
["Sint Maarten (Dutch part)","SX"]
["Bermuda","BM"]
["Puerto Rico","PR"]
["Russian Federation","RU"]
["Kazakhstan","KZ"]
["Egypt","EG"]
["South Africa","ZA"]
["Greece","GR"]
["Netherlands","NL"]
["Belgium","BE"]
["Hungary","HU"]
["Holy See (Vatican City State)","VA"]
["Romania","RO"]
["Switzerland","CH"]
["Austria","AT"]
["Guernsey","GG"]
["Jersey","JE"]
["Isle of Man","IM"]
["Denmark","DK"]
["Sweden","SE"]
["Svalbard and Jan Mayen","SJ"]
["Norway","NO"]
["Poland","PL"]
["Peru","PE"]
["Mexico","MX"]
["Cuba","CU"]
["Argentina","AR"]
["Brazil","BR"]
["Chile","CL"]
["Colombia","CO"]
["Venezuela, Bolivarian Republic of","VE"]
["Malaysia","MY"]
["Cocos (Keeling) Islands","CC"]
["Christmas Island","CX"]
["Indonesia","ID"]
["Philippines","PH"]
["Singapore","SG"]
["Thailand","TH"]
["Japan","JP"]
["Korea, Republic of","KR"]
["Viet Nam","VN"]
["China","CN"]
["Türkiye","TR"]
["Pakistan","PK"]
["Afghanistan","AF"]
["Sri Lanka","LK"]
["Myanmar","MM"]
["Iran, Islamic Republic of","IR"]
["South Sudan","SS"]
["Western Sahara","EH"]
["Morocco","MA"]
["Algeria","DZ"]
["Tunisia","TN"]
["Libya","LY"]
["Gambia","GM"]
["Senegal","SN"]
["Mauritania","MR"]
["Mali","ML"]
["Guinea","GN"]
["Côte d'Ivoire","CI"]
["Burkina Faso","BF"]
["Niger","NE"]
["Togo","TG"]
["Benin","BJ"]
["Mauritius","MU"]
["Liberia","LR"]
["Sierra Leone","SL"]
["Ghana","GH"]
["Nigeria","NG"]
["Chad","TD"]
["Central African Republic","CF"]
["Cameroon","CM"]
["Cabo Verde","CV"]
["Sao Tome and Principe","ST"]
["Equatorial Guinea","GQ"]
["Gabon","GA"]
["Congo","CG"]
["Congo, The Democratic Republic of the","CD"]
["Angola","AO"]
["Guinea-Bissau","GW"]
["British Indian Ocean Territory","IO"]
["Seychelles","SC"]
["Sudan","SD"]
["Rwanda","RW"]
["Ethiopia","ET"]
["Somalia","SO"]
["Djibouti","DJ"]
["Kenya","KE"]
["Tanzania, United Republic of","TZ"]
["Uganda","UG"]
["Burundi","BI"]
["Mozambique","MZ"]
["Zambia","ZM"]
["Madagascar","MG"]
["Mayotte","YT"]
["Réunion","RE"]
["Zimbabwe","ZW"]
["Namibia","NA"]
["Malawi","MW"]
["Lesotho","LS"]
["Botswana","BW"]
["Eswatini","SZ"]
["Comoros","KM"]
["Saint Helena, Ascension and Tristan da Cunha","SH"]
["Eritrea","ER"]
["Aruba","AW"]
["Faroe Islands","FO"]
["Greenland","GL"]
["Gibraltar","GI"]
["Portugal","PT"]
["Luxembourg","LU"]
["Ireland","IE"]
["Iceland","IS"]
["Albania","AL"]
["Malta","MT"]
["Cyprus","CY"]
["Åland Islands","AX"]
["Finland","FI"]
["Bulgaria","BG"]
["Lithuania","LT"]
["Latvia","LV"]
["Estonia","EE"]
["Moldova, Republic of","MD"]
["Armenia","AM"]
["Belarus","BY"]
["Andorra","AD"]
["Monaco","MC"]
["San Marino","SM"]
["Ukraine","UA"]
["Serbia","RS"]
["Montenegro","ME"]
["Croatia","HR"]
["Slovenia","SI"]
["Bosnia and Herzegovina","BA"]
["North Macedonia","MK"]
["Czechia","CZ"]
["Slovakia","SK"]
["Liechtenstein","LI"]
["Falkland Islands (Malvinas)","FK"]
["Belize","BZ"]
["Guatemala","GT"]
["El Salvador","SV"]
["Honduras","HN"]
["Nicaragua","NI"]
["Costa Rica","CR"]
["Panama","PA"]
["Saint Pierre and Miquelon","PM"]
["Haiti","HT"]
["Guadeloupe","GP"]
["Saint Barthélemy","BL"]
["Saint Martin (French part)","MF"]
["Bolivia, Plurinational State of","BO"]
["Guyana","GY"]
["Ecuador","EC"]
["French Guiana","GF"]
["Paraguay","PY"]
["Martinique","MQ"]
["Suriname","SR"]
["Uruguay","UY"]
["Curaçao","CW"]
["Bonaire, Sint Eustatius and Saba","BQ"]
["Timor-Leste","TL"]
["Norfolk Island","NF"]
["Brunei Darussalam","BN"]
["Nauru","NR"]
["Papua New Guinea","PG"]
["Tonga","TO"]
["Solomon Islands","SB"]
["Vanuatu","VU"]
["Fiji","FJ"]
["Palau","PW"]
["Wallis and Futuna","WF"]
["Cook Islands","CK"]
["Niue","NU"]
["Samoa","WS"]
["Kiribati","KI"]
["New Caledonia","NC"]
["Tuvalu","TV"]
["French Polynesia","PF"]
["Tokelau","TK"]
["Micronesia, Federated States of","FM"]
["Marshall Islands","MH"]
["Korea, Democratic People's Republic of","KP"]
["Hong Kong","HK"]
["Macao","MO"]
["Cambodia","KH"]
["Lao People's Democratic Republic","LA"]
["Bangladesh","BD"]
["Taiwan, Province of China","TW"]
["Maldives","MV"]
["Lebanon","LB"]
["Jordan","JO"]
["Syrian Arab Republic","SY"]
["Iraq","IQ"]
["Kuwait","KW"]
["Saudi Arabia","SA"]
["Yemen","YE"]
["Oman","OM"]
["Palestine, State of","PS"]
["United Arab Emirates","AE"]
["Israel","IL"]
["Bahrain","BH"]
["Qatar","QA"]
["Bhutan","BT"]
["Mongolia","MN"]
["Nepal","NP"]
["Tajikistan","TJ"]
["Turkmenistan","TM"]
["Azerbaijan","AZ"]
["Georgia","GE"]
["Kyrgyzstan","KG"]
["Uzbekistan","UZ"]