title: How do you import a json file to excel with tree-references?
body: <p>I have a .json file that has around 8 Megabyte of data, containing multiple HashSets from Powershell with the Command:</p>
  
  <pre><code>$Hashset = @{"ChildHashset" = @{"ChildOfChildHashset" = @{...} ,... }, ...}
  
  $Hashset | Convertto-Json | out-file "C:\...\file.json"
  </code></pre>
  
  <p>I want to work with the Json-File in Excel, so I Need the Parent-Level to be in a seperate Table, as the Child-Level.</p>
  
  <p>As I tried to Import the .json file, The Values of the Hashset-Names were [Record] without a reference.
  Additionally I had to manually click on every record, Excel has shown, to generate a Table from it.</p>
  
  <p>Is there a Method to simple Input the .Json-File, and generate multiple Excel-Tables with designated Name &amp; Reference to previous Data-Value?</p>
  
  <p>Thanks in advance.</p>