{"id":15556,"date":"2023-08-11T09:00:00","date_gmt":"2023-08-11T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/08\/11\/copying-data-between-sheets-in-apps-script\/"},"modified":"2025-09-15T17:54:24","modified_gmt":"2025-09-15T08:54:24","slug":"copying-data-between-sheets-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/11\/copying-data-between-sheets-in-apps-script\/","title":{"rendered":"Copying Data Between Sheets 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 copy data between sheets in Apps Script. We will learn how to use the copyTo<\/code> method to copy the data range from one sheet to another.<\/p>\n

    Code<\/h2>\n
    function copyData() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET2 = SS.getSheetByName('Sheet2')\n  const T_SHEET5 = SS.getSheetByName('Sheet5')\n\n  T_SHEET2.getDataRange().copyTo(T_SHEET5.getRange(1, 1))\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code declares a function named copyData<\/code>. It uses the getActiveSpreadsheet<\/code> method to get the active spreadsheet. Then, it assigns the sheet objects T_SHEET2<\/code> and T_SHEET5<\/code> to the respective sheets with the names ‘Sheet2’ and ‘Sheet5’.<\/p>\n
    The getDataRange<\/code> method is used to get the entire data range from T_SHEET2<\/code>. The copyTo<\/code> method is then used to copy the data range to cell A1 in T_SHEET5<\/code>.<\/p>\n
    copyTo(T_SHEET5.getRange(1, 1)): This part does the work of copying the data range to the specified location. <\/span><\/p>\n
      \n
    • T_SHEET5: This part represents the Google Sheets sheet named ‘T_SHEET5’. The copied data will be pasted into this sheet. <\/span><\/li>\n
    • getRange(1, 1): This method gets the range representing the cells in the first row and first column of sheet ‘T_SHEET5’. The copied data will be pasted starting from this cell.\u00a0<\/span><\/li>\n<\/ul>\n
      Example<\/h2>\n
      Let’s say we have two sheets in our spreadsheet named ‘Source’ and ‘Destination’. We want to copy all the data from the ‘Source’ sheet to the ‘Destination’ sheet.<\/p>\n
      Here’s an example of how we can achieve this using the provided code:<\/p>\n
      function copyData() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const sourceSheet = SS.getSheetByName('Source')\n  const destinationSheet = SS.getSheetByName('Destination')\n\n  sourceSheet.getDataRange().copyTo(destinationSheet.getRange(1, 1))\n}<\/code><\/pre>\n
      AI Prompt<\/h2>\n
      Write a function that copies the data from one sheet to another in Apps Script. Use the copyTo<\/code> method to copy the data range from the source sheet to the specified range in the destination sheet.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In this blog post, we will explore how to copy data between sheets in Apps Script. We will learn how to use the copyTo method to copy the data range from one sheet to another.<\/p>\n","protected":false},"author":1,"featured_media":15568,"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,537,7],"class_list":["post-15556","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-copyto","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\/15556","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=15556"}],"version-history":[{"count":3,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15556\/revisions"}],"predecessor-version":[{"id":17193,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15556\/revisions\/17193"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15568"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}