Want to analyse your tweets? How to import Twitter JSON data exports into Excel

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?