Excel Online/Sharepoint as a Data Source
- Justin Shackelford
Create the sheet that you want to use as a data source.
This sheet must be saved through Sharepoint for this URL to work.
Within Sharepoint, navigate to your Excel document and generate your URL via Share > Copy Link > Share Settings > Anyone.
Once the link has been copied, append &download=1 to the end of the URL to make the URL download instead of opening the excel file. This is the URL that will be used within HootVid Data sources.
Example Sheet format:
https://advancelocal-my.sharepoint.com/:x:/g/personal/ptober_advancelocal_net/EdqeQBBhKspFiXy_SP398XQBWjT48UEc0SH9jMprzZyLtQ?e=SAHQFJ
Append:
&download=1
Working Data Source URL:
https://advancelocal-my.sharepoint.com/:x:/g/personal/ptober_advancelocal_net/EdqeQBBhKspFiXy_SP398XQBWjT48UEc0SH9jMprzZyLtQ?e=SAHQFJ&download=1
Any change to the name of this document will generate a new URL structure. If done, repeat steps 2 & 3 and update the data source within HootVid.