[\/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=”{}” theme_builder_area=”post_content”][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” theme_builder_area=”post_content”][\/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″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Why export data from Google Sheets?<\/h2>\n
The \u2018Share\u2019 feature in Google Sheets isn\u2019t necessarily the best way to share your data. The main reason is that there is no way to control exactly what people have access to – they are able to view the entire spreadsheet. In the majority of business situations, spreadsheets contain a lot of important, private data that needs to be protected.<\/p>\n
With the Sheetgo add-on, you can send specific data from spreadsheets that allows you to keep data private. Let\u2019s say I\u2019m creating a spreadsheet detailing each of my employee\u2019s performance for the year. I can\u2019t use Google\u2019s \u2018Share\u2019 feature because each employee would have access to the other employee\u2019s private performance data. So, using the Sheetgo add-on, I can make sure that this data remains private, only sharing specific data with the corresponding employee.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
How to export data from Google Sheets<\/h2>\n
With the Sheetgo add-on for Google Sheets, you can choose exactly how much data you want to share. Sheetgo will export your specific data to a new or existing spreadsheet, which you can then share with recipients.<\/p>\n
Sheetgo offers two ways to export specific data from Google Sheets. Firstly, you can use export a specific tab from your spreadsheets. Secondly, you can use the Filter features to select specific columns or groups of data to export. Let\u2019s look at both versions and how to use them within the Sheetgo add-on.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
How to automatically export a tab from one Google Sheet to another<\/h3>\n
Let\u2019s use the example mentioned above. I have a Google Sheets file dedicated to my employee\u2019s performance during the past year. There is a tab dedicated to each employee, containing extremely private data.<\/p>\n
I want to export each specific tab to a new spreadsheet which I can send to the corresponding employee.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS.png” alt=”Export Google Sheets 0″ title_text=”Export GS” align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
1. Install Sheetgo<\/h4>\n
Firstly, you need to install the Sheetgo add-on into Google Sheets. Do so by clicking the blue button below. It takes you to the Google Workspace Marketplace where you can directly install the add-on. Make sure you sign up to Sheetgo.<\/p>\n
Alternatively, open Google Sheets and head to Add ons > Get add-ons<\/strong>. Search for Sheetgo, click on the result and click the Install<\/strong> button.[\/et_pb_text][et_pb_button button_url=”https:\/\/workspace.google.com\/marketplace\/app\/sheetgo_connect_filter_merge_sheets_exce\/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” 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” global_module=”45040″ theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Now that the add-on is installed, simply open it by heading back to the Extensions<\/b> and Add-ons<\/b> menu and click Sheetgo > Start<\/b>. The add-on should open up on the right-hand side of your screen.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-1.png” alt=”Export Google Sheets 1″ title_text=”Export GS 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Under the Export data<\/b> section, click Select data<\/b>. [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-2.png” alt=”Export Google Sheets 2″ title_text=”Export GS 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n As you can see below, our open file is automatically selected. Now, choose the tab you wish to export. In this example, I want to export Garry\u2019s performance data, so I\u2019ll select his tab.<\/p>\n You can also expand the Settings<\/b> to enable transfer formatting.<\/p>\n Once finished, click Continue<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-3.png” alt=”Export Google Sheets 3″ title_text=”Export GS 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/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_colors_info=”{}” global_module=”44981″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][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=”{}” theme_builder_area=”post_content”]<\/p>\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” theme_builder_area=”post_content”][\/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″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Scroll down to the Send data<\/b> section and select the type of file you wish to export your tab to.<\/p>\n In this example, I want to export my data to another Google Sheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-4.png” alt=”Export Google Sheets 4″ title_text=”Export GS 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n You can choose to export your data to a new or existing sheet. You can also edit the destination of the file, as well as the file name and new file tab. <\/p>\n Once you\u2019re happy with everything, click Finish and save<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-5.png” alt=”Export Google Sheets 5″ title_text=”Export GS 5″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Your data has been successfully exported from Google Sheets. You can repeat this process again for any other tabs you wish to export.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-6.png” alt=”Export Google Sheets 6″ title_text=”Export GS 6″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Sometimes you want to even more selective about the data you export than just a simple tab. Perhaps there are only certain columns or rows of data that we want to export from Google Sheets. Or perhaps we want to export the rows that contain a certain number. The Sheetgo add-on offers a Filter<\/b> feature which allows you to filter down the data you wish to export even further.<\/p>\n To demonstrate this, let\u2019s imagine that I have a Google Sheets file with all employee performance data in one tab.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-7.png” alt=”Export Google Sheets 7″ title_text=”Export GS 7″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n My boss has sent over different types of data he wants to see:<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n I can use any of the Filter<\/b> functions within the Sheetgo web app to filter specific data to meet each of these requests, rather than simply by tab.<\/p>\n In order to use these filters, follow Steps 1 and 2 in the instructions above, then use one of the 3 filter options we will now look at below.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n The Filter by condition<\/b> function allows you to create either single or multiple conditions that Sheetgo tests your data against. Any data that fulfills the condition(s) will be exported.<\/p>\n With the filter condition, I can achieve request one by my boss – exporting the data of employees who scored a total score of 50 or over.<\/p>\n Once you have selected your Google Sheets file and selected tab, scroll down to the Filter data<\/b> section and select Filter by condition<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-8.png” alt=”Export Google Sheets 8″ title_text=”Export GS 8″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Here you can choose to create a single or multiple conditions. For this example, I can create one single condition. Then, choose the column, condition type, and value.<\/p>\n In order to create my condition, I need to select Column J (Total score), the condition \u201cis greater than or equal to\u201d, and type in the value \u201850\u2019.<\/p>\n Once finished, click Continue<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-9.png” alt=”Export Google Sheets 9″ title_text=”Export GS 9″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Continue through the steps as normal, adding your destination folder. Once completed, press Finish and save<\/b>.<\/p>\n As you can see, Sheetgo has exported the data of only the employees who scored 50 or more as their total score.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-10.png” alt=”Export Google Sheets 10″ title_text=”Export GS 10″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/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_colors_info=”{}” global_module=”44982″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][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=”{}” theme_builder_area=”post_content”]<\/p>\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” theme_builder_area=”post_content”][\/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″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n The Filter by query<\/b> function allows you two write queries similar to SQL. For this filter function, I can achieve the second request from my boss – to send over only the employee names and average score columns.<\/p>\n Once you have selected your Google Sheets file and selected tab, scroll down to the Filter data<\/b> section and select Filter by query<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-11.png” alt=”Export Google Sheets 11″ title_text=”Export GS 11″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n As you can see, Sheetgo has already made this section easier, by creating buttons for each column. Simply add the columns you wish to export.<\/p>\n For example, I need to select Column A and K.<\/p>\n Once you\u2019re happy with your query, click Continue<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-12.png” alt=”Export Google Sheets 12″ title_text=”Export GS 12″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Continue through the steps as normal, adding your destination folder. Once completed, press Finish and save<\/b>.<\/p>\n As you can see, Sheetgo has successfully exported only Column A and K from my original spreadsheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-13.png” alt=”Export Google Sheets 13″ title_text=”Export GS 13″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Finally, the Filter by color<\/b> function allows you to select specific data based on cell color. Using this, I can therefore fulfill the final request for my boss – to send over the data of the lowest scoring employee. Both the highest and lowest employee are in color; the highest in green, the lowest in red. So, using this filter, I can easily select the data in the red cells to export.<\/p>\n Once you have selected your Google Sheets file and selected tab, scroll down to the Filter data<\/b> section and select Filter by color<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-14.png” alt=”Export Google Sheets 14″ title_text=”Export GS 14″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Choose the column where you want to filter by color. In this example, it doesn\u2019t particularly matter which column we choose. Then, from the dropdown, choose your chosen cell color.<\/p>\n Once finished, click Continue<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-15.png” alt=”Export Google Sheets 15″ title_text=”Export GS 15″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Continue through the steps as normal, adding your destination folder. Once completed, press Finish and save<\/b>.<\/p>\n As you can see below, Sheetgo has exported Alexandro\u2019s data, the correct employee who had the lowest score.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Export-GS-16.png” alt=”Export Google Sheets 16″ title_text=”Export GS 16″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n And there you have it! With the Sheetgo add-on, you can export a wide range of selected data to suit your needs. Sheetgo\u2019s Filter features are a great asset to have when filtering down your data in a variety of ways.<\/p>\n Now you know how to export data automatically, why not learn how to import? Check out our blog post on How to import specific columns to Google Sheets<\/a>.<\/p>\n Alternatively, check out our related blog posts below!<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.4.8″ background_color=”#f9f9ff” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}”]<\/p>\n Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n \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_colors_info=”{}” global_module=”44987″ theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][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=”{}” theme_builder_area=”post_content”]<\/p>\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” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" As a cloud-based tool, Google Sheets is fantastic to collaborate on spreadsheets with multiple team members. Google Sheets offers a \u2018Share\u2019 feature that allows you to share your entire Google Sheets files with others. Although this is useful in some cases, the majority of the time you want to only share specific parts of the […]<\/p>\n","protected":false},"author":41,"featured_media":38362,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Google Sheets has been evolving around that ideology of collaboration and teamwork. With Google Sheets application, we can readily \"Share\" an entire spreadsheet with another user.\u00a0But, it is not possible to share a specific subset of information from it. We have the IMPORTRANGE<\/a> function at our disposal, which we can use<\/a> to import specific data from another spreadsheet. But we cannot do the opposite. The reason is that, currently, there is no native Google Sheets functionality that lets us export data from Google Sheets.\n2. Choose tab and export data<\/h4>\n
Connect, merge, filter or split your\u00a0 spreadsheets<\/span><\/h4>\n
3. Choose destination<\/h4>\n
How to export selective data to another Google Sheet automatically<\/h3>\n
\n
Option 1: Filter by condition<\/h4>\n
Connect<\/span> your spreadsheets to your data sources<\/h4>\n
Option 2: Filter by query<\/h4>\n
Option 3: Filter by color<\/h4>\n
Automatically export data from Google Sheets<\/h3>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n
Why export data from Google Sheets?<\/h3>\nSylvia is a business analyst at one of the local food processing units. Jamie is her assistant who uses sales reports to reach out to customers, to inquire about their overall experience with the products they purchased. Here is how his typical spreadsheet looks like.\n\n[panel type=\"default\"] Example<\/strong>
![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportdata1.png\")
[\/panel]\n\nSylvia's main task is that she has to come up with the average satisfaction scores that each product receives. So, Jamie has to just share with her the data from columns B and G. The client and sales information is not as important. Therefore Jamie doesn't need to share the data from the columns A, C, D, E, and F.\n\nSince there is no direct way to eliminate the unnecessary information, to date, Jamie has been doing the following.\n\n \t
Solution: Export data from Google Sheets using Sheetgo add-on<\/h3>\nSheetgo add-on for Google Sheets boosts the connectivity of spreadsheets to the next level. With Sheetgo we can import, export, merge, stack or mirror data. If not already installed, we can get it by clicking the button below:\n\n[panel][ccj id=\"Install Widget\"][\/panel]\n\n[button type=\"big\" color=\"green\"] Link text[\/button]\n\nWith this rather extremely handy tool, we can configure Google Sheets to automatically export data from Google Sheets, even with predefined conditions if need be!. Not only that, we can even configure the frequency at which these exports can happen \u2013 hourly, daily, weekly or monthly. The export takes place from the current spreadsheet to other spreadsheets \u2013\u00a0both ours and other users\u2019.\n
Configuration: Steps to automatically export data from Google Sheets<\/h3>\nFor the purposes of illustration, we are going to export data range from the Sales Data + Satisfaction Survey<\/strong> file to Satisfaction Survey Analysis<\/strong> file which Sylvia owns. For this to happen, it is a pre-requisite that Sylvia grants her write access permissions to the Satisfaction Survey Analysis<\/strong>\u00a0file, without which, this automation won't work.\n
1. Start Sheetgo and initiate an export link connection<\/h4>\nNow that we have Sheetgo installed on our Google Sheets application, we now open the \u201cSales Data + Satisfaction Survey<\/strong>\u201d file. To start the add-on, we navigate to Add-ons > Sheetgo > Start<\/strong>.\n\n[panel type=\"default\"] Example<\/strong>
![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportdata2.png\")
[\/panel]\n\nDoing so will open the Sheetgo interface on the screen as a sidebar. Hover the mouse pointer over the green circle with a plus, and click on the Export<\/strong> option.\n2. Link source sheet with the destination file that we need to send the data to<\/h4>\nClicking the Connect<\/strong> option leads us to the list of most recently updated files by default. In case the Sylvia wants that the data be preserved rather than refreshed every day, Jamie could go with Append<\/strong> option.\n\nIf we don\u2019t see the file we want, we can use the search module to lookup a file within the Google Drive. For this example, we select Satisfaction Survey Analysis<\/strong>\u00a0file for destination spreadsheet, and then for source sheet choose Sales + Survey<\/strong>.\n\n[panel type=\"default\"] Example<\/strong>
![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportdata3.png\")
[\/panel]\n\nWe then arrive at the settings screen. Here we can select the frequency of updates in the \u201cAutomatic update<\/strong>\u201d section. We change the option to \u2018Monthly\u2019 because Jamie needs to send data from \u2018Sales Data + Survey Information<\/strong>\u2019 file every month.\n3. Add the filter condition for selective data import, and create a connection<\/h4>\nPlease note that if we\u00a0ignore the process of adding a filter condition altogether and click on CONNECT<\/strong> at this point, Sheetgo exports entire data range from the\u00a0Sales + Survey<\/strong> sheet.\n\nBut in this example, we are exporting only columns B and G. 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 No active filter<\/strong>. Click on \u2018edit<\/strong>\u2018 to add a condition. Choose \u2018Query Language<\/strong>\u2018 option, and key in the following statement.\n\n[panel]SELECT B, G<\/strong>[\/panel]\n\nThe Filter by<\/strong>\u00a0section now shows \u201cSELECT B, G<\/strong>\u201d. Just to avoid any confusion, we change the connection name to Survey_Export<\/strong>. Finally, to create a connection link that can automatically export data from Google Sheets, we click the\u00a0CONNECT<\/strong>\u00a0button.\n\n[panel]\u00a0Example\u00a0
![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportdata4.png\")
<\/strong>[\/panel]\n\nDoing so will create a new sheet by name Survey_Export<\/strong> in the Satisfaction Survey Analysis file, that will contain exported survey data. Here's how it looks.\n\n[panel type=\"default\"] Example<\/strong> ![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportdata5.png\")
[\/panel]\nAutomatic connection<\/h3>\nThe data export keeps happening automatically and periodically once the appropriate connection is in place. Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.\n\nConnection name<\/strong> (in this case \u201cSurvey_Export\u201d) > edit<\/strong> (the pencil icon) > Automatic update<\/strong> > edit<\/strong>.\n\nClick on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43,28],"class_list":["post-5768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/5768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=5768"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/5768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/38362"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=5768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=5768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=5768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}