Import Json file into Excel table

importjsontoexcel.md

Import JSON to Excel

assets

Example json file with a list of items - productlist.json

Steps

1. Open New workbook in Excel 2016
2. Go to Data tab
3. Select New Query
4. Go to From Other Sources and select Blank Query
5. Open Advanced Editor and replace the double quotes "" with Json.Document(File.Contents("C:\Users\elephantatech\Documents\productlist.json")) the query should now show the following

let
  Source = Json.Document(File.Contents("C:\Users\vivek.mistry\Documents\users.json"))
in
  Source

6. from the tranform tab Select totable
7. on the table column title click on the icon to expance the column
8. click on Close and load

you should now see a table loaded from the json file