Select and reorder
Keep only the fields you need and set their export order.
Date format normalizer
Put every date in one explicit format.
Data workspace
Ready in this tab
Source
Paste data or choose a file to begin.
Analysis results
Readiness score
—
Not analyzed
Preview is limited to the first 50 records. Analysis uses the complete in-browser dataset.
Repeatable preparation
Shape the in-tab working copy.
Apply one operation at a time. Preview, export, undo, or reset without changing the source file.
Filter
Keep rows that match one condition.
Sort rows
Use stable natural sorting; blank values stay last.
Deduplicate by keys
Match selected columns and choose which occurrence survives.
Rename a column
Change one field name across the working copy.
Fill blanks
Replace null, undefined, empty, or whitespace-only values.
Column formatting
Normalize values without touching the source.
Configure one column, review the sample and counts, then apply one undoable change to the working copy.
Preview · up to 5 values
Local previewSelected column
Select a column and format to preview the result.
- Will change
- —
- Unchanged
- —
- Invalid
- —
Extract by JSON Pointer
Address an exact object member or array item. Use an empty pointer for the root.
Choose a path below or enter a pointer.
Duplicate keys
No duplicate object names detected.
Path browser
Paths are indexed after JSON analysis.
Validate against JSON Schema
Validate the original JSON shape or the normalized working records.
No validation run yet.
CSV
Spreadsheet-safe CSV with formula-like cells escaped.
TSV
Tab-separated output for tools that handle commas poorly.
JSON
Readable, indented array of normalized records.
JSONL
One compact JSON record per line for pipelines.
JSON Schema
An inferred draft 2020-12 schema to review and refine.
Know the shape of the data.
Detect delimiters, validate structured text, and surface useful error locations.
Spot quality and privacy risks.
Measure completeness, duplicates, mixed values, and likely identifiers before sharing.
Shape a working copy locally.
Filter, sort, select, rename, deduplicate by keys, validate schemas, and export without changing the original file.
Focused utilities
Start with the job in front of you.
Every route opens the same private engine with guidance tailored to that format.
CSV cleanerProfile + clean tables↗
CSV filter + sortKeep and order rows↗
CSV column selectorSelect + reorder fields↗
Deduplicate by keysChoose record identity↗
JSON validatorValidate + inspect records↗
JSON repairFix + review syntax↗
JSON path browserExtract RFC 6901 pointers↗
Schema validatorTest Draft 2020-12↗
JSONL converterPrepare streaming data↗
Schema generatorInfer a data contract↗
Date formatterNormalize date columns↗
Phone formatterE.164 + national formats↗
Delimiter detectorFind hidden separators↗
PII scannerCatch obvious exposure↗
Practical guide
Normalize dates without silently guessing
A value like 03/04/2026 can mean March 4 or 3 April. Auto mode accepts unambiguous values and rejects ambiguous numeric dates; an explicit input order lets you state what the source means before converting it.
- 01Analyze the table and open the Format tab.
- 02Choose the date column and its input order.
- 03Preview ISO, US, UK, readable, or ISO date-time output with invalid counts.
- 04Apply one undoable change and export the local working copy.
How does the formatter handle ambiguous dates?
Auto mode does not guess when both the day and month are 12 or less. Select MDY, DMY, or YMD to describe the source explicitly, then review the before-and-after preview.
Can it convert timestamps to UTC?
Yes. ISO date-time values can preserve their written date and time, convert to UTC, or use the browser timezone before formatting.
Does Parse The Data upload my files?
No. Parsing, profiling, cleanup, and export run inside your browser tab. The application does not send dataset contents to our server or any third party.
What file types are supported?
CSV, TSV, JSON, and JSON Lines (JSONL or NDJSON) are supported as pasted text or local files up to 10 MB. CSV files can also be decoded as UTF-8, UTF-16, or Windows-1252.
Can it detect every privacy risk?
No. The privacy scan uses deterministic patterns and column-name hints. It can find common emails, phone numbers, IP addresses, SSNs, and payment-card patterns, but it is not a substitute for a formal privacy review.
ServerTool filesHTML, CSS, scripts
Browser tabRuns herePrivate processing
InternetNo datasetNo upload route
Your datasetStays hereIn this browser
Tool assets in→dataset out×
Designed for restraint
The server delivers the tools. Your dataset stays in the browser.
The app files arrive first. Parsing, profiling, and cleanup then happen in a browser worker on your device. The dataset has no upload path.
- No accounts
- No cloud storage
- No third-party scripts
Use the PII scan as an early warning—not as legal advice or a compliance certification.