Roku Direct Publisher

Roku Direct Publisher - the easiest way to create a great TV experience. Learn more about how to create a Roku channel and share your experiences with others.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Roku Guru

Exporting from Excel

Does anyone export their json file from Excel or Google Sheets?  I wrote my original site by hand coding, but I kept a file of the videos just for a "database" (a very basic one at least).  Adding to it, and thinking there's gotta be a way to successfully perform it. I've found how to export sheets to json, but I can't seem to figure out how to keep child/parent columns for something like the content & videos in the below example

"content": {
            "dateAdded": "2015-08-13T14:14:54.431Z",
            "captions": [],
            "duration": 63,
            "adBreaks": ["00:00:00", "00:01:03"],
            "videos": [{
                "url": "",
                "quality": "HD",
                "videoType": "MP4"

*** Nevermind everyone, it's beyond the scope of support here.  If I do get it I'll post back.
0 Kudos
Roku Guru

Re: Exporting from Excel

FWIW this method is what I followed to export to json. Just couldn't figure out child statements (Although I'm thinking with careful find/replace maybe I could insert them):[youtube:10da26n0]HnFwl-8aTmQ[/youtube:10da26n0]
0 Kudos
Roku Guru

Re: Exporting from Excel

I wrote a script that gets everything from an access database in classic asp.. lol.. yeah I'm old...
0 Kudos