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