I have a text file in json format and want to read it into Excel. A very simplified example of the json file has the following structure:
{ [
{ 'a': 10, 'b': 20 },
{ 'a': 20, 'b': 22 },
{ 'a': 11, 'b': 24 }
] }
I want to convert it to Excel in which each record becomes a row in excel with the selected parameters as the column headers.