Convert json to csv

Not sure whether this is something that I should be asking you to advise on so please don't hesitate to tell me to go forth and multiply!!!

Anyway, here goes. I have extracted a load of electricity consumption stats via API and produced a response that is json. The data consists of half-hourly timestamps in Unix format together with the usage. Eg [1646092800, 0.122], [1646094600, 0.089]

How should I proceed to enter this data into an Excel spreadsheet to show the timestamps in one column and the kWh in another? There are approximately 200 separate entries. I am able to do the timestamp conversion but I cannot see how to extract the json file's data into csv.

Unfortunately my json file has been rejected as an Invalid File but I will try to follow the content of John Topley's link. Onwards & Upwards as they say!

Try to add the extension .txt to your source json file or link both files on a files host website like Dropbox …

Hello
Please ignore my earlier reply of this morning.
John Topley...your link works perfectly. All I need to do now is to so convert the timestamp from Unix to summat useful and play around with the KwH figures but that I can do.

Very Many thanks.