# How to Delete Duplicates in Google Sheets

Viewport: 1920x951 @0.75x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Delete Duplicates in Google Sheets
   - body: This guide provides a detailed walkthrough on how to remove duplicate entries in Google Sheets. Follow these steps to clean your data effectively and ensure that only unique entries are present.
   - voiceover: This guide provides a detailed walkthrough on how to remove duplicate entries from your Google Sheets. Follow each step carefully to ensure a clean and duplicate-free spreadsheet.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrfe9001g0cju8oci3q64.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Click on the Data tab
   - source type: IMAGE
   - description: Open your Google Sheet
   - target: (303.1518004354692, 58.636120613882035), rect: top=34 left=299.75 width=47.5 height=24
   - hotspots: 1
     - hotspot_01 (303.1518004354692, 58.636120613882035), rect: top=34 left=299.75 width=47.5 height=24
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click on the Data tab located on the top menu of your Google Sheets interface. This will open a dropdown menu with data-related options.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrk22001i0cju337ugoyy.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffgwma0000033pq8g0bxaz.png
2. step_02 [image] - Click on Data cleanup
   - source type: IMAGE
   - description: Select the data range
   - target: (483.8757734417461, 500.12166709065997), rect: top=508.66668701171875 left=339.0833435058594 width=89.9375 height=17.33333396911621
   - hotspots: 1
     - hotspot_01 (483.8757734417461, 500.12166709065997), rect: top=508.66668701171875 left=339.0833435058594 width=89.9375 height=17.33333396911621
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: From the dropdown menu, click on 'Data cleanup'. This option allows you to organize and clean your data.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrk3y001j0cjuhivn21yy.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffgy9h0001033p4qcb8h41.png
3. step_03 [image] - Choose Remove duplicates
   - source type: IMAGE
   - description: Access the Data menu
   - target: (787.5131980322147, 541.5758607510797), rect: top=548 left=638.0833740234375 width=127.60417175292969 height=17.33333396911621
   - hotspots: 1
     - hotspot_01 (787.5131980322147, 541.5758607510797), rect: top=548 left=638.0833740234375 width=127.60417175292969 height=17.33333396911621
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the 'Data cleanup' submenu, select the 'Remove duplicates' option. This will open a dialog box to configure the duplicate removal process.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrk58001k0cju6ludeanz.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffgzfs0002033p98cije9d.png
4. step_04 [image] - Deselect the 'Select all' button
   - source type: IMAGE
   - description: Choose Remove duplicates
   - target: (1233.9672833502852, 525.1517624408035), rect: top=523.5416870117188 left=1113.8333740234375 width=40 height=40
   - hotspots: 1
     - hotspot_01 (1233.9672833502852, 525.1517624408035), rect: top=523.5416870117188 left=1113.8333740234375 width=40 height=40
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the dialog box that appears, find and click the 'Select all' button to deselect all columns. This allows you to choose specific columns to check for duplicates.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrk6m001l0cju8euge35s.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffh1cz0003033p30oh9m8i.png
5. step_05 [image] - In the dialog box, select the columns you want to check for duplicates
   - source type: IMAGE
   - target: (1339.106438522048, 702.8449321957298), rect: top=553.5115988623965 left=1095.106438522048 width=244 height=298.6666666666667
   - hotspots: 1
     - hotspot_01 (1339.106438522048, 702.8449321957298), rect: top=553.5115988623965 left=1095.106438522048 width=244 height=298.6666666666667 style=STYLE2
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the dialog box, check the boxes next to the columns you want to search for duplicate entries. This ensures that the duplicate check is performed only on the selected columns.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrk7t001m0cju27bzb2hn.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffh7s90006033poxx5ny2f.png
6. step_06 [image] - Tick this if column has headers
   - source type: IMAGE
   - description: Click Remove duplicates button
   - target: (1067.3650303151428, 447.5457938994903), rect: top=447.9375 left=1113.8333740234375 width=40 height=40
   - hotspots: 1
     - hotspot_01 (1067.3650303151428, 447.5457938994903), rect: top=447.9375 left=1113.8333740234375 width=40 height=40
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Tick the checkbox labeled 'Data has header row' if your columns have headers. This helps the tool to properly identify the data rows.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrk97001n0cju8yeg6moo.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffh9e00007033pzvgwl1z6.png
7. step_07 [image] - Click on Remove duplicates
   - source type: IMAGE
   - description: Review Results
   - target: (1190.1241554420315, 860.3337642962524), rect: top=859.5416870117188 left=1256.25 width=179.58334350585938 height=36
   - hotspots: 1
     - hotspot_01 (1190.1241554420315, 860.3337642962524), rect: top=859.5416870117188 left=1256.25 width=179.58334350585938 height=36
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click the 'Remove duplicates' button in the dialog box. This action initiates the process of removing duplicate rows based on your selected criteria.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrkai001o0cju2zpq5qom.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffhaer0008033prq5bpp63.png
8. step_08 [image] - Finalize the process by clicking the 'OK' button in the dialog box.
   - source type: IMAGE
   - target: (1477.5457294928717, 724.2722750490707), rect: top=679.6458740234375 left=1463.8333740234375 width=72 height=36
   - hotspots: 1
     - hotspot_01 (1477.5457294928717, 724.2722750490707), rect: top=679.6458740234375 left=1463.8333740234375 width=72 height=36 style=STYLE1
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: A confirmation dialog box will appear. Click the 'OK' button to finalize the removal of duplicates. Your sheet will be updated to reflect the changes.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrkbp001p0cju09al61iz.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffhcal0009033pfnjl4ztx.png
10. [Outro] Next Steps
   - body: You have successfully deleted duplicates in your Google Sheets! Review your data to ensure it meets your expectations. You can now proceed with further data analysis or any subsequent tasks.
   - voiceover: You have successfully removed duplicates from your Google Sheets. You can now proceed to review your data, make further edits, or perform additional cleanup tasks as needed.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ffghlq0001jm0c0n3m2bpn/cm6ffrht0001h0cjuffz1bb4u.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6ffghlq0001jm0c0n3m2bpn/tour