title: How to write JSON **text** to Excel file?
body: <p>Is there any way in Python to write JSON <strong>text</strong> to an Excel file?</p>
  
  <p>Normally I would load JSON response into Pandas dataframe and write the dataframe to Excel:</p>
  
  <pre><code>import pandas
  form pandas.io.json import json_normalize
  import requests
  
  def df_to_excel(df, filename):
      writer = pandas.ExcelWriter(filename)
      df.to_excel(writer, 'Sheet1')
      writer.save()
  
  response = requests.get(url, params).json()
  df = json_normalize(response)
  df_to_excel(df, 'Response.xlsx')
  </code></pre>
  
  <p>But this requires converting JSON text to Python object, thus replacing <code>"</code> with <code>'</code>, <code>false</code> with <code>False</code>, <code>null</code> with <code>None</code> etc, and I don't want that.</p>