How do I get a CSV file link from a Google Spreadsheet?

Modified on Wed, 01 Jun 2022 at 02:09 PM

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


  1. Select File > Share > 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



  6. In the CMS, add a new data source, label it so you know it's referring to your Google Sheet and select CSV URL as the Source. In the next step, paste the URL you copied from your Google Sheet web publishing step.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article