Validate CSV & Excel Data

Set validation rules for each column — required fields, data types (email, phone, URL, number, date), allowed values, uniqueness, regex patterns — then check your file instantly. Every rule violation is flagged with the row number, value and reason. Download invalid rows to fix them, or use the full annotated file.

Drop a CSV or Excel file here

.csv, .xlsx, .tsv

Your file stays on your device. Validation runs in your browser — nothing is uploaded.

How it works

Step 1
Upload your file
CSV or XLSX. The file is read in your browser and never leaves your device.
Step 2
Set rules per column
Choose a type (email, phone, number, date, etc.), mark required fields, add uniqueness checks or allowed values. Or start from a template (HubSpot, Shopify, generic contacts).
Step 3
See what's wrong
Every violation is shown with the row number and exact error. Download invalid rows or the full file with a status column.

What it checks and fixes

13 field types

Email, phone, URL, date, number, integer, boolean, country, state, GSTIN, PAN, PIN code — each with its own validation logic.

Required & unique checks

Flag rows where a required field is empty, or where a value repeats when it shouldn't (like a duplicate email).

Allowed values

Restrict a column to a fixed set of values — useful for lifecycle stages, status fields or product types.

Destination templates

Start from HubSpot Contacts, Shopify Products or a generic contact list. The template pre-fills types, required fields and allowed values.

Why validate before importing?

CRMs, e-commerce platforms and databases reject rows that don't fit their schema — or worse, they silently skip them. A failed import that drops 200 contacts without telling you is hard to debug after the fact.

Validating before you import catches the problems you can fix: missing emails, phone numbers in the wrong format, prices stored as text, dates that aren't dates, and status values that aren't in the system's allowed list.

How the validation engine works

Each rule is compiled into a fast checker that runs over every row. Missing columns are reported but don't crash the validation. Required checks run first (an empty value is 'missing', not 'invalid'). Unique checks track values as they appear — the first occurrence is valid, later ones are duplicates.

The annotated file adds two columns at the end: 'Validation status' (valid, invalid, missing, duplicate) and 'Validation errors' (a semicolon-separated list of what went wrong). You can filter or sort by status in Excel to find the rows that need attention.

Frequently asked questions

Is my file uploaded?

No. Validation runs entirely in your browser. Nothing leaves your device.

Can I validate Indian identifiers?

Yes. GSTIN (with check-character verification), PAN and PIN code are built-in field types.

What if a column is missing from my file?

It's reported in the summary. Rows aren't marked invalid just because a schema column doesn't exist — only rules that can be checked are applied.

Can I save my schema for reuse?

Templates are built in. Custom schemas will be saveable when account features are available.

CSV Cleaner — Find duplicates, invalid emails and inconsistent formats — fix them in minutes.
Excel Cleaner — Clean .xlsx data without formulas or macros — leading zeros stay intact.
Remove Duplicates from CSV — Deduplicate by whole row, email, ID or several columns — you choose what to keep.
Remove Duplicates from Excel — Finds the duplicates Excel misses — and shows exactly which rows go.
Remove Duplicate Emails — One row per email address — even when capitals and spaces hide the duplicates.
Phone Number Normalizer — Convert messy phone numbers to one international format — +919876543210.
Date Format Standardizer — Mixed date formats to one — without guessing whether 03/04 is March or April.
Fix CSV Encoding — Garbled accents in Excel? Get clean UTF-8 that opens correctly everywhere.
Compare CSV Files — Find added, removed and changed rows between two versions of a file.
Merge CSV Files — Stack rows or join by a key — combine two files in seconds.
Column Mapper — Auto-detect column matches and rename for your import destination.
Convert Excel to CSV — Upload an .xlsx and download a clean CSV — encoding, dates and leading zeros handled.
Convert CSV to Excel — Upload a CSV and get a clean .xlsx — leading zeros, dates and encoding handled.
CSV Viewer — Open any CSV in a clean table — encoding and delimiters detected automatically.
Remove Empty Rows — Find and remove blank, partial and whitespace-only rows in one click.
GSTIN Validator — Check GSTIN format in bulk — state code, PAN, entity code and check digit.
PAN Validator — Check PAN format in bulk — catch typos, truncation and invalid patterns.
Format Indian Phone Numbers — Normalize messy Indian phone numbers to +91 E.164 — in seconds.