Skip to content

Instantly share code, notes, and snippets.

@elephantatech
Last active August 12, 2019 16:48
Show Gist options
  • Save elephantatech/f9043867f1f0715d2a56a50bd04bd046 to your computer and use it in GitHub Desktop.
Save elephantatech/f9043867f1f0715d2a56a50bd04bd046 to your computer and use it in GitHub Desktop.
Import Json file into Excel table

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
  1. from the tranform tab Select totable
  2. on the table column title click on the icon to expance the column
  3. click on Close and load

you should now see a table loaded from the json file

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment