Rates TodayNIFTY25,514.3+1.47%SENSEX83,021.8+1.75%Gold 24K ₹11,846.36/g down252.02Silver ₹143.04/g down3.42
InsightforGeeks

JSON, YAML & CSV Converter

Switch between JSON, YAML and CSV in one place. Turn a config file from YAML into JSON, an API response into a spreadsheet-ready CSV, or a CSV export into JSON for your code. Nested objects are flattened for CSV, separators are detected, and errors are shown with a line number. Everything runs in your browser, so your data is not uploaded.

Everything runs in your browser. Nothing is uploaded.

How to use it

  1. Choose a conversion: JSON → YAML, YAML → JSON, JSON → CSV or CSV → JSON.
  2. Paste your data, or press “Open file”, or “Load sample” to see how it works.
  3. Adjust the options, such as indent, separator, flattening or number detection.
  4. Copy the result or download it as a file. “Use as input” turns the result into the next input so you can convert back.

Frequently asked questions

How is nested JSON turned into CSV?

A CSV is a flat table, so nested objects become columns with dotted names, for example address.city. Lists inside a cell are written as JSON text. If you turn flattening off, a nested object is written as JSON text in a single cell. The columns are all the keys found in any of the objects.

Why did my numbers or codes change when I converted CSV to JSON?

CSV has no types, so every cell is text. With “Detect numbers and true/false” on, plain numbers and the words true and false become real JSON values. Text that only looks like a number, such as a code with leading zeros (00123), a phone number or a number with more than 15 digits, is kept as text so that nothing is lost. Turn the option off to keep every value as text.

What YAML features are supported?

Comments are read but not kept, because JSON has no comments. Anchors and aliases (&name and *name) and merge keys (<<) are resolved. A file with several documents separated by --- becomes a JSON list. Dates are kept as text. YAML values with no JSON equivalent, such as infinity and NaN, become null.

What is the “Protect against spreadsheet formulas” option?

Excel and Google Sheets treat a cell that starts with =, +, - or @ as a formula. If your data comes from users, a cell such as =HYPERLINK(...) could run when someone opens the file. The option puts a quote in front of such cells so they stay text. It changes the data a little, so it is off by default.

My CSV uses semicolons. Will it work?

Yes. When reading a CSV, the separator is detected from comma, semicolon, tab and pipe. Many European versions of Excel save with semicolons. When writing a CSV you can choose the separator yourself.

Is my data uploaded?

No. The conversion runs in your browser. Only the YAML library is downloaded the first time you use a YAML conversion.

Related tools

These tools run entirely in your browser and are provided free, without warranty. Check important results before using them in production.