JSON is the leading data interchange format for web applications and more. Here’s what you need to know about JavaScript Object Notation.

In the Data section of the ribbon choose Get Data and in the drop down pick From File and then from JSON. The JSON will load and you'll be presented with a list of records.