{"id":3362,"date":"2017-03-23T14:26:05","date_gmt":"2017-03-23T17:26:05","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=3362"},"modified":"2017-03-23T14:26:05","modified_gmt":"2017-03-23T17:26:05","slug":"exportar-desde-google-sheets-multiples-conjuntos-de-datos","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/how-to-solve-with-sheetgo\/export-from-google-sheets-multiple-data-sets\/","title":{"rendered":"Exportaci\u00f3n de varios conjuntos de datos a varias hojas de c\u00e1lculo"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

When personal computers were invented, one of the prime reasons that made them appealing was spreadsheets application. And today, it\u00a0is almost impossible to imagine our work without spreadsheets. Initially, they were mostly used by a single user in the offline mode. With\u00a0Google Sheets<\/a>, the transition is made to online-multi-user mode. Certainly, life is made a lot easier with such advancements. One of the most beneficial uses of it offers is collaboration. We can store them online and manage them across the team using appropriate access controls. Even though we have come a long way with this innovation front, there is still room for improvement. For instance, we can\u2019t export from Google Sheets yet. Let alone automatically exporting multiple data sets to multiple worksheets at the same time.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#d3e3ff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_module=”44972″ global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” header_font_size=”33px” header_4_font_size=”24px” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}”]<\/p>\n

Ready to streamline<\/span> your data?<\/h4>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Why export from Google Sheets?<\/h3>\n

Veronica is a computer operator at a local high school. Every week the school organizes paper-based tests across all grades to gauge students\u2019 performance. Students respond to these tests on OMR based answer sheets. Once the test is done, Veronica receives the response sheets from all the students and runs them through her software. Doing this will generate the scores of each student and consolidate them into a CSV file, which looks like this:<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportmulti8.png” alt=”Export From Google Sheets: Student List and Grades According to Different Subjects” title_text=”export-from-sheets” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

For the benefits we discussed at the beginning of this post, she stores this CSV on her Google Drive. Because she can access it using Google Sheets application from anywhere.\u00a0So, every time Veronica has a new CSV file, she copies the data onto Google Sheets.<\/p>\n

Now, at the end of this process, each class teacher needs to access his\/her pupils\u2019 scores. To illustrate this, let us consider the scores of students across three grades \u2013 3, 4 and 5.\u00a0Garrett, Henry, and\u00a0Theresa are the class teachers respectively.\u00a0Garrett would be interested in scores of 3rd-grade scores, and he doesn\u2019t really need scores from other grades. Same is the case with Henry and Theresa. Manually segregating data and sharing it accordingly with the required stakeholders is an option, but not an ideal one. More so, when she has to do it with higher frequency and when there are many grades to deal with.<\/p>\n

Solution: automate the process with Sheetgo<\/h3>\n

The\u00a0<\/span>Sheetgo add-on for Google Sheets\u00a0elevates the connectivity between spreadsheets to the next level. With this we\u00a0can import, export, merge, or stack data. It can automatically manage all the heavy-lifting that Veronica had to otherwise manually do. We can install it on our Google Sheets by clicking the button below:<\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/workspace.google.com\/marketplace\/app\/sheetgo\/94172092257″ url_new_window=”on” button_text=”INSTALL FOR FREE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”30px||30px||true|false” custom_padding=”15px|20px|15px|20px|true|true” global_module=”45040″ saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Once done, we can configure to\u00a0<\/span>export from Google Sheets multiple data sets subject to the predefined frequency and filter conditions. The export takes place from the current spreadsheet to other spreadsheets \u2013\u00a0both ours and other users\u2019.<\/p>\n

Configuration: Steps to export from Google Sheets<\/h3>\n

For the purposes of demonstration, we will use\u00a0four spreadsheets as listed below.<\/p>\n

    \n
  1. All Grades \u2013 Scores<\/li>\n
  2. Third Grade \u2013 Scores<\/li>\n
  3. Fourth Grade \u2013 Scores<\/li>\n
  4. Fifth Grade \u2013 Scores<\/li>\n<\/ol>\n

    We will try and configure auto-export functionality from\u00a0<\/span>All Grades \u2013 Scores<\/strong>\u00a0<\/span>file to the next three files. But before that, Veronica imports the scores data using the procedure explained in this\u00a0<\/span>post<\/a>. Here\u2019s how it looks after importing the data from the CSV file using the Sheetgo Add-on.<\/p>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportmulti1.png” alt=”Imported CSV File Example” title_text=”import-csv-file” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”100%” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

    Please note that the files corresponding to third, fourth, and fifth-grade files are external files (i.e. other users shared them with edit access control).<\/p>\n

    We will try with the\u00a0<\/span>Third Grade \u2013 Scores<\/strong>\u00a0<\/span>file first. Below is the sequence of steps to do so.<\/p>\n

    1. Start\u00a0Sheetgo and initiate an export link connection<\/h4>\n

    If not already running, navigate to\u00a0Add-ons > Sheetgo > Start, while we are on the All Grades \u2013 Scores<\/strong>\u00a0file, to start the Sheetgo add-on. Doing so will open the Sheetgo sidebar as similar to the one shown in the second snapshot. Hover the mouse pointer over the green circle with a plus, and click on the\u00a0<\/span>Export<\/strong>\u00a0<\/span>option.<\/p>\n

    2. Link source sheet with the destination file that we need to send the data to<\/h4>\n

    Click the Connect<\/strong>\u00a0option. This will lead us to the list of most recently updated files by default. If we don\u2019t see the file we want, we can look up the file within Google Drive using the search feature. For this example, we select Third Grade \u2013 Scores<\/strong>\u00a0file for \u2018Destination spreadsheet\u2019, and then for \u2018source sheet\u2019 choose Student_Test_Scores.csv<\/strong>.<\/p>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportmulti2.png” alt=”Selecting Source and Destination Spreadsheets” title_text=”source-destination-spreadsheets” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”100%” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

    We then arrive at the settings screen. Here we can select the frequency of updates in the Automatic update<\/strong> section. We change it to Weekly<\/strong>\u00a0<\/span>because Veronica updates the CSV every week. To avoid any confusion with the upcoming connections, let us change the connection name to Third_Grade_Scores<\/strong>.<\/p>\n

    [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44981″ global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}”]<\/p>\n

    Connect, merge, filter or split your\u00a0 spreadsheets<\/span><\/h4>\n

    [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

    3. Add the filter condition for selective data export, and create a connection<\/h4>\n

    To do this, we may have to scroll down a bit on the sidebar until we see Filter by<\/strong> section. By default, it shows \u201cNo active filter\u201d. Click on edit to add a condition. From the previous image, we realize that the Grade field is in column B. Since we need to create a filter based on Grade, we ensure it is \u201cColumn B: Grade\u201d in the first drop-down. And, we make sure that the second and third options are \u201cNumber is equal to\u201d and \u201c3\u201d respectively. Then we click on OK<\/strong>.<\/p>\n

    The Filter by section now shows \u201cColumn B number is equal to 3\u201d. Finally, to establish the link that can export multiple data sets, we click CONNECT<\/strong>\u00a0button.<\/p>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportmulti3.png” alt=”Export From Google Sheets: Filter By Feature with Sheetgo ” title_text=”filter-by-feature” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”100%” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

    Doing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \u201cLast update: Just now\u201d.<\/p>\n

    Congratulations! We\u2019ve just exported a filtered list of scores specific to the third grade! Let\u2019s check the Third Grade \u2013 Scores<\/strong>\u00a0file to see if the data has flown in.<\/p>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportmulti4.png” alt=”Exported Filtered Data: List of Student Grades” title_text=”filtered-data” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”100%” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

    Yes, it did! We see that Sheetgo creates a new sheet (name will be same as that of the connection), and accordingly puts only Third Grade data in it.<\/p>\n

    [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44982″ global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}”]<\/p>\n

    Connect<\/span> your spreadsheets to your data sources<\/h4>\n

    [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

    Create other connections<\/h3>\n

    We repeat the above steps to create connections for other files, in order to export multiple data sets, but with a couple of differences.<\/p>\n