A CSV editor that reads the file's own dialect
There is no single CSV. A bank exports semicolons in Windows-1252, a database dumps tabs in UTF-8, a mainframe job writes pipes with a byte-order mark, and a survey tool puts a comment line on top. Intact CSV Editor works out the dialect when the file opens and shows every part of it in the Format inspector, where you can correct it.
| Separators | comma, semicolon, tab, pipe, colon, space, unit separator, or any string you type |
|---|---|
| Quoting | ", ' or none; quotes escaped by doubling ("") or by backslash (\") |
| Line endings | LF, CRLF, CR, and files that mix them |
| Encodings | over 80 — every Unicode form, Windows and ISO code pages, classic Mac OS, DOS, East Asian multi-byte, and EBCDIC |
| Byte-order marks | detected on read, preserved on write |
| Header rows | detected by comparing the first row's types with the body |
| Comment lines | an optional prefix; comments are remembered and written back in place |
| Awkward files | ragged rows, stray quotes, unterminated quotes and blank lines are read rather than rejected |
Saved back byte for byte
Open a CSV and save it without edits and you get the original bytes back. That is covered by automated tests
for every preset, for Windows-1252 and UTF-16 sources, for values with line breaks and doubled quotes inside them,
and for a file of a million rows. When you do edit, the values you did not touch are written back exactly as they
were: 00731 keeps its zeros, 1/2 stays a fraction, 202609100000012345 keeps
every digit.
Quoting is yours to set: as needed, always, non-numeric values, never, or only for separators — and per column or per cell on top. Quote the Columns the File Quoted notices which columns arrived quoted all the way through and writes them back the same way.
TSV, PSV, ASV and European CSV
Tab-separated and pipe-separated files are CSV files with another separator, and open the same way. So do the
semicolon files European Excel writes, with decimal commas in them — 1.234,50 is read as a number where
a number is wanted, and kept as text in the file. ASCII Separated Values use the unit separator
0x1F between values and the record separator 0x1E between records, so a comma, quote or
line break inside a value is just what it looks like; the app reads and writes them too.
Folders that always hold the same kind of file
Exports from one system tend to land in the same folder, in the same shape. Settings ▸ Rules says so once:
a folder or a pattern such as ~/Exports/DE or *.tsv, with the separator, encoding and line
endings to read them with. Detection is set aside for those files, and the window says which rule decided.
Everything you do with a CSV
- Edit in a native grid: type over cells, fill down, drag rows and columns, paste transposed, undo everything.
- Find and filter with regular expressions, conditions and a filter on every column heading.
- Clean up: duplicates by the columns that matter, trim, change case, split and join cells.
- Ask questions with SQL across files, summaries, statistics and lookups.
- Compare two versions of a file, value by value.
- Export to 33 formats — Excel, JSON, Parquet, SQL, PDF — with ten saved presets, RFC 4180 among them.
- Open huge files: 5.2 million rows on screen in under a second.
