title: Googlesheets Importdata from onedrive
body: <p>I used to import a spreadsheet from dropbox's public folder into a google spreadsheet
  But Dropbox stop the public folder service so I tried alternative with Onedrive.
  But the very same spreadsheet won't import in google spreadsheet</p>
  
  <p>dropbox version</p>
  
  <pre><code>=importdata ("https://dl.dropboxusercontent.com/u/2010525/xxx111.CSV")
  </code></pre>
  
  <p>one drive version</p>
  
  <pre><code>=importdata ("https://1drv.ms/u/s!AjKRI20GRDHHgzT07aBpOYmesNmO")
  </code></pre>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1WflkC1RHsQ_Z4rRmVz6LikxFy0GufyqQrLwMa9WK4vY/edit?usp=sharing" rel="nofollow noreferrer">example google sheet</a></p>
  
  <p>Anyone know what is going wrong here?</p>
  
  <p><a href="https://dl.dropboxusercontent.com/u/2010525/xxx111.CSV" rel="nofollow noreferrer">csv file on dropbox</a></p>
  
  <p><a href="https://1drv.ms/u/s!AjKRI20GRDHHgzT07aBpOYmesNmO" rel="nofollow noreferrer">Same cvs file on OneDrive</a></p>