TLDR - Telegram GDPR Export Json + search term -> Excel
Soon, I will need to apply for a spouse visa which involves proving to the government that a relationship is genuine... Sounds like a lot of work...
Figured I could perform a GPDR export from telegram, filter the JSON for messages that match certain user IDs (myself + parner) and Search terms (defined in config), then export as Excel.
This allows you to easily give a time/datestamped list of every occurence of common messages such as "good morning".
- Install Python + the following libraries: json, re, configparser, pandas, datetime, pytz (most if not all will be included with your python install by default depending on environment)
- Edit conf/config.ini accordingly. You'll need to do some ctrl+f work in the telegram results.json file to find the user IDs.
- Run the script
python3 src/tgram-gdpr-ext.py