Hi @MayAnk__Rathi
Thanks for the follow-up.
Since you're receiving 2000+ WhatsApp messages daily in a semi-structured format, here's a simple and 100%
working solution to automatically extract and populate them into Excel.
Export WhatsApp Chat (Daily). On your phone, open the WhatsApp chat → tap the 3 dots (⋮) → More → Export Chat → Without Media → Email it to yourself or save it to Google Drive. You'll get a .txt file with all the messages.
Run This Python Script to Auto-Fill Excel
- Save your exported .txt file as whatsapp_messages.txt
- Use this script (you can run it with basic Python setup):
import re, pandas as pd
with open("whatsapp_messages.txt", "r", encoding="utf-8") as f:
raw = f.read()
messages = re.split(r'_+\n|\n\n', raw)
data = []
for msg in messages:
size = re.search(r'(\d+[x/]\d+)', msg)
pantograph = re.search(r'(\d{3,4})\s*PENTO?GRAPH', msg, re.I)
rate = re.search(r'BHAV\s*[:-]\s*([^\n]+)', msg, re.I)
contact = re.search(r'\b\d{10}\b', msg)
data.append({
"Message": msg.strip(),
"Size/Model": size.group(1) if size else "",
"Pantograph": pantograph.group(1) if pantograph else "",
"Rate": rate.group(1) if rate else "",
"Contact": contact.group(0) if contact else ""})
pd.DataFrame(data).to_excel("Daily_WhatsApp_Enquiries.xlsx", index=False)
Try to automate It
- You can schedule this script to run automatically every day using Windows Task Scheduler or any automation tool.
- Or just run it after saving the .txt file daily—takes only a few seconds.
This will give you a clean Excel file with columns like:
Message | Size/Model | Pantograph | Rate | Contact
Let me know if you'd prefer a solution using Google Sheets or Power Automate instead. Happy to help further.
----------------------------------------------------------------------------------------------------------------------------
If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance.
Best regards,
Akhil 😊
