CSV/TSV Viewer - Table Display & JSON/SQL Convert

What is CSV/TSV Viewer?

CSV (Comma-Separated Values) / TSV (Tab-Separated Values) are simple text formats representing tabular data. This tool parses CSV/TSV using an RFC 4180-compliant parser and displays it as a sortable table. It also provides conversion to JSON arrays, SQL INSERT, and SQL CREATE TABLE statements.

See also: JSON ⇔ CSV · JSON to SQL

How to Use

1. Paste CSV/TSV text into the input area
2. Select format (CSV/TSV) and header option
3. Click 'Display' to show the table
4. Select conversion target and click 'Convert'

Usage Examples

CSV input:
name,age,city
Alice,30,Tokyo
Bob,25,Osaka

JSON output:
[{"name":"Alice","age":"30","city":"Tokyo"},{"name":"Bob","age":"25","city":"Osaka"}]

Practical use: Convert TSV data copied from Excel to JSON for use in API requests

FAQ

Are commas inside quotes handled correctly?

Yes. The RFC 4180-compliant parser treats commas and newlines inside double-quoted fields as data, not delimiters.

Can it handle large CSV files?

Table display is limited to 1000 rows, but conversion includes all rows.

Is SQL injection prevented?

Yes. Single quotes in string values are escaped as '' in SQL output.

Is my data sent to a server?

No. All processing happens entirely in your browser.

Which delimiters are supported?

In addition to commas (CSV), common delimiters such as tabs, semicolons, and pipes (|) are supported via auto-detection or manual selection.

Related Tools