--- title: Using Google Sheets to Host Editable CSV Files description: You can integrate Google Sheets with applications (like the Megalytic CSV Widget) that require CSV files by converting the Google Sheet URL to a slightly different form that forces a CSV download of t --- [Skip to content](https://resources.tapclicks.com/migration/en/knowledge/using-google-sheets-to-host-editable-csv-files#main-content) English Show submenu for translations ![Megalytic\_Logo\_White.svg\]](https://resources.tapclicks.com/hubfs/Megalytic_Logo_White.svg) - [Sample About Page](https://resources.tapclicks.com/sample-about) - [Sample Contact Page](https://resources.tapclicks.com/sample-contact) - [Default HubSpot Blog](https://resources.tapclicks.com/blog) Open main navigation Close main navigation - [Sample About Page](https://resources.tapclicks.com/sample-about) - [Sample Contact Page](https://resources.tapclicks.com/sample-contact) - [Default HubSpot Blog](https://resources.tapclicks.com/blog) - English Show submenu for translations - Contact us Contact us Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://resources.tapclicks.com/migration/en/knowledge?hsLang=en) 2. [Uploading Data](https://resources.tapclicks.com/migration/en/knowledge/uploading-data?hsLang=en) # Using Google Sheets to Host Editable CSV Files You can integrate Google Sheets with applications (like the [Megalytic CSV Widget](https://megalytic.com/support/importing-data-with-the-csv-widget/)) that require CSV files by converting the Google Sheet URL to a slightly different form that forces a CSV download of the sheet’s data. This is very convenient because you can update the sheets via the Google UI and then the CSV download will be automatically updated. In the case of Megalytic, when you refresh the page, the CSV widget is automatically updated. Google Sheets can be downloaded automatically as CSV files using a URL that you can construct from the sheet’s key. Take this sheet, for example: https://docs.google.com/spreadsheets/d/1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno/edit?usp=sharing The “key” is the long string appearing after “/d/”: 1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno You can create a CSV download link for that sheet, but plugging the “key” into this URL structure: https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv So, in this case, using our example key, you get the following link (click to test it out): [https://docs.google.com/spreadsheets/d/1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno/gviz/tq?tqx=out:csv](https://docs.google.com/spreadsheets/d/1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno/gviz/tq?tqx=out:csv) If your Google Sheet has multiple tabs, you can add an additional “sheet” parameter on the end of the URL to specify which tab should be downloaded as the CSV. If you leave this off, the first tab will be downloaded. Here is an example using the “sheet” parameter: [https://docs.google.com/spreadsheets/d/1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno/gviz/tq?tqx=out:csv&sheet=bsheet](https://docs.google.com/spreadsheets/d/1qrtaGu5dwljVbHJeR4RIMWtdZKOauJfJ6nODlPwMRno/gviz/tq?tqx=out:csv&sheet=bsheet) Note that Google periodically updates how the exporting URL works. As of this writing (November 7, 2017) the approach outlined above works well. You can find more details in this [stackoverflow post](https://stackoverflow.com/questions/33713084/download-link-for-google-spreadsheets-csv-export-with-multiple-sheets). - [Widgets](https://resources.tapclicks.com/migration/en/knowledge/widgets?hsLang=en) - [White Label](https://resources.tapclicks.com/migration/en/knowledge/white-label?hsLang=en) - [User Workplaces](https://resources.tapclicks.com/migration/en/knowledge/user-workplaces?hsLang=en) - [Uploading Data](https://resources.tapclicks.com/migration/en/knowledge/uploading-data?hsLang=en) - [Text](https://resources.tapclicks.com/migration/en/knowledge/text?hsLang=en) - [Templates](https://resources.tapclicks.com/migration/en/knowledge/templates?hsLang=en) - [Search Console](https://resources.tapclicks.com/migration/en/knowledge/search-console?hsLang=en) - [Reports](https://resources.tapclicks.com/migration/en/knowledge/reports?hsLang=en) - [Plans and Pricing](https://resources.tapclicks.com/migration/en/knowledge/plans-and-pricing?hsLang=en) - [Metrics](https://resources.tapclicks.com/migration/en/knowledge/metrics?hsLang=en) - [Images](https://resources.tapclicks.com/migration/en/knowledge/images?hsLang=en) - [Goals](https://resources.tapclicks.com/migration/en/knowledge/goals?hsLang=en) - [Getting Started](https://resources.tapclicks.com/migration/en/knowledge/getting-started?hsLang=en) - [Formatting](https://resources.tapclicks.com/migration/en/knowledge/formatting?hsLang=en) - [Filters](https://resources.tapclicks.com/migration/en/knowledge/filters?hsLang=en) - [Facebook](https://resources.tapclicks.com/migration/en/knowledge/facebook?hsLang=en) - [Email](https://resources.tapclicks.com/migration/en/knowledge/email?hsLang=en) - [eCommerce](https://resources.tapclicks.com/migration/en/knowledge/ecommerce?hsLang=en) - [Dates](https://resources.tapclicks.com/migration/en/knowledge/dates?hsLang=en) - [Dashboards](https://resources.tapclicks.com/migration/en/knowledge/dashboards?hsLang=en) - [Customization](https://resources.tapclicks.com/migration/en/knowledge/customization?hsLang=en) - [Credit Card](https://resources.tapclicks.com/migration/en/knowledge/credit-card?hsLang=en) - [Connections](https://resources.tapclicks.com/migration/en/knowledge/connections?hsLang=en) - [Chart](https://resources.tapclicks.com/migration/en/knowledge/chart?hsLang=en) - [Brand](https://resources.tapclicks.com/migration/en/knowledge/brand?hsLang=en) - [AdWords](https://resources.tapclicks.com/migration/en/knowledge/adwords?hsLang=en) - [Admin](https://resources.tapclicks.com/migration/en/knowledge/admin?hsLang=en) - [Sample About Page](https://resources.tapclicks.com/sample-about) - [Sample Contact Page](https://resources.tapclicks.com/sample-contact) - [Default HubSpot Blog](https://resources.tapclicks.com/blog) [![Chill listening crop-3](https://resources.tapclicks.com/hubfs/Megalytic_Logo_White.svg "Chill listening crop-3")](http://www.tapclicks.com?hsLang=en) Megalytic Help Center Copyright © 2026, TapClicks