Data Format Converter
Convert between CSV, TSV, JSON, Markdown, HTML, and SQL table formats instantly
Input Format
Output Format
Input (CSV)
Output (JSON)
Supported Conversions
| From ↓ / To → | CSV | TSV | JSON | Markdown | HTML | SQL |
|---|---|---|---|---|---|---|
| CSV | — | ✓ | ✓ | ✓ | ✓ | ✓ |
| TSV | ✓ | — | ✓ | ✓ | ✓ | ✓ |
| JSON | ✓ | ✓ | — | ✓ | ✓ | ✓ |
| Markdown | ✓ | ✓ | ✓ | — | ✓ | ✓ |
| HTML | ✓ | ✓ | ✓ | ✓ | — | ✓ |
| SQL | ✓ | ✓ | ✓ | ✓ | ✓ | — |
Free Online Data Format Converter — CSV, JSON, Markdown, HTML, SQL & TSV
Working with data across different systems almost always involves switching between formats. A spreadsheet exported from Excel is a CSV file. A REST API returns JSON. A database tool expects SQL INSERT statements. A documentation site wants a Markdown table. Manually re-formatting data between these structures is tedious and error-prone — that's exactly the problem this tool solves.
The OmniWebKit Data Format Converter handles six widely used tabular data formats: CSV (comma-separated), TSV (tab-separated), JSON (array of objects), Markdown tables, HTML tables, and SQL INSERT statements. Conversion is bidirectional — you can convert any format to any other format, in all 30 possible direction combinations. The output updates live as you type or paste input.
Everything runs in your browser. No file is uploaded to any server. Paste your data, choose the input and output formats, and copy or download the result. For CSV files, the tool auto-detects whether the delimiter is a comma, tab, semicolon, or pipe — or you can set it manually.
All Six Formats Explained
CSV (Comma-Separated Values)
CSV is the most universally supported data interchange format. It is what spreadsheet applications (Excel, Google Sheets, LibreOffice Calc) export by default. CSV files contain rows of data where each value is separated by a comma. This tool supports proper RFC 4180 CSV parsing — quoted fields, embedded commas, embedded newlines, and escaped double-quotes all parse correctly. The delimiter auto-detection feature handles files that use semicolons (common in European locales) or tabs instead of commas.
TSV (Tab-Separated Values)
TSV is a simpler alternative to CSV that uses a tab character as the delimiter instead of a comma. Because tab characters almost never appear in actual data, TSV files rarely need quoted fields, making them slightly easier to process programmatically. Databases and spreadsheet tools often support TSV paste and export. This tool handles TSV as a separate format with automatic tab detection.
JSON (JavaScript Object Notation)
JSON is the standard data format for web APIs. The input must be a JSON array of objects, where each object represents a row and the object keys become the column headers. The output JSON uses 2-space indentation for readability. JSON conversion is particularly useful when you want to take a CSV export from a database or spreadsheet and prepare it for use in a JavaScript application or REST API.
Markdown Tables
Markdown table syntax is used in GitHub READMEs, documentation sites (like MkDocs and Docusaurus), note-taking apps (Notion, Obsidian), and static site generators. The converter produces properly aligned Markdown tables where column widths are padded for readability. It also parses existing Markdown tables back to other formats — useful when you want to pull data from a README file into a spreadsheet or database.
HTML Tables
HTML tables are the format used for embedding tabular data in web pages. The converter produces clean, semantic HTML with a <table>, <thead>, <tbody>, <th>, and <td> structure, making it easy to drop into any webpage or CMS. The HTML parser can also read existing HTML table markup and convert it to any other format — helpful when scraping table data from a webpage.
SQL INSERT Statements
The SQL output generates a ready-to-run series of INSERT INTO statements using a table name you specify. Each row in the data becomes one INSERT statement. String values are automatically single-quoted, and single quotes within values are escaped using the SQL standard double-single-quote method, preventing SQL injection in the generated script. This format is useful for migrating data from a spreadsheet into a database.
How to Convert Data Formats
- 1
Choose your input format
Click the input format button that matches your source data — CSV, TSV, JSON, Markdown, HTML, or SQL. The textarea label updates to show which format is expected.
- 2
Paste your data or upload a file
Paste your data directly into the input textarea, or click the Upload button and select a file. The tool automatically detects the file format based on the file extension (.csv, .tsv, .json, .md, .html, .sql).
- 3
Select the output format
Click the output format button for the format you want to convert to. The conversion happens automatically — no Convert button to press.
- 4
Configure options if needed
For CSV input, choose the delimiter (comma, semicolon, tab, or pipe) if auto-detection doesn't work correctly. For SQL output, enter your target table name.
- 5
Copy or download the result
Click Copy to copy the output to your clipboard, or Download to save the converted file with the correct extension (.csv, .json, .md, .html, .sql, .tsv).
- 6
Swap formats to reverse the conversion
Click the ⇆ swap button between the format selectors to flip the input and output formats and use the converted output as new input. This is useful for a multi-step conversion workflow.