{"id":15638,"date":"2023-09-01T09:00:00","date_gmt":"2023-09-01T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/09\/01\/extracting-columns-from-spreadsheet-using-apps-script\/"},"modified":"2025-09-15T17:28:59","modified_gmt":"2025-09-15T08:28:59","slug":"extracting-columns-from-spreadsheet-using-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/09\/01\/extracting-columns-from-spreadsheet-using-apps-script\/","title":{"rendered":"Extracting Columns from Spreadsheet using map method in Apps Script"},"content":{"rendered":"

This post is a corrected post after AI explains the code included in the book “Google Apps Script 101: Building Work Automation For Free”<\/a>. Added a strikethrough<\/s> when editing what AI has written, and added color<\/span> when edited by author<\/p>\n

Table of Contents<\/h2>\n
    \n
  1. Summary<\/a><\/li>\n
  2. Code<\/a><\/li>\n
  3. Code Explanation<\/a><\/li>\n
  4. Example<\/a><\/li>\n
  5. AI Prompt<\/a><\/li>\n<\/ol>\n

    Summary<\/h2>\n

    In this blog post, we will explore how to extract specific columns from a spreadsheet using Apps Script. We will use the getDataRange<\/code> method to get all the data from a sheet, and then manipulate the data to extract the desired columns.<\/p>\n

    Code<\/h2>\n
    function colExtract() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET6 = SS.getSheetByName('Sheet6')\n\n  const data = T_SHEET6.getDataRange().getValues()\n  let dataMap = data.map(item => [item[0], item[2]])\n  Logger.log(dataMap)\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code defines a function named colExtract<\/code>. It retrieves the active spreadsheet using getActiveSpreadsheet<\/code> method and assigns it to the SS<\/code> variable. Then it gets the sheet named ‘Sheet6’ using getSheetByName<\/code> method and assigns it to the T_SHEET6<\/code> variable.<\/p>\n
    The getDataRange<\/code> method is used to get the range of data from the sheet, and getValues<\/code> is used to retrieve the values of that range. The data is stored in the data<\/code> variable.<\/p>\n
    The map<\/code> method is used on the data<\/code> array to create a new array, dataMap<\/code>, containing only the first and third elements of each inner array. This is done by accessing the elements using square bracket notation.<\/p>\n
    Finally, the dataMap<\/code> array is logged using Logger.log<\/code>.<\/p>\n
    Example<\/h2>\n
    Let’s say we have a spreadsheet with three columns: Name, Age, and City. We want to extract only the Name and City columns.<\/p>\n
    After running the colExtract<\/code> function, the dataMap<\/code> array will contain an array of arrays, where each inner array contains the Name and City values of each row.<\/p>\n
    AI Prompt<\/h2>\n
    Write a function that extracts specific columns from a spreadsheet. The function should retrieve the active spreadsheet, get the sheet by name, and extract the desired columns using the getDataRange<\/code> method and map<\/code> function. Log the extracted columns.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will explore how to extract specific columns from a spreadsheet using Apps Script. We will use the getDataRange method to get all the data from a sheet, and then manipulate the data to extract the desired columns.<\/p>\n","protected":false},"author":1,"featured_media":15647,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5,118],"tags":[512,69,542,7],"class_list":["post-15638","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-map","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=15638"}],"version-history":[{"count":4,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15638\/revisions"}],"predecessor-version":[{"id":17174,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15638\/revisions\/17174"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15647"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}