Converting Google Sheets cell values to an object array with heading keys using Google Apps Script

This is a sample script for converting the values of Google Spreadsheet to an object using Google Apps Script.

I have a minor obsession with methods for converting Google Sheets data to an object array. Over the years I’ve documented various approaches I’ve developed on my personal site, like this one, but this solution from Kanshi Tanaike has to be my new favourite:

function myFunction() {
  const sheetName = "Sheet1";
  const [headers, ...rows] = SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName(sheetName)
    .getDataRange()
    .getValues();
  const res = rows.map((r) =>
    headers.reduce((o, h, j) => Object.assign(o, { [h]: r[j] }), {})
  );
  console.log(res);
}

Source: Converting Values of Google Spreadsheet to Object using Google Apps Script

Martin Hawksey

Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.

mashe.hawksey.info

2 comments for “Converting Google Sheets cell values to an object array with heading keys using Google Apps Script”

kapil

23 September, 2022 at 13:46

very very heplfull
but is there a way we can create following type array from the sheet data where the each hoby coms from different column

object ( {
name: ‘John’,
age: 20,
hobbies: [‘reading’, ‘games’, ‘coding’],},
}

Antonio

18 October, 2022 at 19:43

Brilliant! Mr. Tanaike and folks like you have already helped so much, I’ll be always grateful!

Converting Google Sheets cell values to an object array with heading keys using Google Apps Script

Related Posts:

2 comments for “Converting Google Sheets cell values to an object array with heading keys using Google Apps Script”

Leave a Reply Cancel reply