Google Spreadsheet to JSON Converter

It's pretty useful to be able to get data from a Google Spreasheet as JSON, however it takes a bit of messing around with the URL to do so. This little converter should help.

The best part is that this tool handles mutiple sheets, returning the right sheet ID for whichever is specified in the URL

Enter Your Google Spreadsheet URL here

Make sure it's published to the web
{{error}}

Your new URL is:

{{newURL}}
Open URL

Usage


        $.get('{{newURL}}', function(data){
          var entries = data.feed.entry;
          
          $(entries).each(function(){
            // Do something with each entry
          });
        });
      

        $http.get('{{newURL}}').then(function(response){
          // Assign data to scope
          $scope.data = response.data;
        });
      
{{JSONData | json}}