title: How to convert JSON into excel file with multisheet?
body: <p>I have a set of 300+ JOSN files like location_X.json, location_Y.json,... and so on with structure like in file location_X.json I have</p>
  
  <pre><code> {"Cardiologist": [{"name": "Dr. AB", "url": "https://www....-cardiologist?specialization=Cardiologist", "photo": [], "image": "https://images1-....jpg/thumbnail", "address": {"addressLocality": "location_X", "addressRegion": "delhi", "@type": "PostalAddress"}, "branchOf": {"url": "https://www....-clinic-x-y-market", "address": {"addressLocality": "X.Y.Market", "addressRegion": "delhi", "@type": "PostalAddress"}, "@type": "MedicalClinic", "name": "Dr AB Clinic"}, "priceRange": 0, "openingHours": [], "currenciesAccepted": "INR", "@context": "http://schema.org/", "geo": {"latitude": "", "@type": "GeoCoordinates", "longitude": ""}, "@type": "Physician", "medicalSpecialty": "Cardiologist"}], ... }
  </code></pre>
  
  <p>You can think of structure like this:</p>
  
  <pre><code>{"Specialty_1":[{"name":"","url":"", "photo":"", "address":{"addressLocality": "", "addressRegion": "", "@type": "PostalAddress"},"branchOf": {"url": "https://www...", "address": {"addressLocality": "", "addressRegion": "", "@type": "PostalAddress"},"@type": "MedicalClinic", "name": "Dr AB Clinic"}, "priceRange": 0, "openingHours": [], "currenciesAccepted": "", "@context": "http://schema.org/", "geo": {"latitude": "", "@type": "GeoCoordinates", "longitude": ""}, "@type": "Physician", "medicalSpecialty": "Specialty_1"}, ...], "Specialty_2":[{"name":"","photo":"", ...}, ...], ... }
  </code></pre>
  
  <p>Dictionary with list of all doctors of particular specialty in particular area with 13-types of features and consists of all doctors in that area, </p>
  
  <p>How do I convert this JSON file such that I get a file for location_X in Excel with multisheet with each sheet named like "Specialty_1", "Specialty_2", and so on... containing all doctors for "Specialty_1" etc in the location X.  Thanks in advance.    </p>