# whatsapp-converter
## Introduction
Use the whatsapp-converter to convert your exported WhatsApp chat to a CSV, XLS, XLSX or an ODS file.
1. The conversion is done locally. No data is shared with the internet!
2. The resultset is a CSV file which you can import into your favorite calculation application such as Excel or LibreOffice. You can also directly export to a spreadsheet file and do create a pivot table.
## Dependencies
If you want to install the dependencies manually, use pip. On some computers you might need to replace pip by pip3.
```shell
pip install tqdm pyexcel pyexcel-xlsxw pyexcel-ods3 xlwt
```
## Usage
Use the following command on the command line to get an overview of the available arguments.
```shell
python whatsapp-converter.py -h
```
### Convert WhatsApp TXT to CSV (Default Use Case)
The easy start is just to provide the filename of the exported WhatsApp chat. The application will process the chat and create a CSV file named *resultset.csv*.
```shell
python whatsapp-converter.py whatsapp-export.txt
```
### Convert WhatsApp to Excel XLS or XLSX
If you want to export to an Excel spreadsheet file instead, make sure to add the filename at the end, e.g. *resultset.xls*.
```shell
python whatsapp-converter.py whatsapp-export.txt resultset.xls
```
or
```shell
python whatsapp-converter.py whatsapp-export.txt resultset.xlsx
```
### Convert WhatsApp to LibreOffice ODS
If you want to export to a LibreOffice spreadsheet file, make sure to add the filename at the end, e.g. *resultset.ods*.
Please note that the export takes some time. The script did not crash.
```shell
python whatsapp-converter.py whatsapp-export.txt resultset.ods
```
Here is the list of all available options:
```shell
whatsapp-converter.py [-h] [-v] [-d] filename [resultset.csv|resultset.xls]
```
## Commandline Arguments
#### Mandatory Arguments
```shell
filename The WhatsApp file containing the exported chat
resultset Filename of the resultset, default resultset.csv. Use .csv to write a comma separated file. Use .xls to write to an Excel spreadsheet file
```
#### Optional Arguments
```shell
-h, --help show this help message and exit
-n --newline create a new line (same date and time) in the resultset for every multiline chat message
-v, --verbose increase output verbosity
-d, --debug increase output verbosity to debug
```
##### Example Newline Argument
Consider this chat exported chat message
```shell
18.05.19, 11:50:00: Alan Smith: It starts here
This is a new line
```
By default the resultset will merge the two lines.
```shell
2019-05-18 11:50|2019-05-18|11:50|Alan Smith|It starts here This is a new line
```
If you start the application with the -n argument, a new line will be added and the date and time of the multiline message taken.
```shell
2019-05-18 11:50|2019-05-18|11:50|Alan Smith|It starts here
2019-05-18 11:50|2019-05-18|11:50|Alan Smith|This is a new line
```
## Conversion from to
Each line of the dataset will be converted to structured data which can be imported into your Excel or LibreOffice sheet.
```shell
21/8/19, 11:28:51 PM: Jon Doe: Waste out of wealth 😂
21.12.16, 23:29 - Alan Smith: Like a Rolex
30.11.18, 10:57 - Nachrichten in diesem Chat sowie Anrufe sind jetzt mit Ende-zu-Ende-Verschlüsselung geschützt. Tippe für mehr Infos.
30.11.18, 10:57 - Snoopy: Hallo :)
30.11.18, 10:58 - Snoopy: Jetzt bin ich gespannt auf deine Antwort ;)
1/26/19, 00:07 - Jon Doe: Sleep well
18.05.19, 11:50:00: Alan Smith: It starts here
This is a new line
```
The resultset file looks like this. In the default configuration new lines get the same date and time stamp and sender name as the previous line:
```shell
Date and Time|Date|Time|Name|Message
2019-8-21 23:28|2019-8-21|23:28|Jon Doe|Waste out of wealth 😂
2016-12-21 23:29|2016-12-21|23:29|Alan Smith|Like a Rolex
2018-11-30 10:57|2018-11-30|10:57|Snoopy|Hallo :)
2018-11-30 10:58|2018-11-30|10:58|Snoopy|Jetzt bin ich gespannt auf deine Antwort ;)
2019-01-26 00:07|2019-01-26|00:07|Jon Doe|Sleep well
2019-05-18 11:50|2019-05-18|11:50|Alan Smith|It starts here This is a new line
```
Raw data
{
"_id": null,
"home_page": "https://github.com/sandsturm/whatsapp-converter",
"name": "whatsapp-converter",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3",
"maintainer_email": "",
"keywords": "whatsapp text converter conversion analysis",
"author": "Martin Sand",
"author_email": "marti.sand.dev@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/14/01/a390aaf02bceeef8e02989cd6c655ba73211a4d4bd99db78c3edd109d4cd/whatsapp-converter-0.6.4.tar.gz",
"platform": null,
"description": "# whatsapp-converter\n\n## Introduction\nUse the whatsapp-converter to convert your exported WhatsApp chat to a CSV, XLS, XLSX or an ODS file.\n1. The conversion is done locally. No data is shared with the internet!\n2. The resultset is a CSV file which you can import into your favorite calculation application such as Excel or LibreOffice. You can also directly export to a spreadsheet file and do create a pivot table.\n\n## Dependencies\nIf you want to install the dependencies manually, use pip. On some computers you might need to replace pip by pip3.\n```shell\npip install tqdm pyexcel pyexcel-xlsxw pyexcel-ods3 xlwt\n```\n\n## Usage\nUse the following command on the command line to get an overview of the available arguments.\n```shell\npython whatsapp-converter.py -h\n```\n\n### Convert WhatsApp TXT to CSV (Default Use Case)\nThe easy start is just to provide the filename of the exported WhatsApp chat. The application will process the chat and create a CSV file named *resultset.csv*.\n```shell\npython whatsapp-converter.py whatsapp-export.txt\n```\n\n### Convert WhatsApp to Excel XLS or XLSX\nIf you want to export to an Excel spreadsheet file instead, make sure to add the filename at the end, e.g. *resultset.xls*.\n```shell\npython whatsapp-converter.py whatsapp-export.txt resultset.xls\n```\n\nor\n\n```shell\npython whatsapp-converter.py whatsapp-export.txt resultset.xlsx\n```\n\n### Convert WhatsApp to LibreOffice ODS\nIf you want to export to a LibreOffice spreadsheet file, make sure to add the filename at the end, e.g. *resultset.ods*.\nPlease note that the export takes some time. The script did not crash.\n```shell\npython whatsapp-converter.py whatsapp-export.txt resultset.ods\n```\n\nHere is the list of all available options:\n```shell\nwhatsapp-converter.py [-h] [-v] [-d] filename [resultset.csv|resultset.xls]\n```\n\n## Commandline Arguments\n\n#### Mandatory Arguments\n```shell\nfilename The WhatsApp file containing the exported chat\nresultset Filename of the resultset, default resultset.csv. Use .csv to write a comma separated file. Use .xls to write to an Excel spreadsheet file\n```\n\n#### Optional Arguments\n```shell\n -h, --help show this help message and exit\n -n --newline create a new line (same date and time) in the resultset for every multiline chat message\n -v, --verbose increase output verbosity\n -d, --debug increase output verbosity to debug\n```\n\n##### Example Newline Argument\n\nConsider this chat exported chat message\n```shell\n18.05.19, 11:50:00: Alan Smith: It starts here\nThis is a new line\n```\n\nBy default the resultset will merge the two lines.\n```shell\n2019-05-18 11:50|2019-05-18|11:50|Alan Smith|It starts here This is a new line\n```\n\nIf you start the application with the -n argument, a new line will be added and the date and time of the multiline message taken.\n```shell\n2019-05-18 11:50|2019-05-18|11:50|Alan Smith|It starts here\n2019-05-18 11:50|2019-05-18|11:50|Alan Smith|This is a new line\n```\n\n## Conversion from to\n\nEach line of the dataset will be converted to structured data which can be imported into your Excel or LibreOffice sheet.\n```shell\n21/8/19, 11:28:51 PM: Jon Doe: Waste out of wealth \ud83d\ude02\n21.12.16, 23:29 - Alan Smith: Like a Rolex\n30.11.18, 10:57 - Nachrichten in diesem Chat sowie Anrufe sind jetzt mit Ende-zu-Ende-Verschl\u00fcsselung gesch\u00fctzt. Tippe f\u00fcr mehr Infos.\n30.11.18, 10:57 - Snoopy: Hallo :)\n30.11.18, 10:58 - Snoopy: Jetzt bin ich gespannt auf deine Antwort ;)\n1/26/19, 00:07 - Jon Doe: Sleep well\n18.05.19, 11:50:00: Alan Smith: It starts here\nThis is a new line\n```\n\nThe resultset file looks like this. In the default configuration new lines get the same date and time stamp and sender name as the previous line:\n```shell\nDate and Time|Date|Time|Name|Message\n2019-8-21 23:28|2019-8-21|23:28|Jon Doe|Waste out of wealth \ud83d\ude02\n2016-12-21 23:29|2016-12-21|23:29|Alan Smith|Like a Rolex\n2018-11-30 10:57|2018-11-30|10:57|Snoopy|Hallo :)\n2018-11-30 10:58|2018-11-30|10:58|Snoopy|Jetzt bin ich gespannt auf deine Antwort ;)\n2019-01-26 00:07|2019-01-26|00:07|Jon Doe|Sleep well\n2019-05-18 11:50|2019-05-18|11:50|Alan Smith|It starts here This is a new line\n```\n",
"bugtrack_url": null,
"license": "LICENSE.txt",
"summary": "Use whatsapp-converter to convert your exported WhatsApp chat to a CSV or XLS (Excel spreadsheet) file.",
"version": "0.6.4",
"project_urls": {
"Bug Reports": "https://github.com/sandsturm/whatsapp-converter/issues",
"Homepage": "https://github.com/sandsturm/whatsapp-converter",
"Source": "https://github.com/sandsturm/whatsapp-converter/"
},
"split_keywords": [
"whatsapp",
"text",
"converter",
"conversion",
"analysis"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "d275d2e6ce61c01abbe170fcfffcbfb928c3487efadd19ca12570f4079b62049",
"md5": "4072209b3811908834cf524b074e3889",
"sha256": "074e87aa5abfdbc616091771a83045ce5e51d2dce4ba47c466992f1816f3b1f3"
},
"downloads": -1,
"filename": "whatsapp_converter-0.6.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "4072209b3811908834cf524b074e3889",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3",
"size": 9909,
"upload_time": "2023-08-04T15:53:56",
"upload_time_iso_8601": "2023-08-04T15:53:56.893262Z",
"url": "https://files.pythonhosted.org/packages/d2/75/d2e6ce61c01abbe170fcfffcbfb928c3487efadd19ca12570f4079b62049/whatsapp_converter-0.6.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "1401a390aaf02bceeef8e02989cd6c655ba73211a4d4bd99db78c3edd109d4cd",
"md5": "d6a16b7aec9568f524686c77023ffeb2",
"sha256": "35ecb2c56faae0d4164b7cbdaddbbcaecba07606ce1a0da0f7455ce405fff196"
},
"downloads": -1,
"filename": "whatsapp-converter-0.6.4.tar.gz",
"has_sig": false,
"md5_digest": "d6a16b7aec9568f524686c77023ffeb2",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3",
"size": 9767,
"upload_time": "2023-08-04T15:53:57",
"upload_time_iso_8601": "2023-08-04T15:53:57.806642Z",
"url": "https://files.pythonhosted.org/packages/14/01/a390aaf02bceeef8e02989cd6c655ba73211a4d4bd99db78c3edd109d4cd/whatsapp-converter-0.6.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-08-04 15:53:57",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "sandsturm",
"github_project": "whatsapp-converter",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "whatsapp-converter"
}
JSON
