title: Pandas json_normalize function doesn't export to excel file correctly
body: <p>I am using the json_normalize function but it's not correctly exporting JSON to the excel file you can see below.
  <a href="https://i.stack.imgur.com/7279W.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7279W.png" alt="enter image description here" /></a></p>
  <p>Here is my code:</p>
  <pre><code>import requests
  import pandas as pd
  
  urls = [
      'https://www.cbr.nl/web/show?id=289168&amp;langid=43&amp;channel=json&amp;cachetimeout=-1&amp;elementHolder=289170&amp;ssiObjectClassName=nl.gx.webmanager.cms.layout.PagePart&amp;ssiObjectId=285674&amp;contentid=11764&amp;examtype=B', 
  ]
  for url in urls:
      r = requests.get(url=url).json()
      print(r)
      jn = pd.json_normalize(r)
      df = pd.DataFrame(jn)
      df.to_excel('data.xlsx')
  </code></pre>