The spreadsheet must be published to the Web so Google can generate the CSV data files for you. 

  1. Select File > Publish to the Web ...

  2. Select the sheet you would like to publish

  3. Choose Comma-separated values (.csv) as the publishing format

  4. If your spreadsheet has never been published before, press the Publish button

  5. Copy the resulting .csv URL