SHARE
TWEET

Untitled

a guest Aug 24th, 2019 82 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Import JSON to Excel
  2.  
  3. ## assets
  4.  
  5. Example json file with a list of items - productlist.json
  6.  
  7. ## Steps
  8.  
  9. 1. Open New workbook in Excel 2016
  10. 2. Go to **Data** tab
  11. 3. Select **New Query**
  12. 4. Go to **From Other Sources** and select **Blank Query**
  13. 5. Open **Advanced Editor** and replace the double quotes **""** with `Json.Document(File.Contents("C:\Users\elephantatech\Documents\productlist.json"))`
  14.   the query should now show the following
  15.   ```
  16.   let
  17.     Source = Json.Document(File.Contents("C:\Users\vivek.mistry\Documents\users.json"))
  18.   in
  19.     Source
  20.   ```
  21.  6. from the tranform tab Select totable
  22.  7. on the table column title click on the icon to expance the column
  23.  8. click on Close and load
  24.  
  25.  you should now see a table loaded from the json file
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top