How to find duplicates in Google Sheets

3 min read

Summary

Identifying duplicates in Google Sheets helps maintain data accuracy and prevents redundancy, which is crucial for reliable analysis and decision-making.

Knowing how to find duplicates in Google Sheets is essential for managing data accuracy and eliminating redundant entries.

Google Sheets offers several methods to identify duplicates effectively. One of the simplest ways is by using the Conditional Formatting tool. Select the range of data, go to Format > Conditional Formatting.

Set a custom formula such as =COUNTIF(A:A, A1)>1. This highlights cells that contain duplicate values.

Alternatively, you can use the Data Cleanup tool in Google Sheets to quickly remove duplicates. Navigate to Data > Data cleanup > Remove duplicates, then select the data range you want to check. Specify whether to consider all columns or just specific ones to identify duplicates. The tool will scan your data and remove duplicate rows, leaving only unique entries.

More Google Workspace tips from Kanbanchi

Name	Provider	Purpose	Expiration
wordpress_, wp_	Kanbanchi	Internal cookie provided by CMS the website is built in.	Session
kanbanchi_website_cookie	Kanbanchi	Internal cookie for checking cookies health.	Persistent
pll_language	Kanbanchi	This cookie is used to remember the language selected by the user when he comes back to visit again the website by Polylang.	Persistent
_pk_*	Matomo	Analyse the use of the website and compile reports about the website activity.	Persistent
embed-privacy, moove_gdpr_popup	Kanbanchi	Track users’ cookie consent.	Persistent
__cf, cf_, _cf*, CF_Authorization	CloudFlare	CloudFlare service sets cookies to identify trusted web traffic. It does not correspond to any user id in the web application and does not store any personally identifiable information.	Session
access_token_production, amplitude_, amp_, amp_.organization.domain, CookieControl, deviceId, driftt_aid, eventId, identifyId, lastEventTime, optOut, org_login_production, sequenceNumber, sessionId, userId, _biz_, _fbp, _ga, _gid, _mkto_trk, _rdt_uuid, _uetvid, _zitok, __utmzz, __utmzzses	Amplitude	These cookies are used to analyze the user behavior within Kanbanchi website.	Persistent
_GRECAPTCHA	Google reCAPTCHA	We use Google Recaptcha to provide spam protection. We then compile reports which help Us improve Our Sites. This cookie sets as necessary cookie when executed for the purpose of providing its risk analysis.	Session
ar_debug, ga, _dc_gtm_UA-XXXXX-XX, _dc_gtm_, _gaexp, _gat, _gat, _gat_gtag_UA_, _ga_XXXXXXXXXX, _ga_, _gcl_au, _gid, __TAG_ASSISTANT, __utma, __utmc, __utmz	Google Analytics and Google Tag Manager	We use Google Analytics and Google Tag Manager to collect information about the usage of Our Sites. We then compile reports which help Us improve Our Sites. The core cookies of Google Analytics and Google Tag Manager collect information in an anonymous form, including the number of visitors to the site, where visitors have come to the site from, the pages they visited and the features they used.	Persistent
AADSSOTILES brcap Ccs CcsNtv CcsWeb ch, CkTst, CLID, cl, ea, ec, el, ESTSUSERLIST, ev, evt, fpc, gc, gv, ifm, lg, lt, mid, msclkid, MSPTC, MUID, p, pi, r, rn, rrc, sc, sh, sid, sw, threxp, ti, tl, ver, _cl, _uetmsclkid, _uetsid, _uetvid	Microsoft Universal Event Tracking	We use Microsoft Event Tracking to collect information about the usage of Our Sites. We then compile reports which help Us improve Our Sites. The core cookies of Microsoft Event Tracking collect information in an anonymous form, including the number of visitors to the site, where visitors have come to the site from, the pages they visited and the features they used.	sid is a Session cookie, other – Persistent

Name	Provider	Purpose	Expiration
1_LIVE, APISID, HSID, LOGIN_INFO, PREF, SAPISID, SID, SSID, VISITOR_INF, YSC	YouTube	We use YouTube (a service of Google) to display video content on Our Sites. As part of this, YouTube sets various cookies to allow the correct Youtube video playback and store your preferences when viewing YouTube videos.	Persistent
1P_JAR, ACCOUNT_CHOOSER, ADS_VISITOR_ID, AEC, AID, APISID, DV, HSID, LSID, LSOLH, NID, OCAK, OGPC, OTZ, PSIDCC, SAPISID, SID, SMSV, SOCS, SSID, __Secure-	Google Accounts / Google Services	Google sets various cookies to authenticate users, prevent fraudulent use of login credentials, protect user data from unauthorized parties, as well as remember your preferences and other information, such as your preferred language.	Persistent
csrf.app, hubspotutk, IR_PI, messagesUtk, _cfuvid, _conv_v, _hjSessionUser_, _hs, _ttp, _tt_enable_cookie, __cf_bm, __hs*	Hubspot	These cookies are set by Hubspot. We use this tool for analyzing the use of kanbanchi.com and receiving requests from visitors. We then compile reports which help Us improve Our Sites.	_hssrc is a Session Сookie, others – Persistent
ajs_anonymous_id, .customer.io, _cio, _ga, _ga_	Customer.io	Some forms on our website collect data for the purpose of sending emails. Cookies will only be added in case of submitting these forms.	Persistent

Name	Provider	Purpose	Expiration
IDE, test_cookie	DoubleClick	Google’s Doubleclick uses cookies for targeting, optimisation, reporting and attribution of online advertisements.	Persistent
m-b, m-css_v, m-early_v, m-s, m-t*, m-uid	Quora	Uses cookies for targeting, optimisation and attribution of online advertisements.	Persistent
ct0, eu_cn, external_referer, guest_id*, lang, metrics_token, muc_ads, personalization_id, syndication_guest_id, tfw_exp, _twitter_sess	Twitter	We embed certain Twitter feeds on site. Cookies are set by Twitter to be identified on the web site through a Twitter account, as well as information on the content viewed by the user for Twitter’s display advertising.	lang and _twitter_sess are Session Cookies, others – Persistent
cb, datr, fr, usida, wd, _fbp	Facebook	We use Facebook information on the content viewed by the user for Facebook’s display advertising.	lang and _twitter_sess are Session Cookies, others – Persistent
_hj*	HotJar.com	Some pages of our website are monitored by our marketing team to provide a better experience and more relevant information.	Session
AnalyticsSyncHistory, ar_debug, bcookie, Bizo, bscookie, JSESSIONID, lang, li, li_, lms_, ln_, oribi, sdsc, UID, UserMatchHistory, _guid	Linkedin	These cookies are used as part of LinkedIn Insights and ad tags to track visitors from our LinkedIn marketing.	Persistent

How to find duplicates in Google Sheets

Summary

Want to try the power of Kanbanchi and Google Workspace?

Watch how to find duplicates in Google Sheets