Nutter Tools
Nutter Tools

A free toolbox that runs in your browser. A tool for every job.

Your files never leave your device

Images

  • Convert images
  • Compress images
  • Resize images
  • Crop
  • Watermark

PDF & files

  • Merge PDFs
  • Split a PDF
  • Images to PDF
  • PDF to images
  • Remove photo location

Video & audio

  • Compress video
  • Convert video
  • Video to GIF
  • Convert audio
  • Trim audio

Everyday

  • QR codes
  • Passwords
  • Time zones
  • Unit converter
  • Word count
  • Webcam test

Developer

  • JSON formatter
  • Base64
  • Regex tester
  • Hashes
  • JWT decoder

Site

  • About
  • Contact
  • Settings
  • Privacy
  • Terms
  • Site map
  • llms.txt

Everyday

  • Images
  • Video
  • Audio
  • PDF & files
  • Text
  • QR codes
  • Units & math
  • Time & dates
  • Color
  • Passwords & IDs
  • Device tests
  • Sun & moon

For developers

  • JSON
  • Encoding
  • Regex & cron
  • Web & auth
  • Hashing & encryption
  • Config files
  • Network
  • Browser
  • AI
  • Fake data
© Nutter Toolsnutter.tools
  1. Home
  2. PDF & files
  3. Spreadsheet duplicate finder
Your files stay on your device

Spreadsheet duplicate finder

Find duplicate and near-duplicate rows in an XLSX or CSV using chosen key columns, normalisation rules, and a fuzzy threshold, then review clusters and export a clean file.

This tool is in beta

Still being tested. If a result looks wrong, tell us.

Report a problem

Load rows, tick the key columns, then run the scan. Clusters come back with per-column scores before anything is removed.

How matching works: after normalising the ticked columns, two rows are a duplicate pair only when every key column reaches the threshold. Blank key cells score zero, so a row with a blank key never matches anything. Candidate pairs are found by blocking on each column's first character and length band, which keeps the run fast but means two rows whose key text starts with a different character in every key column are never compared. The cleaned file re-joins the kept rows with standard CSV quoting, so cell values survive but number formats and styles from an Excel file do not. Nothing is removed until you download, nothing is uploaded, and the cluster report lists every cluster with its scores.

Match settings

DelimiterAuto reads comma, semicolon, or tab from the first rows
Key columnsA duplicate must match on every ticked column, up to 8
Paste rows or open a file to see the columns.
Similarity threshold0.80 to 1.00; 1.00 is identical after normalising
Similarity measure
Row to keep in each cluster

Up to 2 million characters, 20,000 data rows, 256 columns, and 400,000 pair comparisons per run. Nothing leaves this tab.

More PDF & file tools

  • Excel sheets (XLSX)
  • Word documents (DOCX)
All PDF & file tools

Was this tool useful?