Twitter Archive Utility: Convert JSON to CSV Format
Twitter allows you to download an archive of all your tweets for the current year. You can request to download it from Twitter via the following menu:
More >> Settings and Support >> Your Account >> Download an archive of your data
Once you request a download, it takes a few hours to days. You will then be able to download a ZIP archive of all your Twitter data that they allow you to download.
To use your Twitter data, such as your tweets or replies, or retweets in CPROMPT or with ChatGPT directly, you need to convert a file called tweets.js (a JSON file) to a Comma Separated Value (CSV) file that you can include in prompts via CPROMPT.
To create a CSV from your tweets.js, do the following:
The CSV file we create for you has fields:
Once you have the CSV file, you can use it in prompt apps to perform whatever analysis, summarization, etc., you wish to do via prompt apps on this site.