How to convert json to xls using powershell?

Question

PowerShell

Hello! I have a json file like this:
[
{
"_p": [
1
],
"currency_code": "1",
"est_date": "2",
"date": "3",
},
{
"_p": [
1
],
"currency_code": "5",
"est_date": "6",
"date": "7",
}] etc.
the command (Get-Content C:\test\test.json) beautifully displays the necessary data, but I can’t figure out which operator can upload them to a common spreadsheet in Excel, I
tried using ConvertTo-CSV , but in the end, the structure collapses and the value of the entire line is written to one cell. Tell me where to dig?

Answer 1

https://docs.microsoft.com/en-us/powershell/module...