CompleteSEOTools
Home › File Converters › Data Format Converter

Data format converter

Turn a CSV into JSON, a JSON file into SQL, or an Excel sheet into YAML without sending the data anywhere.

About Data Format Converter

Paste text or load a file, pick the format you have and the format you want, and the result appears as you type. Tabular formats (CSV, TSV, SQL, Excel) and tree formats (JSON, XML, YAML) are different shapes, so the converter flattens nested data into dotted column names when it goes into a table, and can rebuild the nesting when it comes back. Everything is read and written inside your browser.

  • Loading a spreadsheet export into a script or an API as JSON.
  • Turning a JSON response into a CSV a colleague can open in Excel.
  • Producing INSERT statements to seed a test database.
  • Moving a config between YAML and JSON.

How to use Data Format Converter

1

Step 1

Choose the input format, then paste your data or load a file.

2

Step 2

Choose the output format and adjust the options that appear for it.

3

Step 3

Copy the result or download it as a file.

Good to know

  • XML has no real arrays. A repeated element becomes a list, but a single element stays a single value, so check the result when you convert XML.
  • The YAML reader covers everyday files: nested maps, lists, quoted text, block text and inline lists. It does not read anchors, tags or files with more than one document.
  • SQL output follows MySQL, PostgreSQL or SQLite quoting. Check column types before you run it on a real database. Files are limited to 60 MB.

Common questions

Does it upload my data?

No. Parsing and conversion happen in your browser, and nothing is sent to our server.

What happens to nested JSON when I make a CSV?

Each nested key becomes a column named with dots, such as address.city. Arrays use their position, such as tags.0. Turn the option off to keep nested parts as JSON text in one cell.

Why did my numbers lose leading zeros?

They did not unless you left number detection on. A value like 007 is kept as text, but 7 and 3.5 become numbers. Switch the option off to keep every cell as text.