{"id":16534,"date":"2019-06-19T20:34:53","date_gmt":"2019-06-19T18:34:53","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=16534"},"modified":"2019-06-19T20:34:53","modified_gmt":"2019-06-19T18:34:53","slug":"filtre-par-couleur-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/how-to-solve-with-sheetgo\/filter-by-color-in-google-sheets\/","title":{"rendered":"Filtre par couleur dans Google Sheets : Apprendre comment"},"content":{"rendered":"

[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ min_height=”4474px” custom_padding=”||0px|||” global_colors_info=”{}”][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

Google Sheets is one of the most intuitive and collaborative spreadsheet applications out there. Late March, its functionalities expanded even more by releasing a new feature: sort and filter cells by text or fill color<\/a>.\u00a0 Unfortunately, Google Sheets’ connectivity and filter options do come with some limitations. For example, there is no built-in functionality with which you can filter by color between<\/strong> Google Sheets. For that reason, Sheetgo created the feature and therefore enables the possibility to filter data, solely based on the cell color, from one spreadsheet to the other. Learn how to filter by color by following the simple steps below.<\/p>\n

[\/et_pb_text][\/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

Let’s get you started<\/h3>\n

Step 1. Install Sheetgo<\/h4>\n

Click on the button below to install the Sheetgo add-on for Google Sheets. First, sign in with your Google account. Second, complete the authorization steps, for Sheetgo to create your account simultaneously.<\/p>\n

[\/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.20.2″ global_colors_info=”{}”]<\/p>\n

For the purpose of demonstration, let’s say we have a spreadsheet called “Database”. It includes all relevant information about a list of employess and their annual salary. But we need to export data from only the Spanish emplyees (in yellow) to the “New database” spreadsheet.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-1.png” alt=”Filter color-1″ title_text=”Filter color-1″ align=”center” _builder_version=”4.21.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ global_colors_info=”{}”]<\/p>\n

Step 2. Open the add-on<\/h4>\n

Inside your destination spreadsheet “New database”, go to Menu<\/strong> > Add-ons<\/strong> > Sheetgo<\/strong> > Start<\/strong>. After that, Sheetgo opens as a sidebar on your screen. Click on ‘Import data from file’ to select your data source. In other words, select from which file you need to import the filtered data (in this case: “Database”).<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-3.png” alt=”Filter color-3″ title_text=”Filter color-3″ align=”center” _builder_version=”4.20.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

Select Sheet file(s)<\/strong> to import data from a spreadsheet.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-4.png” alt=”Filter color-4″ title_text=”Filter color-4″ align=”center” _builder_version=”4.20.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

Select the file and the tab you want to import data from.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-5.png” alt=”Filter color-5″ title_text=”Filter color-5″ align=”center” _builder_version=”4.20.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” 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

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” 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.20.2″ global_colors_info=”{}”]<\/p>\n

Step 3. Filter by color<\/h4>\n

Now select your data processor. Choose filter in order to filter data by color.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-6.png” alt=”Filter color-6″ title_text=”Filter color-6″ align=”center” _builder_version=”4.20.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ global_colors_info=”{}”]<\/p>\n

Choose Cell color<\/strong> to select data by color.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-7.png” alt=”Filter color-7″ title_text=”Filter color-7″ _builder_version=”4.20.2″ _module_preset=”default” width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ global_colors_info=”{}”]<\/p>\n

Choose which column you would like to filter (in this case: column C “Nationality”). After that, choose which color you want to filter out (in this case: yellow).<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-8.png” alt=”Filter color-8″ title_text=”Filter color-8″ _builder_version=”4.20.2″ _module_preset=”default” width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” 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

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” 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.20.2″ global_colors_info=”{}”]<\/p>\n

Step 4. Save the connection<\/h4>\n

Finally, click on ‘Save connection’<\/strong> to import only that specific data. As a result, Sheetgo creates a new tab in your destination spreadsheet. Here you can now see the information about all the Spanish employees, as we requested. Sheetgo has filtered out the “Nationality” column to only export the cells in yellow, as seen on the image below.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Filter-color-10.png” alt=”Filter color-10″ title_text=”Filter color-10″ align=”center” _builder_version=”4.20.2″ width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|phone” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

This is how you easily Filter by color in Google Sheets with Sheetgo! Check out the following blog post if you are curious about our other features that help boost your spreadsheet connectivity: how to track changes in Google Sheets<\/a>.<\/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_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

Connect everything and automate<\/span> entire business processes<\/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” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Google Sheets is one of the most intuitive and collaborative spreadsheet applications out there. Late March, its functionalities expanded even more by releasing a new feature: sort and filter cells by text or fill color.\u00a0 Unfortunately, Google Sheets’ connectivity and filter options do come with some limitations. For example, there is no built-in functionality with […]<\/p>\n","protected":false},"author":40,"featured_media":42182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-16534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/16534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=16534"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/16534\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=16534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=16534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=16534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}