'Common Parameters' 'Splatting Conditionally' 'Case Sensitivity' 'Loops' 'Ordered Items' 'Complex Keys' 'Commands with Hashtables' 'Group-Object' 'Select-Object' 'ConvertTo-Json' 'ConvertFrom-Json' 'Casting to Objects' 'PSCustomObject' 'Other Types' 'Conclusion') | HowAt...
You can easily convert JSON files to Excel files (.xlsx) using Excel’s ‘Get & Transform’ tool (Power Query). Initially, it was called ‘Data Explorer’, then it was renamed to ‘Power Query’. Power Query is only available in 2010 and 2013 versions of Excel. In Microsoft Excel 2016...