CureData, front to back.

A validation workbench in a single page. Upload a file, compose a ruleset, get a report. This page is the reference.

Feed it a file.

CSV is the common case. XLSX works (first sheet, row 1 = headers). JSON is supported as an array of objects. You can also start with a blank schema and type headers directly.

Email,Amount,StartDate,EndDate,State
alice@example.com,12.50,2024-01-10,2024-01-12,CA
bob@example.com,0,2024-02-01,2024-02-01,WA
,19.99,2024-03-05,2024-03-06,TX

Columns carry rules.

A schema is a named collection of columns. Each column carries 0..n rules. Order does not matter — the engine evaluates in an optimized pass.

{
  name: "StartDate",
  rules: [
    { type: "type", expected: "date" },
    { type: "noFutureDate" }
  ]
}

{
  name: "EndDate",
  rules: [
    { type: "type", expected: "date" },
    { type: "dateOrder", otherField: "StartDate", op: ">=" }
  ]
}

How rulesets find your columns.

When you apply a saved ruleset to a new upload, the header_match_strategy controls how strictly names must line up.

One-click presets.

Sample orders.

1. 01
   orderId→requiredtype:stringlength 8–36unique_in_file
2. 02
   email→requiredtype:stringemail
3. 03
   phone→type:stringphoneUS
4. 04
   amount→type:numberrange ≥ 0precision 2
5. 05
   order_date→type:datenoFutureDate
6. 06
   ship_date→type:datedateOrder ≥ order_date
7. 07
   status→enum: Pending · Processing · Shipped · Delivered · Cancelled
8. 08
   ifThen→IF status=Cancelled THEN ship_date blank
9. 09
   state / zip→stateCodeUSzipUS

Core rules ship built-in. Add as many as needed per column. regex and enum repeat. Cross-field rules like dateOrder and ifThen reference other columns.

Grammar.

Validation context.

Phase 1 runs client-only. A minimal ctx object is passed to custom rules.

const ctx = { now: new Date() }

Issues out as CSV.

The workbench exports a CSV of issues. Columns: rowIndex, column, code, message, value.

rowIndex,column,code,message,value
12,Email,required,"Value is required",""
42,Amount,range,"Must be between 0 and 1000","-12"

Troubleshooting.