Skip to main content
Format options

Checking cloud presets…

Formatted output

Formatted data appears here.

How to format and validate JSON, YAML, and CSV

Data Formatter re-indents and validates a JSON, YAML, or CSV payload and tells you exactly where it breaks when it is malformed. Parsing happens in your browser tab, so a config file, an API response, or an export full of customer rows never leaves the device. When the data is valid you can copy it, download it, save the run locally, or hand it straight to Text Diff or Snippet Studio.

Format a payload in four steps

  1. Pick the format and paste the dataChoose JSON, YAML, or CSV, then paste into the input. Load example fills the input with a small valid sample for the format you selected, so you can see the output shape before pasting anything sensitive.
  2. Set the formatting optionsChoose the indent width, and for JSON optionally sort object keys alphabetically or preserve integer lexemes that would lose precision as JavaScript numbers. CSV adds a strict or lenient parsing mode.
  3. Format and read the verdictPress Format data. Valid input produces a formatted result with a valid badge; broken input reports why it failed instead of silently returning the text unchanged. Lenient CSV can recover and then lists each row and column it had to repair.
  4. Take the result somewhereCopy the output, download it as a .json, .yml, or .csv file, or save the run in this browser's local history. Compare changes opens the result in Text Diff and Create code card opens it in Snippet Studio.

What people use Data Formatter for

  • Find the syntax error in a config filePaste a YAML or JSON file that a tool rejected and let the parser point at the failure instead of reading the file line by line.
  • Make a minified API response readableRe-indent a single-line JSON body and sort its keys so you can scan the fields, and diff it against a previous response.
  • Check a CSV export before importing itRun a spreadsheet export through lenient mode to see exactly which rows have ragged columns or stray quotes before another system rejects the file.

Data Formatter questions

Is my data uploaded when I format it?
No. Parsing and formatting run in your browser tab. Input, output, filenames, and clipboard content never leave the device, and nothing is stored unless you explicitly save a run to this browser.
Can it convert JSON to CSV or YAML?
No. Each format is parsed and re-emitted in the same format. Data Formatter reshapes the layout and validates the syntax; it does not translate between JSON, YAML, and CSV.
Why do my large ID numbers change?
Because JavaScript numbers lose precision beyond 2^53. Turn on the option that preserves unsafe integer lexemes and the original digits are written back out exactly as you pasted them.
What is the difference between strict and lenient CSV?
Strict fails on the first structural problem. Lenient repairs what it can, marks the result as recovered, and lists the row and column of every repair so you can decide whether the fix is acceptable.
Why does it say the output is stale?
Because the input or an option changed after the last run. Format again before copying, downloading, or handing off, so you never move a result that no longer matches its input.
Where are saved runs kept?
In this browser on this device. Recent local runs are convenience history, not an account feature, and you can clear them from the same panel at any time.