Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

As a Google Sheets user, you've probably already used the option to download the entire spreadsheet into an Excel file or a specific sheet/tab as a CSV/TSV file (under File > Download).

To use a Google Sheet as a data source in HootVid, we require a direct download link of a CSV file.

Doing so is fairly straightforward, you need to remove the section of the URL starting from /edit and replace it with /export with some additional text.

Example Starting Google Sheet URL:

https://docs.google.com/spreadsheets/d/1Gztm9o8JEPibPWEDwH54qBG5kwj51ILDOk_dxK6uTSY/edit#gid=1330027783

Final Downloadable Google Sheet URL (HootVid Data Source):

https://docs.google.com/spreadsheets/d/1Gztm9o8JEPibPWEDwH54qBG5kwj51ILDOk_dxK6uTSY/export?format=xlsx&gid=1330027783

Notice that the difference is we included &gid=1330027783 to the URL.  This is basically the "Sheet ID" and as you switch sheets/tabs in Google Sheets, you'll notice this value changes and you can basically just copy that ID and append it to the URL if you want that specific sheet exported.

  • No labels