title: Export sharepoint list data to excel using python
body: <p>I have sharepoint url where i can open and export that sharepoint list into excel. I want to automate that using python. i have tried many suggestions from online. but none of those are working.</p>
  
  <p>i have tried below code to connect sharepoint</p>
  
  <pre><code>import requests
  url= 'my sharepoint file path here'
  r=requests.get(url,verify=False) #no username or password required
  </code></pre>
  
  <p>i am expecting the code should export sharepoint list data to new excel file.</p>