Select and reorder
Keep only the fields you need and set their export order.
JSON validator
Make broken JSON understandable.
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
- —
Query with JSONPath
Find multiple values with child selectors, wildcards, array slices, descendants, and filters. Queries run in the browser worker.
Up to 10,000 matches and 5 MB of output; the first 200 matches are shown below.
Run a query to inspect matching values and normalized paths.
No query run yet.
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.
Compare + joinDiff two datasets↗
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 queryQuery RFC 9535 JSONPath↗
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↗
Natural VoiceEdit machine-made rhythm↗
Practical guide
Validate structure, then inspect the data
A syntactically valid payload can still contain duplicate records, inconsistent value types, missing keys, or sensitive fields. Parse The Data goes beyond pretty-printing by profiling the records after validation.
- 01Locate malformed JSON or repair common non-standard syntax locally.
- 02Detect duplicate object names before native parsing hides earlier values.
- 03Query multiple nodes with RFC 9535 JSONPath or extract one exact RFC 6901 pointer.
- 04Validate Draft 2020-12 schemas or export JSON, JSONL, CSV, and TSV.
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.