Related Tools
Options at a Glance
- Delimiter: Auto-detect or choose comma, semicolon, tab, or pipe for both files.
- Encoding: UTF-8, Windows-1252, or ISO-8859-1 for file uploads.
- Case-sensitive comparison: When on (default), row content is compared with case. When off, comparison is case-insensitive.
- Download prefix: Optional prefix for downloaded filenames (e.g. diff → diff_only_in_csv1.csv).
What This CSV Compare Tool Offers
Compare two CSV files by row content. See how many rows appear only in the first file, only in the second, and in both. Preview tables show the first 25 rows of each result set. Download or copy only-in-first, only-in-second, and in-both as CSV. Optionally use case-insensitive comparison and a custom download prefix. All processing is client-side.
- Compare by full row: Two rows are equal only if every cell matches. Order does not matter. Toggle case-sensitive or case-insensitive.
- Only in first, only in second, in both: Counts, preview tables (first 25 rows), and download or copy for each set.
- Download and copy: Download only_in_csv1, only_in_csv2, and common as CSV; or copy any set to the clipboard. Optional filename prefix.
- Auto or custom delimiter: Choose Auto to detect from the first line (of either file) or pick comma, semicolon, tab, or pipe. Both files use the same delimiter.
- Encoding for file upload: Select UTF-8, Windows-1252, or ISO-8859-1 when uploading files.
- Client-side and private: Comparison happens in your browser; nothing is sent to a server.
Why Compare CSV Files?
Comparing two CSVs helps find added or removed rows between exports, versions, or sources. Downloading the difference sets lets you audit changes or sync data.
Powered by browser APIs and client-side processing.
Frequently Asked Questions
How are rows compared?
Rows are compared by their full content (all cells). Two rows are the same only if every cell matches. Row order does not matter. You can choose case-sensitive (default) or case-insensitive comparison.
Can I download the rows that are in both files?
Yes. Use the Download in both button to get the common rows as a CSV file. You can also copy any result set (only in CSV 1, only in CSV 2, or in both) to the clipboard.
What is the download prefix for?
If you set a prefix (e.g. diff), downloaded files are named prefix_only_in_csv1.csv, prefix_only_in_csv2.csv, and prefix_common.csv. Leave blank for only_in_csv1.csv, only_in_csv2.csv, and common.csv.
What delimiters are supported?
You can use Auto to detect from the first line of either file, or choose comma, semicolon, tab, or pipe. Both files are parsed with the same delimiter.
Is my data secure?
Yes. Comparison runs entirely in your browser. Your data never leaves your device.