It is made up of only two data types – objects or arrays, or a combination of both. Objects are key-value pairs with a colon between them and arrays are simply collections of objects separated by a comma. To edit a JSON file in Excel, you need to import the file in Excel first. You …