Click Tools · Sift

Clean CSV data in minutes, not hours

Sift finds duplicate rows, broken emails and websites, numbers stored as text and empty cells, then lets you decide what gets fixed.

Prices exclude tax. Or get Sift, Pulse and MAP Matrix together for $49.99 USD / month.

Sift · customers.csv
Duplicate rows1
Format issues3
Missing values2
NameEmailAge
Ana Cruzana@gmail.com34
Ben Leeben@yahoo29
Ana Cruzana@gmail.com34
Cara Diazempty1,200
Dan WuDAN@WU.COM41
Eve Royeve@roy.coempty
DuplicateMissingFormat
Illustrative sample data
Inside Sift

See exactly what changed

Every fix is logged by row, so you can check the work and download the log with your cleaned file.

Sift · change report
Rows before6
Rows after5
Every change, by row
  • Removed 1 duplicate row (kept first copy): row 4
  • Row 3, "email": "ben@yahoo" → "ben@yahoo.com"
  • Row 6, "email": "DAN@WU.COM" → "dan@wu.com"
  • Row 5, "age": "1,200" → "1200"
  • Row 7, "age": filled with the median
Download cleaned CSVDownload report
Illustrative sample data
What it does

Sift at a glance

Duplicate detection

Matches rows that differ only by capital letters or spacing, and keeps the first copy.

Format repair

Lowercases emails, adds https:// to websites, completes common domains like gmail.com and turns numbers stored as text into numbers.

Missing values

Spots empty, N/A and null cells. Leave them, remove those rows, or fill numbers with the median and text with "Unknown".

Edit by hand

Click any highlighted cell and type the fix yourself. Issues are re-checked as you go.

Change report

Every change is logged by row, and you can download the log alongside your cleaned CSV.

Private by design

Your file is processed in your browser and never uploaded.

How it works

Three steps

Upload your CSV

Drop in a comma, semicolon or tab separated file.

Scan and review

Duplicates, format problems and missing values are color coded so you can see exactly what Sift found.

Fix and download

Apply the fixes you want, then download the cleaned CSV and the change report.

Built for marketers and small business owners who work with email lists, ad platform exports, survey results and customer spreadsheets, and need them tidy before they analyze or import them.

Questions

About Sift

Is my CSV uploaded anywhere?

No. Sift runs in your browser, so your file stays on your device.

Will Sift change my data without asking?

No. It highlights issues first. Nothing changes until you choose a fix.

What file types can I use?

CSV files, including semicolon and tab separated exports.

More Click tools

Get Sift for $4.99 USD / month

Or take all three tools for $49.99 USD / month. Prices exclude tax.

Get started