prettify_spreadsheet_json.js

function prettifySpreadsheetJSON(data) {
    var prefix = 'gsx$';
    for (var i = 0; i < data.feed.entry.length; i++) {
        for (var key in data.feed.entry[i]) {
            if (data.feed.entry[i].hasOwnProperty(key) && key.substr(0,prefix.length) === prefix) {
                data.feed.entry[i][key.substr(prefix.length)] = data.feed.entry[i][key].$t;
                delete data.feed.entry[i][key];
            }
        }
    }
}