Data format converters

Convert data between the formats that APIs, spreadsheets and configuration systems expect. Each converter parses your input first, so you get a clear error instead of silently broken output.

Popular Data Format Converters

All Data Format Converters (17)

About Data Format Converters

Formats differ in what they can represent, so a conversion is not always lossless. JSON has typed values (numbers, booleans, null) and nesting. XML has elements, attributes and text but no data types. YAML is a superset of JSON's data model with extra features such as anchors. CSV and TSV are flat tables of text.

The converters apply consistent, documented rules where the formats disagree: nested objects become dotted column names in CSV, XML attributes become @-prefixed keys in JSON, and repeated XML elements become arrays. Each converter page lists the exact mapping it uses.

Which tool to use

Choose by the format you have, then the format you need. For spreadsheet work, JSON to CSV and CSV to JSON are the usual pair, and JSON to TSV pastes straight into a sheet. Between configuration formats, YAML to JSON and JSON to YAML keep numbers, booleans and nulls as they are. XML to JSON and JSON to XML bridge older services, and RSS to JSON does the same for feeds, returning the channel directly. String to JSON recovers a document that was stored as an escaped string.

Frequently asked questions

Is conversion lossless?

Not always. CSV cannot hold nesting or types, and XML has no numbers or booleans. Each converter page explains what changes so you can check the result.

Why are all my values strings after converting from XML or CSV?

Neither format records data types, so the converter cannot tell whether 42 is a number or text. Convert the values in your own code if types matter.

Which way round should I convert?

Pick the converter named after your input first, for example XML to JSON for an XML feed. Each page links to its reverse converter.

Common use cases

  • Turning an API response into a spreadsheet
  • Loading a spreadsheet export into an app that expects JSON
  • Moving configuration between YAML and JSON
  • Bridging a SOAP or RSS feed to a JSON-based service

Example

JSON:  [{"id":1,"user":{"name":"Ada"}}]
CSV:   id,user.name
       1,Ada

Nested objects are flattened into dotted column names when the target is a table.