Skip to content

Instantly share code, notes, and snippets.

@PolarBearGG
Created February 13, 2020 13:58
Show Gist options
  • Save PolarBearGG/603a360f47829d653894bb7901c415c0 to your computer and use it in GitHub Desktop.
Save PolarBearGG/603a360f47829d653894bb7901c415c0 to your computer and use it in GitHub Desktop.
Create JSON from google sheets
function exportSheetAsJSON() {
var sheet = SpreadsheetApp.getActiveSheet();
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
var numCols = rows.getNumColumns();
var values = rows.getValues();
var output = "";
output += "{\""+sheet.getName()+"\" : {\n";
var header = values[0];
for (var i = 1; i < numRows; i++) {
if (i > 1) output += " , \n";
var row = values[i];
output += "\""+row[0]+"\" : {";
for (var a = 1;a<numCols;a++){
if (a > 1) output += " , ";
output += "\""+header[a]+"\" : \""+row[a]+"\"";
}
output += "}";
//Logger.log(row);
}
output += "\n}}";
Logger.log(output);
DriveApp.createFile(sheet.getName()+".json", output, MimeType.PLAIN_TEXT);
};
@PolarBearGG
Copy link
Author

{nameOfSheet:
{first column:
{first row : second row}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment