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.

The task of converting JSON to an Excel CSV file won’t take a long time. We suspect it can take less than a minute if you move fast enough and have the relevant knowledge. From the standard import ...

Breakthroughs, discoveries, and DIY tips sent every weekday. Terms of Service and Privacy Policy. Listen, unless you’re an expert, spreadsheets can be daunting. You ...