{"id":519,"date":"2022-01-23T14:16:10","date_gmt":"2022-01-23T14:16:10","guid":{"rendered":"https:\/\/gatlabs.com\/knowledge\/?p=519"},"modified":"2022-09-23T16:52:05","modified_gmt":"2022-09-23T15:52:05","password":"","slug":"how-to-bulk-create-export-and-update-google-classrooms","status":"publish","type":"docs","link":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/","title":{"rendered":"How to Bulk Create, Export, and Update Google Classrooms"},"content":{"rendered":"\r\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis: 100%;\">\r\n<div class=\"wp-block-group is-layout-flow wp-block-group-is-layout-flow\">\r\n<h3>Introduction<\/h3>\r\n<p>With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their <a href=\"https:\/\/classroom.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Classrooms<\/a> across their school district without difficulty.<\/p>\r\n<p>Before we start make sure you have enabled Google Classroom APIs.\u00a0<\/p>\r\n<h3>Create new Google Classrooms<\/h3>\r\n<p>1. Enter the Classroom Audit menu then click on the Classroom tab.<\/p>\r\n<p>2. Use the <strong>Apply custom filter<\/strong> (funnel icon) button to filter for specific classrooms if needed.\u00a0<\/p>\r\n<p>3. Click on the <strong>Export data<\/strong> button that&#8217;s located on the right-hand side of the page to export a Google Spreadsheet of the filter you applied.\u00a0<\/p>\r\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-2461\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV.png\" alt=\"\" width=\"1920\" height=\"646\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV.png 1920w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV-300x101.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV-1024x345.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV-768x258.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV-1536x517.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\r\n<\/div>\r\n<p>Make sure to click on the option Export to Google Sheet (max 150,000 records) option. This is the correct type for editing and modifying details. It&#8217;s got the right format.\u00a0<\/p>\r\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2462\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_44_15-Calculator.png\" alt=\"\" width=\"1920\" height=\"703\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_44_15-Calculator.png 1920w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_44_15-Calculator-300x110.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_44_15-Calculator-1024x375.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_44_15-Calculator-768x281.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_44_15-Calculator-1536x562.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\r\n<div class=\"wp-block-group\">\r\n<p>4. When the exported Spreadsheet appears, <strong>click to view<\/strong> and find an empty row at the bottom of the existing data.<\/p>\r\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2463\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_47_00-GAT.png\" alt=\"\" width=\"1603\" height=\"575\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_47_00-GAT.png 1603w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_47_00-GAT-300x108.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_47_00-GAT-1024x367.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_47_00-GAT-768x275.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_47_00-GAT-1536x551.png 1536w\" sizes=\"(max-width: 1603px) 100vw, 1603px\" \/><\/p>\r\n<p>Fill in the following fields:<\/p>\r\n<ul>\r\n<li><strong>Name<\/strong> (Name of Google Classroom) &#8211; <strong>Mandatory Field<\/strong><\/li>\r\n<li><strong>Owner<\/strong> (Usually email of teacher) &#8211; <strong>Mandatory Field<\/strong>\r\n<ul>\r\n<li>You <strong>must<\/strong> enter only one email address in the Owner field.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Optional Fields:<\/p>\r\n<ul>\r\n<li>Description<\/li>\r\n<li>Section<\/li>\r\n<li>Room<\/li>\r\n<li>State (ACTIVE, ARCHIVED)<\/li>\r\n<li>Aliases (start with <strong>:p<\/strong> or <strong>:d <\/strong>)\u00a0&#8211;\u00a0 ( Alternative identifier for a course, so instead of course id (number) use and add alias.\u00a0<\/li>\r\n<li>Teachers (separate emails with a comma)<\/li>\r\n<li>Students (separate emails with a comma)<\/li>\r\n<li>Short Description<\/li>\r\n<\/ul>\r\n<p><strong>Important: DO NOT<\/strong> modify any of the <b>RED-colored<\/b>\u00a0background fields in the spreadsheet. Fields in <strong>GREEN<\/strong> background <em><strong>can be edited<\/strong><\/em><\/p>\r\n<ul>\r\n<li><strong>Course_ID<\/strong> (when creating new classrooms, keep ID blank, if a classroom already has an ID do not modify it.) This field is handled automatically by GAT+.<\/li>\r\n<li>It\u2019s not necessary to create or modify the <strong>Created<\/strong> (date field). This field is handled automatically by GAT+.<\/li>\r\n<\/ul>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5166\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Classroom-1024x186.png\" alt=\"\" width=\"1024\" height=\"186\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Classroom-1024x186.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Classroom-300x54.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Classroom-768x139.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Classroom-1536x278.png 1536w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Classroom.png 1805w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\r\n<p>5. Once you have finished filling in the information for the new classroom close the Spreadsheet tab.<\/p>\r\n<p>6. Then click on the <strong>Import data<\/strong> button, to add the data back and import it to G Suite (GAT+)<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2465\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_19_40-Films-TV.png\" alt=\"\" width=\"1920\" height=\"696\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_19_40-Films-TV.png 1920w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_19_40-Films-TV-300x109.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_19_40-Films-TV-1024x371.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_19_40-Films-TV-768x278.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_19_40-Films-TV-1536x557.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\r\n<p>7. When the correct Google Spreadsheet from the list is selected, click on the &#8220;eye&#8221; icon to open the Spreadsheet again (<strong>Preview Spreadsheet<\/strong> option). Click on the &#8220;check-mark&#8221; (<strong>Choose<\/strong>) to complete the import of the spreadsheet, details will be displayed.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2467\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_21_27-GAT.png\" alt=\"\" width=\"1702\" height=\"582\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_21_27-GAT.png 1702w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_21_27-GAT-300x103.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_21_27-GAT-1024x350.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_21_27-GAT-768x263.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_21_27-GAT-1536x525.png 1536w\" sizes=\"(max-width: 1702px) 100vw, 1702px\" \/><\/p>\r\n<p>8. In the below example you can see the type of import is a <strong>CREATE<\/strong> action which means a<strong> new classroom will be created. <\/strong>After you are happy with these details click on the <strong>Accept<\/strong> button.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2468\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_23_18-GAT.png\" alt=\"\" width=\"1714\" height=\"827\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_23_18-GAT.png 1714w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_23_18-GAT-300x145.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_23_18-GAT-1024x494.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_23_18-GAT-768x371.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_23_18-GAT-1536x741.png 1536w\" sizes=\"(max-width: 1714px) 100vw, 1714px\" \/><\/p>\r\n<p>9. When the operation is carried out you should see a message stating whether the operation was successful. The dialog box will appear at the top right corner of the screen.<\/p>\r\n<p>The classroom will be added and visible in GAT+.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2469\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_25_49-Films-TV.png\" alt=\"\" width=\"1920\" height=\"661\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_25_49-Films-TV.png 1920w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_25_49-Films-TV-300x103.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_25_49-Films-TV-1024x353.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_25_49-Films-TV-768x264.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_25_49-Films-TV-1536x529.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\r\n<h2>Update existing Classrooms<\/h2>\r\n<p>1. <strong>Apply a custom filter<\/strong> (funnel icon) and search for the classrooms you want to take action on. Use <strong>Search operands <\/strong>to find the classrooms you need to update.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2471\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_31_01-Films-TV.png\" alt=\"\" width=\"1920\" height=\"920\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_31_01-Films-TV.png 1920w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_31_01-Films-TV-300x144.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_31_01-Films-TV-1024x491.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_31_01-Films-TV-768x368.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-14_31_01-Films-TV-1536x736.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\r\n<p>In the <strong>example above<\/strong> &#8211; I used Name and Teacher&#8217;s Email search operands.\u00a0<\/p>\r\n<p>2. Click <strong>Apply\u00a0<\/strong>and the results will be displayed.\u00a0<\/p>\r\n<p>3. Click on the Export to Google Sheet.\u00a0<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2478\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_11_32-Calculator.png\" alt=\"\" width=\"1920\" height=\"681\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_11_32-Calculator.png 1920w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_11_32-Calculator-300x106.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_11_32-Calculator-1024x363.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_11_32-Calculator-768x272.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_11_32-Calculator-1536x545.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\r\n<p>5. When the Spreadsheet is created, click to view.<\/p>\r\n<p>6. \u00a0As in the example below. Edit any of the &#8220;<strong>allowed<\/strong>&#8221; fields as below.<\/p>\r\n<p>In this case, changing the <strong>Name<\/strong> of one classroom, <strong>State<\/strong> to Archived, and <strong>Description<\/strong>, and adding additional <strong>Students.<\/strong><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5167\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Updated-Classrooms-1024x233.png\" alt=\"\" width=\"1024\" height=\"233\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Updated-Classrooms-1024x233.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Updated-Classrooms-300x68.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Updated-Classrooms-768x174.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2022\/01\/Updated-Classrooms.png 1457w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\r\n<p><strong>Important:<\/strong> <strong>DO NOT<\/strong> modify or edit the fields in <strong>RED<\/strong>, Fields with the <strong>Green<\/strong> background <strong>can be edited<\/strong><\/p>\r\n<ul>\r\n<li><strong>Course_ID<\/strong> (when updating a classroom, keep the ID as it is) This field is handled automatically by GAT+.<\/li>\r\n<li><strong>Created<\/strong> (date field). This field is handled automatically by GAT+.<\/li>\r\n<\/ul>\r\n<p>7. When the desired changes are made, close the spreadsheet tab.<\/p>\r\n<p>8. Click on the<strong> Import<\/strong> data button and select the spreadsheet you were working on.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2489\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_52_23-GAT.png\" alt=\"\" width=\"1698\" height=\"633\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_52_23-GAT.png 1698w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_52_23-GAT-300x112.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_52_23-GAT-1024x382.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_52_23-GAT-768x286.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_52_23-GAT-1536x573.png 1536w\" sizes=\"(max-width: 1698px) 100vw, 1698px\" \/><\/p>\r\n<p>9. Cick on the &#8220;eye&#8221; icon to open the Spreadsheet again (<strong>Preview Spreadsheet<\/strong> option). Click on the &#8220;check-mark&#8221; (<strong>Choose<\/strong>) to complete the import of the updated spreadsheet, details will be amended.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2490\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_54_46-GAT.png\" alt=\"\" width=\"1709\" height=\"786\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_54_46-GAT.png 1709w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_54_46-GAT-300x138.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_54_46-GAT-1024x471.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_54_46-GAT-768x353.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_54_46-GAT-1536x706.png 1536w\" sizes=\"(max-width: 1709px) 100vw, 1709px\" \/><\/p>\r\n<div class=\"wp-block-image\">\r\n<p>Then click on the <strong>accept<\/strong> button.<\/p>\r\n<blockquote>\r\n<p><strong>Note:<\/strong> It might take some time for the changes to be carried out (depends on the volume of data).<\/p>\r\n<\/blockquote>\r\n<p>When the changes have occurred, a Success message will be displayed.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2492\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_59_35-Films-TV.png\" alt=\"\" width=\"1768\" height=\"919\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_59_35-Films-TV.png 1768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_59_35-Films-TV-300x156.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_59_35-Films-TV-1024x532.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_59_35-Films-TV-768x399.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-17_59_35-Films-TV-1536x798.png 1536w\" sizes=\"(max-width: 1768px) 100vw, 1768px\" \/><\/p>\r\n<p>The <strong>data will be reflected in GAT+ right away<\/strong>.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2493\" src=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-18_00_34-GAT.png\" alt=\"\" width=\"1606\" height=\"674\" srcset=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-18_00_34-GAT.png 1606w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-18_00_34-GAT-300x126.png 300w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-18_00_34-GAT-1024x430.png 1024w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-18_00_34-GAT-768x322.png 768w, https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-18_00_34-GAT-1536x645.png 1536w\" sizes=\"(max-width: 1606px) 100vw, 1606px\" \/><\/p>\r\n<\/div>\r\n<h3>Reasons why Google Classrooms Need Updating<\/h3>\r\n<p>Examples of reasons to update Google Classrooms<\/p>\r\n<ul>\r\n<li>At the end of the school year, you can ARCHIVE classrooms that are not going to be in use next year so to avoid confusing students.<\/li>\r\n<li>Maybe the Description, Room, Student email addresses have to be modified because they were set up incorrectly by the teacher or classroom creator.<\/li>\r\n<li>A teacher is out sick or on temporary leave and you need to add the new teacher to the Google Classroom.<\/li>\r\n<\/ul>\r\n<h2>Delete existing Classrooms<\/h2>\r\n<p>Deleting a Google Classroom is similar to editing or updating a classroom.\u00a0<\/p>\r\n<p>The only change you need to make is with the <strong>STATE<\/strong> field. Change the <strong>STATE<\/strong> field from <strong>ACTIVE\/ARCHIVED<\/strong> to <strong>DELETED<\/strong>.<\/p>\r\n<p>1. Find the classrooms using the Apply customs filter button, export into Google Spreadsheet or CSV, change the State value.<\/p>\r\n<p>2. Change the <strong>State to DELETED<\/strong><\/p>\r\n<p>3. Make sure to close the spreadsheet down and then click on the <strong>Import data<\/strong> button.<\/p>\r\n<p>4. Select the spreadsheet you were working on, confirm the changes done, and click on the <strong>Accept <\/strong>button.<\/p>\r\n<p>5. When the change is done, Data updated successfully message will be displayed.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37901\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/08\/screenshot-gs.generalaudittool.com-2020.08.07-15_19_15.png\" alt=\"\" width=\"1528\" height=\"875\" \/><\/p>\r\n<p>The <strong>data will be reflected in GAT+ right away<\/strong>.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37902\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/08\/screenshot-gs.generalaudittool.com-2020.08.07-15_21_52.png\" alt=\"\" width=\"1140\" height=\"283\" \/><\/p>\r\n<h2>Important information about the Google Classroom States<\/h2>\r\n<p>When a classroom is Archived it is still available on the bottom left-hand side section of the <a href=\"https:\/\/classroom.google.com\/\">Google Classroom website<\/a><\/p>\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37903\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/08\/screenshot-classroom.google.com-2020.08.07-15_24_57.png\" alt=\"\" width=\"1104\" height=\"404\" \/><\/figure>\r\n<\/div>\r\n<p>&nbsp;<\/p>\r\n<p>An <strong>archived classroom<\/strong> <strong>can be<\/strong> always <strong>restored<\/strong>. But if you <strong>delete<\/strong> a classroom it will be <strong>permanently removed<\/strong>.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37904\" src=\"https:\/\/gatlabs.com\/wp-content\/uploads\/2020\/08\/screenshot-classroom.google.com-2020.08.07-15_27_13.png\" alt=\"\" width=\"1103\" height=\"448\" \/><\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n","protected":false},"excerpt":{"rendered":"<p>Introduction With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty. Before we start make sure you have enabled Google Classroom APIs.\u00a0 Create new Google Classrooms 1. Enter the Classroom Audit menu then click on the Classroom tab. 2. Use the [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[22],"glossaries":[],"doc_tag":[24],"class_list":["post-519","docs","type-docs","status-publish","hentry","doc_category-classroom-management","doc_tag-gat"],"year_month":"2026-04","word_count":916,"total_views":"4919","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"osaid","author_nicename":"osaid","author_url":"https:\/\/gatlabs.com\/knowledge\/author\/osaid\/"},"doc_category_info":[{"term_name":"Classroom Audit &amp; Management","term_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips-category\/classroom-management\/"}],"doc_tag_info":[{"term_name":"GAT+","term_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips-tag\/gat\/"}],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Bulk Create, Export, and Update Google Classrooms - GAT Knowledge Base<\/title>\n<meta name=\"description\" content=\"With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Bulk Create, Export, and Update Google Classrooms\" \/>\n<meta property=\"og:description\" content=\"With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/\" \/>\n<meta property=\"og:site_name\" content=\"GAT Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-23T15:52:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/\",\"name\":\"How to Bulk Create, Export, and Update Google Classrooms - GAT Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/2022-01-24-13_39_52-Films-TV.png\",\"datePublished\":\"2022-01-23T14:16:10+00:00\",\"dateModified\":\"2022-09-23T15:52:05+00:00\",\"description\":\"With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/2022-01-24-13_39_52-Films-TV.png\",\"contentUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/2022-01-24-13_39_52-Films-TV.png\",\"width\":1920,\"height\":646},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/how-to-bulk-create-export-and-update-google-classrooms\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tech Tips\",\"item\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/tech-tips\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Bulk Create, Export, and Update Google Classrooms\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/\",\"name\":\"GAT Knowledge Base\",\"description\":\"Your source of all things GAT\",\"publisher\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#organization\",\"name\":\"GAT Labs Knowledge Base\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Group-1159.svg\",\"contentUrl\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Group-1159.svg\",\"width\":361,\"height\":97,\"caption\":\"GAT Labs Knowledge Base\"},\"image\":{\"@id\":\"https:\\\/\\\/gatlabs.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Bulk Create, Export, and Update Google Classrooms - GAT Knowledge Base","description":"With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/","og_locale":"en_GB","og_type":"article","og_title":"How to Bulk Create, Export, and Update Google Classrooms","og_description":"With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty.","og_url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/","og_site_name":"GAT Knowledge Base","article_modified_time":"2022-09-23T15:52:05+00:00","og_image":[{"url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/","url":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/","name":"How to Bulk Create, Export, and Update Google Classrooms - GAT Knowledge Base","isPartOf":{"@id":"https:\/\/gatlabs.com\/knowledge\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/#primaryimage"},"image":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/#primaryimage"},"thumbnailUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV.png","datePublished":"2022-01-23T14:16:10+00:00","dateModified":"2022-09-23T15:52:05+00:00","description":"With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty.","breadcrumb":{"@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/#primaryimage","url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV.png","contentUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/2022-01-24-13_39_52-Films-TV.png","width":1920,"height":646},{"@type":"BreadcrumbList","@id":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/how-to-bulk-create-export-and-update-google-classrooms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gatlabs.com\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Tech Tips","item":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/"},{"@type":"ListItem","position":3,"name":"How to Bulk Create, Export, and Update Google Classrooms"}]},{"@type":"WebSite","@id":"https:\/\/gatlabs.com\/knowledge\/#website","url":"https:\/\/gatlabs.com\/knowledge\/","name":"GAT Knowledge Base","description":"Your source of all things GAT","publisher":{"@id":"https:\/\/gatlabs.com\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gatlabs.com\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/gatlabs.com\/knowledge\/#organization","name":"GAT Labs Knowledge Base","url":"https:\/\/gatlabs.com\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/gatlabs.com\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/Group-1159.svg","contentUrl":"https:\/\/gatlabs.com\/knowledge\/wp-content\/uploads\/2021\/11\/Group-1159.svg","width":361,"height":97,"caption":"GAT Labs Knowledge Base"},"image":{"@id":"https:\/\/gatlabs.com\/knowledge\/#\/schema\/logo\/image\/"}}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/comments?post=519"}],"version-history":[{"count":16,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/519\/revisions"}],"predecessor-version":[{"id":5168,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/docs\/519\/revisions\/5168"}],"wp:attachment":[{"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/media?parent=519"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_category?post=519"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/glossaries?post=519"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/gatlabs.com\/knowledge\/wp-json\/wp\/v2\/doc_tag?post=519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}