CSV Tools
A complete toolkit for comma-separated data — convert, merge, validate and clean CSV files. RFC 4180 compliant parsing, and every tool runs locally in your browser.
CSV to JSON Converter
RFC 4180 parsing with header and delimiter options; array or object output.
JSON to CSV Converter
Nested objects flatten to dot keys, arrays merge, Excel-friendly delimiters.
CSV Merger
Combine multiple CSV files by header or stack rows — per-file delimiter sniffing.
CSV Validator
Check column consistency, required columns, empty rows, quotes, duplicates and BOM.
CSV Deduplicator
Drop duplicate rows or key-column matches, with case/space-insensitive options.
Delimiter Detector
Sniff comma, semicolon, tab or pipe with a field-count distribution report.
CSV to SQL
CREATE TABLE plus batched INSERTs for MySQL, PostgreSQL or SQLite, with column types inferred from the data.
CSV to Markdown Table
CSV to a GitHub-flavoured Markdown table with pipe escaping, alignment and a live preview.
Working with CSV
CSV is the lingua franca of spreadsheets: exports from Excel, Google Sheets, databases and payment providers all speak it. Real-world CSV is messy though — different delimiters per region, quoted fields with embedded newlines, duplicate rows and inconsistent column counts. This collection covers the full workflow: detect the dialect, validate the structure, convert to and from JSON, merge multiple files and deduplicate records.
Why these tools are different
All parsing follows RFC 4180 — quoted fields, escaped quotes and embedded newlines are handled exactly as the standard defines. Everything runs entirely in your browser: multi-megabyte exports never leave your device, which matters for customer lists, financial records and any confidential data.
FAQ
Which CSV tool should I start with?
Not sure which delimiter your file uses? Run the Delimiter Detector first — it reports the field-count distribution for comma, semicolon, tab and pipe. Then validate before converting.
Can it handle files exported from Excel?
Yes. European Excel exports typically use semicolons; the tools sniff the delimiter per file or let you pick it explicitly.
Is there a file size limit?
No artificial limit — parsing happens in your device's memory. Typical exports up to tens of megabytes process in seconds.