Hey, and welcome our to our GSV section, so this one actually came to me from a student that was looking
for a way to export data into a CSFI for their Web users to be able to download.
So I created a little mini application and then I took it a step further, added the ability to get
that information from a Google spreadsheet.
So this is going to be taking essentially an array using that array format and generating a CSFI all
using JavaScript.
And the nice thing about it is this is really useful because once you tie it to a Google spreadsheet,
then when you update the content in the Google spreadsheet, all the users come to your website are
going to have a new version of content that they can download.
And you don't have to give them access to your Google spreadsheet.
So that's a really nice thing about it.
And let me show you so I'm excited to show you this as this is a really unique approach to doing this
format.
So going over to Google.
So whenever you have a Google spreadsheet, you can output the content as JSON format.
And that's what we're using in order to generate the array that gets used to generate the CSV file.
And then the downloadable CSV file as well is done via JavaScript.
So that's just a few lines of code that enable us to do that.
So we get JSON data and we pass through that Jason data.
We develop and we construct an array, so we construct the array for the CSFI and then once we've created
it, we can download and we can open up CSV file and you can see all of the content that's going to
be contained in this.
So this was just generated, just created in a second open up.
So it's getting the content directly from the Google spreadsheet.
This is a fun one.
Do try this out.
And it is a unique approach to generating CSP files.