Format Converter
Convert tables into data, table, SQL, and type formats.
Your data stays in your browser
Advertisement
Source table
Waiting for data
Output format
Converted data
No resultEnter or interpret a flat table to convert it.
Advertisement
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.