---
slug: "gas-get-spreadsheet-data-as-dictionary-list"
title: "GAS で、Google Spreadsheet の内容を 辞書のリストで取得する"
description: "Mac から `chrome` コマンドで Chrome を固定ウィンドウサイズで起動するシェルスクリプト。`--window-size` と `--window-position` を組み合わせる。"
url: "https://www.ytyng.com/blog/gas-get-spreadsheet-data-as-dictionary-list"
publish_date: "2022-10-25T00:04:56Z"
created: "2022-10-25T00:04:56Z"
updated: "2026-05-11T13:21:45.921Z"
categories: []
keywords: ""
featured_image_url: "https://media.ytyng.com/resize/20230812/db14fd6889864396bb2b0273ccb713fe.png.webp?width=768"
has_video: false
has_music: false
video_urls: []
music_urls: []
lang: "ja"
---

# GAS で、Google Spreadsheet の内容を 辞書のリストで取得する

```Javascript
function myFunction() {
  var data = getDataOfSheetId('xxxxx-xxxxxxxxxxxxxxxxxxxx_xxxxxx', 0);
  console.log(data);
}

function getDataOfSheetId(spreadsheetId, sheetIndex) {
  var book = SpreadsheetApp.openById(spreadsheetId);
  var sheet = book.getSheets()[sheetIndex];
  console.log(sheet.getName());
  var [rows, columns] = [sheet.getLastRow(), sheet.getLastColumn()];
  var data = sheet.getRange(1, 1, rows, columns).getValues();
  var header = data[0];
  data.shift();
  return data.map(function(row) {
    return header.reduce(function(o, h, i) {
      o[h] = row[i];
      return o;
    }, {});
  });
}
```

参考:

[javascript - How to get data from google sheets as an array of dictionary - Stack Overflow](https://stackoverflow.com/questions/57269986/how-to-get-data-from-google-sheets-as-an-array-of-dictionary)