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.

JSON files are labeled as .json. JSON has a language-independent format. JSON has a simple structure and doesn't use mathematical notation or algorithms. It is easy to understand, even by users with ...