title: Is there a way to import a bunch of JSON files into Excel
body: <p>I have about a hundred JSON files of data that I would like to be able to manipulate in Excel. The reason why there are so many files is that the API I pulled from limits responses to 50 items per request, so I chained 100 requests together in Postman and each request generated its own file.</p>
  
  <p>The layout of each file is as follows:</p>
  
  <pre><code>{
    "href": "dsjdsjds.com",
    "total": 4293,
    "next": "sdsadsads.com",
    "prev": "dsjdjsdj.com",
    "limit": 50,
    "offset": 50,
    "itemSummaries": [...]
  }
  </code></pre>
  
  <p>Pretty much all of the data that I want lies inside the <code>itemSummaries</code> class.</p>
  
  <p>I'm pretty new to this and not sure if the optimal way would be to use a Python script, or if there was a way to use VBA or something. I was thinking that I'd need to combine all of the data into a single file first, but I don't know how to do that either. I appreciate the help!</p>