Each cell has its own number format, which you can see by selecting a cell and seeing the Number group in the Home tab on the ribbon. For some data types, such as a date or a percentage ...

As such, any empty cells containing formatting and lying outside the range of cells containing data may ... command on Excel’s Inquire tab. Go to the File tab on the Ribbon menu of your Excel ...

Excel's JSON import tools can now load the data, but you're going to have to construct a data transformation to get at the information you want. In the Data section of the ribbon choose Get Data ...