{"id":41,"date":"2026-09-17T08:19:55","date_gmt":"2026-09-17T08:19:55","guid":{"rendered":"https:\/\/yousofthub.com\/?p=41"},"modified":"2026-09-17T10:25:54","modified_gmt":"2026-09-17T10:25:54","slug":"eliminar-duplicados-en-excel","status":"publish","type":"post","link":"https:\/\/yousofthub.com\/en\/eliminar-duplicados-en-excel\/","title":{"rendered":"How to Find and Remove Duplicates in Excel and Google Sheets"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><strong>Learning how to remove duplicates in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong> and <a href=\"https:\/\/support.google.com\/docs\/answer\/9355796\" data-type=\"link\" data-id=\"https:\/\/support.google.com\/docs\/answer\/9355796\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a> is one of the most critical skills when managing professional spreadsheets. Across customer databases, product inventories, and sales logs, redundant entries skew reporting, corrupt core business metrics, and waste countless hours of manual data cleanup.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this step-by-step tutorial, we break down the most efficient ways to identify, highlight, and <strong>remove duplicates in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong>, alongside standard workflows for <a href=\"https:\/\/support.google.com\/docs\/answer\/9355796\" data-type=\"link\" data-id=\"https:\/\/support.google.com\/docs\/answer\/9355796\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a> to safeguard the integrity of your datasets.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li class=\"\"><a href=\"#por-que-aparecen-registros-repetidos-en-tus-hojas-de-calculo\">Why Do Duplicate Entries Appear in Your Spreadsheets?<\/a><\/li><li class=\"\"><a href=\"#metodo-1-resaltar-valores-repetidos-con-formato-condicional-en-excel\">Method 1: Highlight Duplicate Values with Conditional Formatting in<\/a><\/li><li class=\"\"><a href=\"#metodo-2-la-herramienta-nativa-para-eliminar-duplicados-en-excel\">Method 2: Native Tool to Remove Duplicates in<\/a><\/li><li class=\"\"><a href=\"#metodo-3-como-eliminar-duplicados-en-google-sheets\">Method 3: How to Remove Duplicates in Google Sheets<\/a><\/li><li class=\"\"><a href=\"#metodo-4-extraer-registros-unicos-mediante-formulas-sin-modificar-la-tabla-original\">Method 4: Extract Unique Records with Formulas (Non-Destructive)<\/a><\/li><li class=\"\"><a href=\"#metodo-5-filtrar-duplicados-mediante-filtro-avanzado-para-copiarlos-a-otra-ubicacion\">Method 5: Filter Duplicates Using Advanced Filter (Copy to Another Location)<\/a><\/li><li class=\"\"><a href=\"#resumen-que-metodo-elegir-segun-tu-caso\">Summary: Which Method Should You Choose?<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 id=\"por-que-aparecen-registros-repetidos-en-tus-hojas-de-calculo\" class=\"wp-block-heading\">Why Do Duplicate Entries Appear in Your Spreadsheets?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before sanitizing any spreadsheet, understanding how redundant data originates helps prevent recurring issues down the line. Common causes include:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Multiple imports:<\/strong> Merging CSV files or spreadsheets exported from different billing software or CRM platforms.<\/li>\n\n\n\n<li><strong>Manual entry by multiple users:<\/strong> Different team members logging the same lead, sale, or customer without checking existing records.<\/li>\n\n\n\n<li><strong>Typographical discrepancies:<\/strong> Slight variations such as stray trailing spaces or mismatched letter cases that prevent automatic matching.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"metodo-1-resaltar-valores-repetidos-con-formato-condicional-en-excel\" class=\"wp-block-heading\">Method 1: Highlight Duplicate Values with Conditional Formatting in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before you <strong>remove duplicates in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong>highlighting repeated records helps you audit exactly which rows will be affected:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Select your dataset or column:<\/strong> Highlight the cell range where you suspect recurring entries.<\/li>\n\n\n\n<li><strong>Access Conditional Formatting:<\/strong> Go to the Home tab <em>Home<\/em>, click <strong>Conditional Formatting<\/strong> &gt; <strong>Highlight Cells Rules<\/strong> &gt; <strong>Duplicate Values<\/strong>.<\/li>\n\n\n\n<li><strong>Choose the alert style:<\/strong> Keep the dropdown set to <em>Duplicate<\/em> and pick your preferred formatting style (e.g., Light Red Fill with Dark Red Text).<\/li>\n\n\n\n<li><strong>Click OK:<\/strong> Matching entries will be flagged instantly, allowing you to review anomalies before applying permanent deletions.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"metodo-2-la-herramienta-nativa-para-eliminar-duplicados-en-excel\" class=\"wp-block-heading\">Method 2: Native Tool to Remove Duplicates in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you need a swift, direct cleanup, the built-in feature is the quickest route:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click any cell inside your data table.<\/li>\n\n\n\n<li>Navigate to the <strong>Data<\/strong> tab on the ribbon.<\/li>\n\n\n\n<li>In the <em>Data Tools<\/em>section, click <strong>Remove Duplicates<\/strong>.<\/li>\n\n\n\n<li>A configuration dialog will appear listing all columns:\n<ul class=\"wp-block-list\">\n<li>Check the box labeled <strong>My data has headers<\/strong> if your first row contains column titles.<\/li>\n\n\n\n<li>Define matching criteria: Selecting every column ensures only 100% identical rows are purged. Selecting just a single identifier (such as an Email address or ID number) deletes any subsequent row sharing that value, retaining only the first occurrence.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Click <strong>OK<\/strong>. <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> displays a confirmation prompt detailing how many duplicate values were removed and how many unique records remain.<\/li>\n<\/ol>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Golden Rule:<\/strong> Before using the mass deletion tool, always make a backup or duplicate your worksheet. This operation permanently alters the underlying dataset.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"636\" src=\"https:\/\/yousofthub.com\/wp-content\/uploads\/2026\/09\/imagen-1024x636.png\" alt=\"eliminar duplicados en excel\" class=\"wp-image-45\" srcset=\"https:\/\/yousofthub.com\/wp-content\/uploads\/2026\/09\/imagen-1024x636.png 1024w, https:\/\/yousofthub.com\/wp-content\/uploads\/2026\/09\/imagen-300x186.png 300w, https:\/\/yousofthub.com\/wp-content\/uploads\/2026\/09\/imagen-768x477.png 768w, https:\/\/yousofthub.com\/wp-content\/uploads\/2026\/09\/imagen-1536x954.png 1536w, https:\/\/yousofthub.com\/wp-content\/uploads\/2026\/09\/imagen-18x12.png 18w, https:\/\/yousofthub.com\/wp-content\/uploads\/2026\/09\/imagen.png 1648w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 id=\"metodo-3-como-eliminar-duplicados-en-google-sheets\" class=\"wp-block-heading\">Method 3: How to Remove Duplicates in <a href=\"https:\/\/support.google.com\/docs\/answer\/9355796\" data-type=\"link\" data-id=\"https:\/\/support.google.com\/docs\/answer\/9355796\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Much like when you <strong>remove duplicates in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong>, <a href=\"https:\/\/support.google.com\/docs\/answer\/9355796\" data-type=\"link\" data-id=\"https:\/\/support.google.com\/docs\/answer\/9355796\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a> provides a streamlined native cleanup assistant:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Highlight the cells or columns you wish to clean up.<\/li>\n\n\n\n<li>From the top menu, go to <strong>Data<\/strong> &gt; <strong>Data cleanup<\/strong> &gt; <strong>Remove Duplicates<\/strong>.<\/li>\n\n\n\n<li>Specify whether the dataset includes a header row and check the specific columns to evaluate.<\/li>\n\n\n\n<li>Click the blue <strong>Remove Duplicates<\/strong> button to complete the process.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"metodo-4-extraer-registros-unicos-mediante-formulas-sin-modificar-la-tabla-original\" class=\"wp-block-heading\">Method 4: Extract Unique Records with Formulas (Non-Destructive)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you need a dynamic, automated solution to <strong>remove duplicates in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong>the =UNIQUE formula is the most efficient choice.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Both in Google Sheets and in modern versions of <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> (<a href=\"https:\/\/www.microsoft.com\/es-es\/microsoft-365\" data-type=\"link\" data-id=\"https:\/\/www.microsoft.com\/es-es\/microsoft-365\" target=\"_blank\" rel=\"noopener\">Microsoft 365<\/a> and <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel 2021<\/a> onwards), use the dynamic array formula: <code>UNIQUE<\/code>:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=UNIQUE(A2:A100)<\/p>\n\n\n\n<h2 id=\"metodo-5-filtrar-duplicados-mediante-filtro-avanzado-para-copiarlos-a-otra-ubicacion\" class=\"wp-block-heading\">Method 5: Filter Duplicates Using Advanced Filter (Copy to Another Location)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><p data-path-to-node=\"3\">If you are running a legacy desktop version of <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> without the <code data-path-to-node=\"3\" data-index-in-node=\"78\">=UNIQUE<\/code>function, the <b data-path-to-node=\"3\" data-index-in-node=\"105\">Advanced Filter<\/b> tool extracts clean lists without modifying your source data:<\/p><ol start=\"1\" data-path-to-node=\"4\"><li><p data-path-to-node=\"4,0,0\"><b data-path-to-node=\"4,0,0\" data-index-in-node=\"0\">Select your data:<\/b> Click the table or column containing redundant entries.<\/p><p data-path-to-node=\"4,1,0\"><b data-path-to-node=\"4,1,0\" data-index-in-node=\"0\">Open Advanced Filter:<\/b> Navigate to the <b data-path-to-node=\"4,1,0\" data-index-in-node=\"52\">Data<\/b> tab and, in the <i data-path-to-node=\"4,1,0\" data-index-in-node=\"75\">Sort &amp; Filter<\/i>section, click <b data-path-to-node=\"4,1,0\" data-index-in-node=\"106\">Advanced<\/b>.<\/p><p data-path-to-node=\"4,2,0\"><b data-path-to-node=\"4,2,0\" data-index-in-node=\"0\">Configure the filter parameters:<\/b><\/p><ul data-path-to-node=\"4,2,1\"><li><p data-path-to-node=\"4,2,1,0,0\">Select <b data-path-to-node=\"4,2,1,0,0\" data-index-in-node=\"41\">Copy to another location<\/b>.<\/p><p data-path-to-node=\"4,2,1,1,0\">In the <b data-path-to-node=\"4,2,1,1,0\" data-index-in-node=\"14\">Copy to<\/b>field, click and select the destination cell where your clean list should begin (e.g., an empty column like <code data-path-to-node=\"4,2,1,1,0\" data-index-in-node=\"140\">C1<\/code>).<\/p><p data-path-to-node=\"4,2,1,2,0\">Check the essential box: <b data-path-to-node=\"4,2,1,2,0\" data-index-in-node=\"32\">Unique records only<\/b>.<\/p><\/li><\/ul><p data-path-to-node=\"4,3,0\"><b data-path-to-node=\"4,3,0\" data-index-in-node=\"0\">Click OK:<\/b> <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> generates a pristine copy of your list instantly, stripping out duplicate rows while keeping the raw data untouched.<\/p><\/li><\/ol> This process is ideal <strong>remove duplicates in <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong> when working without modern dynamic array formulas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Knowing how to <strong>remove duplicates in <\/strong><a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\"><strong>Excel<\/strong> <\/a>will save you hours of work and prevent critical reporting errors.<\/p>\n\n\n\n<h2 id=\"resumen-que-metodo-elegir-segun-tu-caso\" class=\"wp-block-heading\">Summary: Which Method Should You Choose?<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>To inspect rows before deletion:<\/strong> Use <strong>Conditional Formatting<\/strong> (Method 1).<\/li>\n\n\n\n<li><strong>To sanitize static databases quickly:<\/strong> Use the built-in <strong>Remove Duplicates<\/strong> tool (Methods 2 &amp; 3).<\/li>\n\n\n\n<li><strong>To automate tables receiving ongoing entries:<\/strong> Use the dynamic <code>=UNIQUE<\/code> function (Method 4).<\/li>\n\n\n\n<li><strong>For legacy <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/es-es\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> versions lacking modern formulas:<\/strong> Rely on the <strong>Advanced Filter<\/strong> (Method 5).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">You can complement this data-cleaning workflow by learning <a href=\"https:\/\/yousofthub.com\/en\/separar-nombre-y-apellidos\/\" target=\"_blank\" rel=\"noreferrer noopener\">how to split first and last names in Excel and Google Sheets<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Aprender a eliminar duplicados en Excel y Google Sheets es una de las tareas m\u00e1s importantes al trabajar con hojas [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":57,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-datos"],"_links":{"self":[{"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/posts\/41","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/comments?post=41"}],"version-history":[{"count":5,"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":59,"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/posts\/41\/revisions\/59"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/media\/57"}],"wp:attachment":[{"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/media?parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/categories?post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yousofthub.com\/en\/wp-json\/wp\/v2\/tags?post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}