title: Json to excel using python
body: <p>Json code:Below we have json data format which I am pulling from site using API</p>
  <pre class="lang-py prettyprint-override"><code>response={
        &quot;result&quot;: [
          {
            &quot;id&quot;: &quot;1000&quot;,
            &quot;title&quot;: &quot;Fishing Team View&quot;,
            &quot;sharedWithOrganization&quot;: True,
            &quot;ownerId&quot;: &quot;324425&quot;,
            &quot;sharedWithUsers&quot;: [&quot;1223&quot;,&quot;w2qee3&quot;],
            &quot;filters&quot;: [
              {
                &quot;field&quot;: &quot;tag5&quot;,
                &quot;comparator&quot;: &quot;==&quot;,
                &quot;value&quot;: &quot;fishing&quot;
              }
            ]
          },
          {
            &quot;id&quot;: &quot;2000&quot;,
            &quot;title&quot;: &quot;Farming Team View&quot;,
            &quot;sharedWithOrganization&quot;: False,
            &quot;ownerId&quot;: &quot;00000&quot;,
            &quot;sharedWithUsers&quot;: [
              &quot;00000&quot;,
              &quot;11111&quot;
            ],
            &quot;filters&quot;: [
              {
                &quot;field&quot;: &quot;tag5&quot;,
                &quot;comparator&quot;: &quot;!@&quot;,
                &quot;value&quot;: &quot;farming&quot;
              }
            ]
          }
        ]
      }
  </code></pre>
  <p>Python Code: I am using below code to parse the json data but I am unable to filters into different column specially filters part into separate column like Inside filter i a want to make field , comparator  separate column</p>
  <pre class="lang-py prettyprint-override"><code>    records=[]
      for data in response['result']:
          id = data['id']
          title = data['title']
          sharedWithOrganization = data['sharedWithOrganization']
          ownerId = data['ownerId'] 
          sharedWithUsers = '|'.join(data['sharedWithUsers'])
          filters = data['filters']
          print(filters)
          records.append([id,title,sharedWithOrganization,ownerId,sharedWithUsers])
          
          #print(records)
      
          
          
      ExcelApp = win32.Dispatch('Excel.Application')
      ExcelApp.Visible= True
      
      #creating excel and renaming sheet
      
      wb = ExcelApp.Workbooks.Add()
      ws= wb.Worksheets(1)
      ws.Name=&quot;Get_Views&quot;
          
          
          
      #assigning header value
      header_labels=('Id','Title','SharedWithOrganization','OwnerId','sharedWithUsers')
      for index,val in enumerate(header_labels):
          ws.Cells(1, index+1).Value=val
          
          
          
      row_tracker = 2
      column_size = len(header_labels)
      
      for row in records:
          ws.Range(ws.cells(row_tracker,1),ws.cells(row_tracker,column_size)).value = row
          row_tracker +=1
  </code></pre>
  <p><a href="https://i.stack.imgur.com/nykar.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nykar.png" alt="enter image description here" /></a></p>
  <p>I am doing API pull i am getting this kind of format and I am passing that .json format to python to achieve the data into excel but I am unable to filters list data into separate column can you please help me with</p>