Excel tool

Spreadsheet Data Validator

Review one worksheet column against a selected rule and export a report of rows that fail.

Private by designRuns in your browser
Recent tools
Ctrl / ⌘ + Enter to run

Loading workspace…

Preparing the controls for this tool. Your files have not been selected or uploaded.
QUICK START

How to use Spreadsheet Data Validator

  1. Choose XLSX or CSV and select a worksheet. Its first row is treated as a header.
  2. Enter a one-based column number and choose required, unique, email, number or ISO date.
  3. Process and review the Row, Column, Value and Issue report. Download CSV and correct the original data separately.

Continue your workflow

Clean a sales export — Keep product codes intact while preparing a report.

BEFORE YOU BEGIN

What to expect

Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.

Local processing

Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.

Rules and source positions

Required checks blank or whitespace-only values. Unique flags repeated string values after their first occurrence. Other rules check email syntax, numeric parsing or YYYY-MM-DD calendar dates. Report row 2 refers to the first data row below the source header.

Validation scope

Only one selected column and one rule are checked at a time. A valid email pattern is not mailbox verification. Numeric validity does not establish currency or business constraints. The tool produces an issue report and does not rewrite the original worksheet.

HELP & TROUBLESHOOTING

Frequently asked questions

What does a header-only report mean?

No rows failed the selected rule. It does not mean every column or every business requirement was checked.

Are uniqueness checks case-insensitive?

No. This rule compares the stored string values without a case-folding option. Normalize your data deliberately if case should not matter.

Where is my input processed?

Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.