{"id":260377,"date":"2026-04-21T19:44:38","date_gmt":"2026-04-21T17:44:38","guid":{"rendered":"https:\/\/www.sheetgo.com\/?page_id=260377"},"modified":"2026-05-18T21:34:48","modified_gmt":"2026-05-18T19:34:48","slug":"filtrar-por-condicao","status":"publish","type":"page","link":"https:\/\/www.sheetgo.com\/pt\/tools\/filter-by-condition\/","title":{"rendered":"Filtrar Linhas da Planilha por Condi\u00e7\u00e3o"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_type=&#8221;circular&#8221; background_color_gradient_direction_radial=&#8221;top right&#8221; background_color_gradient_stops=&#8221;#d9e7ff 0%|#efedff 15%|#ffffff 30%|#ffffff 100%&#8221; custom_padding=&#8221;10px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;align-items: center;&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text module_class=&#8221;section-title&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; header_font=&#8221;|300|||||||&#8221; header_text_color=&#8221;#003999&#8243; header_font_size=&#8221;16px&#8221; header_2_font=&#8221;|300|||||||&#8221; header_2_text_color=&#8221;#003999&#8243; header_2_font_size=&#8221;16px&#8221; background_color=&#8221;#d9e7ff&#8221; custom_padding=&#8221;8px|10px|8px|10px|true|true&#8221; custom_css_main_element=&#8221;width: fit-content;&#8221; border_radii=&#8221;on|15px|15px|15px|15px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>Filter CSV, Excel, and Google Sheets by Condition<\/h1>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; header_2_font=&#8221;|800|||||||&#8221; header_2_font_size=&#8221;50px&#8221; header_2_line_height=&#8221;0.9em&#8221; header_3_font=&#8221;|800|||||||&#8221; header_3_font_size=&#8221;50px&#8221; header_3_line_height=&#8221;0.9em&#8221; header_2_font_size_tablet=&#8221;50px&#8221; header_2_font_size_phone=&#8221;38px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; header_2_line_height_tablet=&#8221;0.9em&#8221; header_2_line_height_phone=&#8221;0.8em&#8221; header_2_line_height_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Keep only the rows you want \u2014 equals, contains, greater than, and more<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Filter any spreadsheet by column and condition: equals, contains, starts with, greater than, less than, is empty, is not empty, and more. Works on CSV, Excel, Google Sheets, BigQuery, and REST APIs. In-browser, free, no signup.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;#Tool&#8221; button_text=&#8221;Use the tool&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#FFFFFF&#8221; button_bg_color=&#8221;#2979FF&#8221; button_border_width=&#8221;0px&#8221; button_border_color=&#8221;#2979FF&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|600|||||||&#8221; button_icon=&#8221;&#xf063;||fa||900&#8243; button_on_hover=&#8221;off&#8221; custom_padding=&#8221;15px|35px|15px|20px|true|false&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_text_color__hover_enabled=&#8221;on|desktop&#8221; button_border_color__hover_enabled=&#8221;on|hover&#8221; button_border_color__hover=&#8221;#2666E2&#8243; button_text_color__hover=&#8221;#FFFFFF&#8221; button_bg_color__hover=&#8221;#2666E2&#8243; button_bg_enable_color__hover=&#8221;on&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3 style=\"color:#003999;margin-bottom:16px;\">How it works<\/h3>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div style=\"background:#ffffff;border:1px solid #deeaf7;border-radius:12px;padding:18px 22px;margin-bottom:14px;box-shadow:0 2px 10px rgba(0,57,153,0.04);\">\n<div style=\"color:#003999;font-weight:600;font-size:13px;letter-spacing:0.5px;text-transform:uppercase;margin-bottom:4px;\">Step 1<\/div>\n<div style=\"font-weight:600;font-size:17px;margin-bottom:6px;color:#1a1a1a;\">Connect your data<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Upload CSV, Excel, or TSV, pick a Sheet from Google Drive, run a BigQuery query, or pull from a REST API.<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div style=\"background:#ffffff;border:1px solid #deeaf7;border-radius:12px;padding:18px 22px;margin-bottom:14px;box-shadow:0 2px 10px rgba(0,57,153,0.04);\">\n<div style=\"color:#003999;font-weight:600;font-size:13px;letter-spacing:0.5px;text-transform:uppercase;margin-bottom:4px;\">Step 2<\/div>\n<div style=\"font-weight:600;font-size:17px;margin-bottom:6px;color:#1a1a1a;\">Pick column + condition<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Choose any column, then a condition like equals, contains, starts with, greater than, is empty, and more.<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div style=\"background:#ffffff;border:1px solid #deeaf7;border-radius:12px;padding:18px 22px;margin-bottom:14px;box-shadow:0 2px 10px rgba(0,57,153,0.04);\">\n<div style=\"color:#003999;font-weight:600;font-size:13px;letter-spacing:0.5px;text-transform:uppercase;margin-bottom:4px;\">Step 3<\/div>\n<div style=\"font-weight:600;font-size:17px;margin-bottom:6px;color:#1a1a1a;\">Download the filtered file<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Get just the rows that matched, ready to use.<\/div>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; width=&#8221;92%&#8221; max_width=&#8221;1280px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_code module_id=&#8221;Tool&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; min_height=&#8221;400px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div id=\"sheetgo-tool-embed\" style=\"width:100%;\"><\/div>\n<p><script>(function(){function getCookie(n){var m=document.cookie.match(new RegExp('(?:^|; )'+n.replace(\/[-.+*?^${}()|[]\\]\/g,'\\$&')+'=([^;]*)'));return m?decodeURIComponent(m[1]):null;}var lang=getCookie('trp_language')||'en';var i=document.createElement('iframe');i.src='https:\/\/www.sheetgo.com\/mini-apps\/filter\/index.html?lang='+encodeURIComponent(lang);i.style.width='100%';i.style.height='900px';i.style.border='none';i.setAttribute('loading','lazy');i.setAttribute('title','Sheetgo mini-app');i.setAttribute('allow','clipboard-read; clipboard-write');document.getElementById('sheetgo-tool-embed').appendChild(i);})();<\/script>[\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_type=&#8221;circular&#8221; background_color_gradient_direction_radial=&#8221;bottom left&#8221; background_color_gradient_stops=&#8221;#d9e7ff 0%|#efedff 20%|#ffffff 40%|#ffffff 100%&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; text_orientation=&#8221;center&#8221; max_width=&#8221;780px&#8221; module_alignment=&#8221;center&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>Want to schedule this, not just run it once?<\/h3>\n<p style=\"font-size:18px;\">Filtering the same data every time your team adds new rows? Sheetgo can run this filter automatically \u2014 every hour, every morning, every Monday \u2014 and push the filtered subset into a separate sheet or dashboard.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/04\/google-workspace-add-on.svg&#8221; alt=&#8221;Get Sheetgo on Google Workspace Marketplace&#8221; title_text=&#8221;google-workspace-add-on&#8221; url=&#8221;https:\/\/workspace.google.com\/marketplace\/app\/sheetgo\/94172092257&#8243; url_new_window=&#8221;on&#8221; align=&#8221;center&#8221; admin_label=&#8221;B \/ CTA \/ SHEETS \/ CENTER&#8221; module_class=&#8221;add-n-button&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; min_height=&#8221;56px&#8221; height=&#8221;56px&#8221; global_module=&#8221;225051&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;50px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text module_class=&#8221;section-title&#8221; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; header_font=&#8221;|300|||||||&#8221; header_text_color=&#8221;#003999&#8243; header_font_size=&#8221;16px&#8221; header_2_font=&#8221;|300|||||||&#8221; header_2_text_color=&#8221;#003999&#8243; header_2_font_size=&#8221;16px&#8221; background_color=&#8221;#d9e7ff&#8221; custom_padding=&#8221;8px|10px|8px|10px|true|true&#8221; custom_css_main_element=&#8221;width: fit-content;&#8221; border_radii=&#8221;on|15px|15px|15px|15px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Frequently Asked Question<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>Dive deeper into filtering spreadsheet data<\/h3>\n<p>Get the answers to your questions about conditional data filtering[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][difl_faq enable_schema=&#8221;on&#8221; close_icon_color=&#8221;#82afff&#8221; close_icon_size=&#8221;28px&#8221; open_icon_color=&#8221;#82afff&#8221; faq_anime_duration=&#8221;200&#8243; faq_item_wrapper_bg_bgcolor=&#8221;#f3f7fc&#8221; que_text_margin=&#8221;10px|20px|10px|20px|true|true&#8221; ans_text_padding=&#8221;0px|20px|10px|20px|false|true&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; question_text_font=&#8221;|600|||||||&#8221; question_text_font_size=&#8221;19px&#8221; design_answer_text_font=&#8221;|300|||||||&#8221; design_answer_text_font_size=&#8221;16px&#8221; design_answer_text_line_height=&#8221;1.6em&#8221; border_radii_faq_item_wrapper_border=&#8221;on|12px|12px|12px|12px&#8221; border_color_all_faq_item_wrapper_border=&#8221;#deeaf7&#8243; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;][difl_faqitem question=&#8221;What conditions can I use?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Equals, does not equal, contains, does not contain, starts with, ends with, greater than, less than, is empty, is not empty.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Can I filter on multiple columns at once?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Yes \u2014 stack multiple conditions and the tool keeps rows matching all of them.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Does it modify my original file?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>No. The tool produces a new filtered file; your original is untouched.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Can I filter data from BigQuery or an API?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Yes. Connect a live BigQuery query or a REST API response and apply the same filter conditions.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;What else can I do with the Sheetgo add-on?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>Beyond scheduled automation, the Sheetgo add-on \u2014 powered by Sheetgo Workflows \u2014 can send personalized emails from spreadsheet rows, generate Google Docs or PDFs as mail-merge outputs, chain multiple processing steps into one flow (for example: filter &rarr; merge &rarr; dedupe &rarr; email), and orchestrate approvals across teams. Everything runs unattended once set up. One-click install from Google Workspace Marketplace.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Which data sources can I connect to with Sheetgo?&#8221; question_title_tag=&#8221;h3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; design_answer_text_line_height=&#8221;1.4em&#8221; global_colors_info=&#8221;{}&#8221; que_wrapper_bg_bgcolor__hover=&#8221;1px||||false|false&#8221; que_wrapper_bg_bgcolor__hover_enabled=&#8221;on|hover&#8221;]<\/p>\n<p>With the Sheetgo add-on, your automated flows can pull from Google Sheets, Excel, CSV files in Google Drive, BigQuery (with live SQL queries), and any REST API using Bearer Token, API Key, or Basic authentication. The output can land back in a spreadsheet, a generated Google Doc or PDF, an email, or any combination chained in a Workflow.<\/p>\n<p>[\/difl_faqitem][\/difl_faq][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.27.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/workflow_build-workflow.webp&#8221; alt=&#8221;FAQ image&#8221; title_text=&#8221;workflow_build-workflow&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Filter CSV, Excel, and Google Sheets by ConditionKeep only the rows you want \u2014 equals, contains, greater than, and moreFilter any spreadsheet by column and condition: equals, contains, starts with, greater than, less than, is empty, is not empty, and more. Works on CSV, Excel, Google Sheets, BigQuery, and REST APIs. In-browser, free, no signup.How [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":260374,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-260377","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/260377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=260377"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/260377\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/260374"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=260377"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/difl_page_category?post=260377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}