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.

As I noted in an earlier column, JSON is great for moving data around but not so hot when you need to convert it into data stored in a relational database.In that earlier column, I looked at why you ...