We can use the Split column function ... 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.