CSV Formatter & Converter

Clean CSV or TSV data, remove duplicates, and convert it to JSON in your browser

Files are processed locally and never uploaded. UTF-8 and Shift_JIS input files are supported.

CSV / TSV Input

Open File

Input delimiter

Output format

Trim whitespace in cellsRemove empty rowsRemove duplicate rows (excluding header)

Result

About this tool

The CSV Formatter cleans CSV and TSV data, removes blank or duplicate rows, and converts the result to CSV, TSV, or JSON. It supports quoted multiline cells and reads both UTF-8 and Shift_JIS files entirely in your browser.

Common use cases

Remove duplicate exports before importing contacts, products, or inventory into another system.
Turn spreadsheet CSV data into JSON objects for an API request or development fixture.
Normalize whitespace and blank rows in data received from customers or business partners.
Preview unfamiliar CSV files safely before opening them in a spreadsheet or database tool.