The final thing you will want to do here is to convert the JSON data to a table. Do this by clicking on Into Table , then hit Close & Load . You should now see the data from within the JSON file ...

You can then use the Detect Data Type function to convert it to a date field. We're now ready to import the original Twitter JSON into Excel. Click Close and Load.