{"id":260376,"date":"2026-04-21T19:44:37","date_gmt":"2026-04-21T17:44:37","guid":{"rendered":"https:\/\/www.sheetgo.com\/?page_id=260376"},"modified":"2026-05-18T21:34:48","modified_gmt":"2026-05-18T19:34:48","slug":"eliminar-duplicados","status":"publish","type":"page","link":"https:\/\/www.sheetgo.com\/es\/tools\/remove-duplicates\/","title":{"rendered":"Eliminar duplicados de hojas de c\u00e1lculo"},"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>Remove Duplicates from 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>Clean messy data in seconds \u2014 across all columns or just the ones you pick<\/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>Remove duplicate rows from any spreadsheet \u2014 CSV, Excel, or Google Sheets. Check all columns or just the ones you select. Choose whether to keep the first or last occurrence. Runs in your browser, no upload.<\/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;\">Choose the columns to check<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Match duplicates across all columns, or pick specific columns to use as the deduplication key.<\/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;\">Keep first or last + download<\/div>\n<div style=\"font-size:15px;color:#434F55;line-height:1.5;\">Choose whether to keep the first or last occurrence of each duplicate, then download the clean file.<\/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\/deduplicate\/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;\">Removing duplicates from the same data every week? Sheetgo can run this automatically \u2014 clean a live Google Sheet every time new rows arrive, and sync the clean version to a master report, Excel file, 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 removing duplicates from spreadsheets<\/h3>\n<p>Get the answers to your questions about deduplicating data[\/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 compare all columns, or can I choose?&#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>Both. By default, duplicates are detected when every column matches. You can also pick a subset of columns (for example, just the email column) to use as the deduplication key.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;What happens to duplicate rows?&#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: keep the first occurrence and drop the rest, or keep the last occurrence and drop the earlier ones.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Is my data uploaded anywhere?&#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 cleanup runs entirely in your browser.<\/p>\n<p>[\/difl_faqitem][difl_faqitem question=&#8221;Can I dedupe 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 your BigQuery query or a REST API endpoint and apply the same deduplication logic on live data.<\/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>Remove Duplicates from CSV, Excel, and Google SheetsClean messy data in seconds \u2014 across all columns or just the ones you pickRemove duplicate rows from any spreadsheet \u2014 CSV, Excel, or Google Sheets. Check all columns or just the ones you select. Choose whether to keep the first or last occurrence. Runs in your browser, [&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-260376","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/260376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=260376"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/260376\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/260374"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=260376"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/difl_page_category?post=260376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}