How to Remove Duplicates in Google Sheets

Sanskar Tiwari

Author: Sanskar Tiwari

Founder at MagicSlides

Published

Easily clean up your data by removing duplicate entries in Google Sheets using simple built-in tools

Duplicate entries in spreadsheets can lead to inaccurate data analysis, repeated contacts, or unnecessary clutter. Thankfully, Google Sheets provides a simple built-in tool that helps you quickly remove duplicate values from your data.
Whether you're managing lists of names, email addresses, products, or any other records, this feature will help keep your data clean and organized.
In this blog post, you’ll learn step-by-step how to remove duplicates in Google Sheets using the built-in function, plus some advanced tips using formulas.

How to Remove Duplicates in Google Sheets | Step-by-Step Tutorial

Method 1: Using the Built-in “Remove Duplicates” Tool

  1. Open Your Google Sheet
      2. Go to Google Sheets and open the file with duplicates.
      notion image
  1. Select the Data Range
      2. Highlight the rows or columns where duplicates may exist. Include the header if applicable.
      notion image

Tired of spending hours cleaning data or writing complex formulas? Here’s a smarter solution: SheetAI.app

Whether you're managing sales reports, crafting marketing content, or analyzing feedback, working in spreadsheets can be time-consuming and repetitive. But what if you could automate these tasks and enhance your productivity directly within Google Sheets? That's exactly what SheetAI offers.
notion image
SheetAI is an AI-powered add-on for Google Sheets that brings advanced capabilities right into your spreadsheet. Simply describe what you want in plain English, and SheetAI will execute tasks such as generating formulas, cleaning data, summarizing text, and even creating images. (SheetAI Documentation - AI-Powered Functions for Google Sheets)
Here’s what you’ll love about SheetAI:
  • Natural Language Commands: Use plain English to perform complex tasks.
  • AI-Powered Functions: Leverage functions like =SHEETAI() and =SHEETAI_RANGE() for dynamic content generation.
  • Data Cleaning & Analysis: Automate data sanitization, summarization, and categorization.
  • Content Generation: Create blog ideas, product descriptions, and personalized messages effortlessly.
  • Image Creation: Generate images directly within your spreadsheet using =SHEETAI_IMAGE().
  • Formula Generation: Convert textual descriptions into accurate Google Sheets formulas.
  • Integration with AI Models: Supports GPT-3, GPT-4, Claude, and Gemini for versatile AI capabilities.
Perfect for marketers, analysts, educators, and anyone looking to enhance their spreadsheet workflows.
Ready to revolutionize your Google Sheets experience? Install SheetAI now and start automating your tasks with AI!
  1. Click on Data > Data cleanup > Remove duplicates
      2. This will open a popup with several options.
      notion image
  1. Set Your Preferences
      • Check “Data has header row” if your first row contains column headers.
      • Select the columns to analyze for duplicates. You can select all or specific ones.
  1. Click “Remove duplicates”
      2. Sheets will scan and remove the duplicates, showing how many entries were deleted and how many unique ones remain.
      notion image

Method 2: Using a Formula to Filter Unique Values

  1. Create a New Column or Sheet
      2. Choose a space where the cleaned data will appear.
  1. Enter the UNIQUE Formula
      2. Type:
      Replace A2:A with your data range. This will display only unique values from the original list.

Conclusion

Removing duplicates in Google Sheets is a quick and efficient process, whether you use the built-in tool or formulas.
Keeping your data clean not only saves time but also ensures accurate reporting and decision-making. Make this a regular habit to avoid data clutter and confusion.

FAQs can take you forward!

Will the “Remove duplicates” tool delete the original data?

Yes, it removes duplicate entries directly from the original selection, so consider duplicating your data first if needed.

Can I remove duplicates from multiple columns at once?

Yes, just select multiple columns before opening the “Remove duplicates” tool.

What if I only want to remove duplicates based on one column, not the whole row?

You can uncheck other columns during the “Remove duplicates” process and keep only the column you want to evaluate.

Is there an undo option after removing duplicates?

Yes! Just press Ctrl + Z (or Cmd + Z on Mac) to undo the action immediately.

Share on socials