New versions of Excel allow you to import JSON through PowerQuery in the Data tab on the ribbon. Works pretty well.