Json to excel using power query

by

First I would use the List Tools / Transform menu (it should be automatically selected) and click the To Table button. This will give you a single-column table with 2 rows. Then I would click the small Expand button – it will appear in the column headings, just to the right of “Column1”. Uncheck the Use original column name … option and you will get a table of 4 columns and 2 rows.

Here’s the full script I generated:

let
    Source = Json.Document(File.Contents("C:\Users\Mike.Honey\Downloads\json2.json")),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column2" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "visitors", "some_number", "value"}, {"id", "visitors", "some_number", "value"})
in
    #"Expanded Column2"

Related Contents:

  1. Parsing JSON in Excel VBA
  2. AngularJS $http-post – convert binary to excel file and download
  3. Which JSON content type do I use?
  4. What is the difference between YAML and JSON?
  5. Representing null in JSON
  6. Proper way to return JSON using node or Express
  7. .NET NewtonSoft JSON deserialize map to a different property name
  8. is there a require for json in node.js
  9. tsconfig.json: Build:No inputs were found in config file
  10. How do I initialize a TypeScript Object with a JSON-Object?
  11. Does JSON syntax allow duplicate keys in an object?
  12. Using curl POST with variables defined in bash script functions
  13. How to get key names from JSON using jq
  14. How to merge 2 JSON objects from 2 files using jq?
  15. In VS Code, disable error “Comments are not permitted in JSON”
  16. Using jq or alternative command line tools to compare JSON files
  17. converting CSV/XLS to JSON? [closed]
  18. how to parse a JSON String with jq (or other alternatives)?
  19. How to display a JSON representation and not [Object Object] on the screen
  20. How do I decode HTML entities in Swift?
  21. Get ffmpeg information in friendly way
  22. Concat 2 fields in JSON using jq
  23. How to not marshal an empty struct into JSON with Go?
  24. How to decode JSON with type convert from string to float64
  25. Is it valid to define functions in JSON results?
  26. pass JSON to HTTP POST Request
  27. JSON and dealing with unexported fields
  28. HTTP POST with Json on Body – Flutter/Dart
  29. Unmarshaling json in Go: required field?
  30. how to create insert new nodes in JsonNode?
  31. JSON omitempty With time.Time Field
  32. ASP.net MVC returning JSONP
  33. What are good CLI tools for JSON?
  34. NodeJS HttpGet to a URL with JSON response
  35. A Backbone.js Collection of multiple Model subclasses
  36. How to cryptographically hash a JSON object?
  37. One dimensional array of strings being parsed to 2d by angular resource
  38. Prettify json in powershell 3
  39. Remove double quotes from the return of a function in PostgreSQL
  40. Jmeter does not send JSON data in POST
  41. What is the difference between Spring REST service, Jersey REST service and Spring+Jersey solutions?
  42. How to use Newtonsoft.Json as default in Asp.net Core Web Api?
  43. Json Schema example for oneOf objects
  44. Add JSON serializer to every model class?
  45. Generate JSON schema from Java class
  46. How can I add Boon or Jackson JSON parsers to Android project with Gradle?
  47. golang json marshal: how to omit empty nested struct
  48. Has Json tag but not exported [duplicate]
  49. Passing UTC DateTime to Web API HttpGet Method results in local time
  50. Iterating through a JSON file PowerShell

Leave a Comment