Use these free online JSON to Excel converter tools to convert JSON files to Excel format. These are the best websites to do so.

It used to be easy to analyze your Twitter data: you'd go to your settings and ask for a download, and there among all the files would be a CSV file full of your tweets and the associated metadata.