How to Export WhatsApp Chat History to Excel using Python 📲 (fast & easy) | Android only
ฝัง
- เผยแพร่เมื่อ 15 พ.ย. 2024
- 👉 Explore All My Excel Solutions: pythonandvba.c...
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Would you like to export your WhatsApp Chat History & Messages to Excel?
I will show you, how you can easily do this by using Python & the Pushbullet API. Pushbullet is a free service and helps you to connect your smartphone with your computer.
Python Code and Jupyter Notebook:
👉 GitHub: github.com/Sve...
Further Links:
Pushbullet: www.pushbullet...
Pushbullet Python Library: pypi.org/proje...
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.c...
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.c...
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.c...
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.c...
📑 Excel Templates: pythonandvba.c...
🎓 My Courses: pythonandvba.c...
📚 Books, Tools, and More: pythonandvba.c...
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sve...
💬 Discord: pythonandvba.c...
📬 Contact: pythonandvba.c...
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: pythonandvba.c...
*I have also created a simple web app to convert your chat history text file to CSV:*
1) Upload your chat history .txt file to the web app
2) Download the generated CSV File
Here is the link to the web app: share.streamlit.io/sven-bo/streamlit-export-whatsappchat-to.csv/app.py
Thanks you dude
It’s not working😢 File "/app/streamlit-export-whatsappchat-to.csv/app.py", line 63, in
new = cleaned_data[-1][-1] + " " + line
@@leochung9836 Is that the error message you got from the web app?
Yes I did ..thanks a lot .
I have a problem with this, can you help me? I import my chat history from whatsapp wep to my computer and when I run the code or load to your web page I get the same error
Just like pearls are found in the ocean, I have found this video in the ocean of this TH-cam.
*Thank you.* I am glad you enjoyed the video 😃
As always really helpful things come out from this channel
Thank you very much 😃
I Don't f*cking know why this cool man don't get f*cking subs.
Thanks buddy! 🙏
hey i love your content. i do have a follow up question; my text comes together with media. how can i keep the media matched to the text together in the excel sheet. thanks
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thank you so much! Coincidentally, this is exactly what I was searching for :)
Glad you liked it! Thanks for watching the video & your comment! 😀
Great content as always.
Thank you for all your support. I greatly appreciate it 🙏
Thanks for your video and i have a question can we also export text messages with images?
Thanks for watching. No, that is not possible with this solution
Is there any risk of data loss incase of any sort of python error? also does it have a number of chat limit?
So far, I have not encountered any issues. That said, I cannot promise that you might run into problems.
Hi !!can u please help in this... how can I export or transfer WhatsApp chat into Excel or Google sheet without vba or easier way
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Thank You. Is it possible to write a python code which sends tweet data from a particular account directly to whatsapp. For example: A news account keep tweeting live news related to oil and i want that tweet/news in my whatsapp as soon as it is tweeted
Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!
hello, great video.
I have a question, is it possible to export to excel all whatsapp conversations with their status, sent, received and read?
Thanks for watching the video. As far as I know, this is not easily doable. In the export of the WA chat (.txt) file, there is no status indication included.
thank u so much bro u saved my time love u❣
An absolute pleasure, very happy to hear that you found it useful!
Thank you very much! Is there a way to perform this operation on multiple messages? My need is to create an excel sheet containing columns for phone number of the message and some cleansed data from the chat.
I am not aware that it is possible to export multiple chats at once
Hey do you find any solution!?
Sir is it possible to automate this, like instead of manual exporting, it could export once a day automatically
Sorry, but I do not know how to run this automatically daily.
Thanks a lot for the video and the web app
Thank you for watching the video and taking the time to leave a comment!
hey thats prety well working but i have some more idea to it well working with data.
*Hello Y0UTUB & TUBU, thanks for watching the video and your comment.*
Can we please work on your idea
Is there any code to automatically copying incoming certain whatsapp messages to another program like excel or word?
Thanks for watching! I'm not sure if there's existing code for what you need, but you'll probably need the WhatsApp API to make it happen. Good luck with your project and have fun coding!
not able to download the app on iphone, is there any alternative way to do it??
Pushbullet stopped the support for iOS. I do not know an alternative, but I have changed the video title now.
How can I export chat in HTML to access the media in the chat with 1 click?
Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet for a solution. Sorry that I cannot help!
Thank you for sharing such a great video..
Can we automate the whole process using only Excel VBA?
Thanks for watching the video. The transformation would also be possible with VBA, but I am not planning to do it.
Instead, I took the current script and built a small web app. Perhaps it might be easier for you:
waconverter.herokuapp.com/
Looking forward to your thoughts.
Thanks!
hola tengo problemas con la url esa parte me sale error como lo soluciono muchas gracias desde Perú
*Gracias por ver mi video*
What does the error message say?
Why register to pushbullet and not simply save the TXT file from WhatsApp to Google drive and download it to your computer from there?
Thanks for watching. Whatever works for you :)
When a new WhatsApp message arrives anyway to automatically send to excel or to Outlook?
Thanks for watching the video. No, that is not possible. I am not sure if it would be possible with a paid WhatsApp API.
@@CodingIsFun thank you!
I have one query; as a profession I'm a Realtor so I have lots of groups of Teams and colleuges they post there tequiments but lots of messages so we missed that msg
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Thank you for this video the issue is when we are trying to download as excel file the message got merging into some cells (into time column) can you help me in that or anyone?
Sorry, I cannot help here
@@CodingIsFun tell me the platform to communicate with you
Can you please help me that how to automate this procedure and pushbullet automatically get that chats and all the process works automatically
As far as I know, there is no direct WhatsApp API to get the Chat History via code. Therefore, I can only offer this semi-automated approach. Thanks!
@@CodingIsFun thanks for your response
Can you please help me that how can i save excel file with different name everytime i run
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
@@CodingIsFun thankyou so much😇
Can you please help me with like if i run the code it export all the file not only the latest one and append it with the chat name not chat.txt or chat_history please help me
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
how to convert only a few messages from whatsapp? Export the messages into a database like csv
You could exclude / filter rows in your pandas dataframe and export it to a CSV file pd.to_csv('filename.csv')
Anyone can help me? When i run it, it says no module named pandas but i already installed it. Please help me
Thanks for watching. Please ensure that you are running the code in the same environment in which you installed the package. Cheers, Sven ✌️
What can i do to export all my chats at once
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
How to automate process?
The textfile export from WhatsApp might be hard to automate, as you need to use the Mobile App for this.
Once you have exported it, you could:
a) save the files locally in one directory and convert all files to Excel at once
b) push the files to Pushbullet/Google Cloud and schedule a script on a server (e.g. using AWS, PythonAnywhere, ...) to convert the files
Those are just two examples, whereas option a) would be the easiest, but it would be rather semi-automated.
how to take whats app data to excell file
if
mob no is not save . And customer has provided his name, education, city, etc,
but
they are not in proper manner . For eg : he has given city name first, and name in middle so how to create python code for that
please guide me #Respect
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
I'm getting an error in the import process, "No module named pushbullet". can you please help
You need to install pudhbullet as shown in the video: 2:30 min
pip install pudhbullet.py
How to make all this process into one product with push bullet
With custom code 😅
@@CodingIsFun i am newbie Will you helpout with this project of autoscrubing whatsapp with or without push bullet
hey thanks man but the whatsapp inbuilt export option has some disadvantages. The messages that can be exported is 40,000. is there any way around using whatsapp web?
Thanks for watching the video.
Sorry, I do not have any other solution 😕
@@CodingIsFun yeah it's ok man.
Hello! Did you find some solution? I'm searching for a few days ago, but i cant search anythinf...
@@luisguilherme7889 unfortunately there are no direct solution available at the moment. I am also searching for a solution.
@@arunraj_r anything? :(
Can you do the same thing with iMessages but automatically when someone send messages it will send it to excel
*Hello Dhruv Shah, thanks for watching the video and your comment.*
I do like the video idea, yet I do have an iPhone and I am not sure if Apple provides a webhook/service to trigger the event (export to Excel). Sorry 😌
@@CodingIsFun Tanks and no problem
Does it work on viber?
No, this is for WhatsApp
Can you please open source the web app code, it will be really helpful
Thanks for watching. Here you are: github.com/Sven-Bo/streamlit-export-whatsappchat-to.csv/blob/master/app.py
Cheers, Sven ✌️
@@CodingIsFun Thank you 😀
@@CodingIsFun I'm also working on a similar toy project but it use JS parser to parse chat and store in postgresql. Your parser logic will be helpful. Specially to identify old message
Why there is error returned as Pushbullet is not defined? help please
Thanks for watching the video. Did you install the library by typing 'pip install pushbullet.py' in your command or terminal?
What about media ?
That is not possible with my solution.
Hello, can i export a chat more than 40k messages?
Hi Ronald,
*Thanks for watching the video & your question.*
Frankly speaking, I have never tried exporting more than 40k messages. However, theoretically it should be possible. If you encounter any issues, feel free to reach out to me.
Cheers,
Sven
@@CodingIsFun hey, thank you for responding, apparently wp doesn't let you export chats more than 40k messages, so how about in one of your next videos tell us a way to export a chat more than 40k msgs without media. Would be really helpful for alot of us since i'm not the only one wanting to do so. Thank you! 😁
Create this same video and doing this task using selenium and beautiful soup
Thank you for watching the video & your suggestion.
How do i automate it?
The textfile export from WhatsApp might be hard to automate, as you need to use the Mobile App for this.
Once you have exported it, you could:
a) save the files locally in one directory and convert all files to Excel at once
b) push the files to Pushbullet/Google Cloud and schedule a script on a server (e.g. using AWS, PythonAnywhere, ...) to convert the files
Those are just two examples, whereas option a) would be the easiest, but it would be rather semi-automated.
And what about the date?
Yes, date is also in there as you can see in minute 5:00
i want 2 download whatsup chat to pdf
*Hello Yehai Elesawy, thanks for watching the video and your comment.*
Once you have downloaded the textile from PushBullet (as shown in the video), you could convert this text file to PDF by using the fpdf library.
Here is a great tutorial on how to do this:
www.geeksforgeeks.org/convert-text-and-text-file-to-pdf-using-python/
Hope it helps 🙏
Cheers,
Sven
I need link page for backup whatsapp 1:51
github.com/Sven-Bo/WhatsApp-History-Export-Excel
Iam getting index out of error
Hey there, thanks for watching the video! I'm sorry I can't help you with your problem based on the information you provided. To give me a better idea of what's going on, it would be super helpful if you could write down which line of code is causing the error, let me know if you modified the code from the tutorial, and explain in more detail what you did to troubleshoot the problem. Don't forget to also give me some context about your setup and environment.
If you're having trouble figuring things out, another option is to join our Discord server at pyhtonandvba.com/discord. You can ask your question there and maybe someone in the community can help out.
Thanks for understanding.
I did nt find any code
Thanks for watching. Here is the link from the description box: github.com/Sven-Bo/WhatsApp-History-Export-Excel
Now push bullet has access to all my messages huh ?
At least to the one you are requesting via the API call.
NEET TO EXPORT ALL CHATS IN EXCEL
OK. HAPPY CODING!
but why.... this is useless lmfao
Thanks for your comment. As mentioned in the video, because a viewer of this channel wanted to have this kind of solution 😀