# 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