Data converters

The data converters move tables and structured data between the formats that spreadsheets, APIs and configuration files use. Everything is parsed and written in your browser, so exports from a CRM, customer lists or keys in a configuration file never reach a server.

CSV to JSON detects the delimiter, uses the header row as keys and can build nested objects from dotted column names. JSON to CSV flattens nested objects into the columns you choose and can add a byte order mark so Excel shows accented letters correctly. CSV to XLSX creates an Excel workbook from each CSV file, XLSX to CSV saves every sheet of a workbook as its own CSV file, and XLSX to JSON turns a chosen sheet into a list of rows with dates written in ISO format.

JSON Formatter pretty-prints, minifies and validates JSON, points to the line and column of a syntax error, can sort keys and shows the data as a collapsible tree. The YAML and JSON converter works in both directions, which helps with Kubernetes manifests, continuous integration pipelines and other configuration files. Large inputs work too: the text tools accept up to 10 million characters (about 10 MB), and the file converters take files of up to 50 MB each.