This project facilitates the collection and analysis of conversation data from conversational AI systems. By executing the provided Python program, users will generate an Excel file containing organized chat log data.
Before using this project, you sould obtain the conversation data. There are several different method to obtain data depending on the service.
conversations.json
from ChatGPT website (settings > data control > export data)
MyActivity.json
from Google Takeout Service (https://takeout.google.com/). You can obtain the data throught 'My Activity Log' in Google Takeout. Note that you must choose the JSON option when exporting the data.
claude_chat_data.json
from Chrome extensions
- Download the folder from this project
/claude/chrome extensions
- Open the Chrome browser and enter
chrome://extensions
into the URL bar - Activate
Developer mode
in the top right and clickLoad unpacked
- Select the folder you downloaded
- Go to
claude.ai
website and login - Launch
Claude Export Conversation Data
and clickDownload JSON
on the list page (https://claude.ai/recents)
- Clone this repository
git clone https://github.com/kninami/chatgptForensics.git
- Create and activate a virtual environment (in root folder)
python -m venv venv
source venv/bin/activate
- Install dependencies using pip
pip install -r requirements.txt
python chatlog_to_excel.py /path/to/data.json