Format Converter
Convert tables into data, table, SQL, and type formats.
Your data stays in your browser
Source table
Waiting for data
Output format
Converted data
No resultEnter or interpret a flat table to convert it.
Example
JSON Lines
Input
name,note Ada,"a, b"
Output
{"name":"Ada","note":"a, b"}How it works
- It reads CSV, TSV, semicolon, pipe, and Markdown tables, pasted spreadsheet tables, JSON objects, JSON Lines, and lists as one-column tables.
- It writes JSON, JSON Lines, YAML, XML, CSV, TSV, semicolon, pipe, Markdown and HTML tables, SQL INSERT, SQL CREATE TABLE, TypeScript types, and JSON Schema.
- Separators, quotes, and line breaks inside values are quoted or escaped as each format requires.
- JSON keeps null, empty, and missing values apart. Text formats write them as empty fields, and a note says so. Nested JSON becomes dot-path columns in tables, and nested objects again in JSON.
- Use the result as the next input, or inspect it, in one click.