{"id":260378,"date":"2026-04-21T19:44:41","date_gmt":"2026-04-21T17:44:41","guid":{"rendered":"https:\/\/www.sheetgo.com\/?page_id=260378"},"modified":"2026-05-18T21:34:49","modified_gmt":"2026-05-18T19:34:49","slug":"trouver-et-remplacer","status":"publish","type":"page","link":"https:\/\/www.sheetgo.com\/fr\/tools\/find-and-replace\/","title":{"rendered":"Rechercher et remplacer du texte dans des feuilles de calcul"},"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>Find and Replace in CSV, Excel, and Google Sheets<\/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>Bulk edit text \u2014 exact match or substring, case-sensitive, column-scoped<\/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>Search any CSV, Excel, or Google Sheets file and replace text in bulk. Match exact cells or substrings, case-sensitive or not, across all columns or just the ones you pick. Free, in-browser, 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;\">Set find, replace, rules<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Type your terms, pick exact-cell match or substring, case-sensitive or not, all or specific columns.<\/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 updated file<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Get the file with every match replaced, ready to share.<\/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\/findreplace\/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;\">Need the same find-and-replace across hundreds of files, or every time new data arrives? Sheetgo can run this replacement on a schedule across your Google Drive and push the cleaned output to your downstream reports.<\/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 bulk find and replace<\/h3>\n<p>Get the answers to your questions about find and replace in spreadsheets[\/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;Does it match substrings or only whole cells?&#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>You choose. Pick &#8220;exact&#8221; to only replace cells that equal your search term, or &#8220;contains&#8221; to replace anywhere the term appears within a cell.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Is it case-sensitive?&#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>You choose. Toggle case sensitivity on or off per replacement.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Can I limit it to specific columns?&#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. By default it runs on all columns; you can narrow it to one or more specific columns.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Can I find and replace in 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 BigQuery query or a REST API response and apply your find-and-replace rules on the returned dataset.<\/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>Find and Replace in CSV, Excel, and Google SheetsBulk edit text \u2014 exact match or substring, case-sensitive, column-scopedSearch any CSV, Excel, or Google Sheets file and replace text in bulk. Match exact cells or substrings, case-sensitive or not, across all columns or just the ones you pick. Free, in-browser, no signup.How it worksStep 1Connect your [&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-260378","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/260378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=260378"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/260378\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/pages\/260374"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=260378"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/difl_page_category?post=260378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}