Best CSV Tools

Interactive grid for viewing, sorting, searching, and editing CSV files. Editable cells, column sorting, and live search.

Normalize CSV formatting: choose delimiter, quote style, add remove BOM, and trim cells.

Validate CSV files for ragged rows, duplicate headers, empty rows, encoding issues, and more.

Merge 2+ CSV files by stacking rows and aligning columns by header name. Add a source file column to track provenance.

Remove duplicate rows from CSV — by full row match or by specific key columns. Choose keep first or last occurrence.

Transform CSV rows into GitHub-flavored Markdown table syntax with proper pipe alignment and escaping.

Convert CSV to TSV or TSV to CSV with proper quoting and escaping.

Compute per-column stats: count, unique count, null/empty count, and numeric columns get min, max, avg.

Sort CSV rows by any column, ascending or descending, with auto/numeric/alphabetical type detection.

Convert CSV to SQL with CREATE TABLE, INSERT statements, and multiple dialect support (MySQL, PostgreSQL, SQLite, ANSI).

Divide a CSV into multiple smaller files — by row count per chunk or by unique values in a chosen column.

Analyze CSV text to automatically determine the delimiter in use — comma, semicolon, tab, or pipe.

Row-aware CSV comparison matched by a key column. Shows added, removed, changed, and unchanged rows with cell-level detail.

Detect types for every CSV column: number, boolean, date, string, or empty. See sample values for each column.

Filter CSV rows by one or more conditions (equals, contains, greater than, etc.) combined with AND/OR logic.

Fix garbled characters, mojibake, and BOM issues in CSV files. Add or remove UTF-8 BOM for Excel compatibility.

Paste or drop a CSV and instantly get structured JSON. Smart numeric coercion, pretty-print, and copy/download.