When linking to files in Google Sheets, by default a link is created to a web page with an image on that page.


To directly link to the image itself:

  1. Got to the file in Google Sheets
  2. The link will look like this: https://docs.google.com/spreadsheets/d/FILE_ID/edit#gid=0
  3. Remove the 'edit#gid=0' and add 'export?format=csv'
  4. Your link will now look like this: https://docs.google.com/spreadsheets/d/FILE_ID/export?format=csv


The link can be publicly accessible or it can be private and available to anyone who has the link.

 

That's it, this link will now directly download a CSV file