Intact CSV Editor vs EmEditor
A Windows text editor famous for huge files, with a strong set of CSV tools. There is no Mac version. Intact CSV Editor does 12 things we did not find on EmEditor's CSV tools page — Parquet files, Excel workbooks and SPSS files among them — and 23 of the 24 features EmEditor lists.
things Intact CSV Editor does that we did not find on EmEditor's CSV tools page, of the 41 we compared.
of the features EmEditor lists are in Intact CSV Editor too, and 1 more in part.
of the features EmEditor lists Intact CSV Editor does not have yet.
12 things we did not find on EmEditor's CSV tools page.
We read its CSV tools page on 6 September 2026, and looked for each of them there.
Opening files
- Delta Lake and Iceberg tables
- OpenDocument spreadsheets
- Parquet, Avro, ORC and Arrow, read and written
- Python pickles, Feather and MessagePack
- NetCDF and HDF5 scientific data
- SQLite databases
- SPSS, Stata, SAS, R and MATLAB files
- The value labels of an SPSS or Stata survey kept
- vCards and your Mac's Contacts
- Old .xls and binary .xlsb workbooks
- Excel workbooks, opened and saved as workbooks
Automation
- AppleScript and Shortcuts
Every feature we compared.
| Feature | EmEditor | |
|---|---|---|
| Keeping data intact | ||
| Saves a file back byte for byte | Intact CSV Editor | ·Not compared |
| Detects the text encoding | Intact CSV Editor | Documented |
| Mainframe EBCDIC code pages | Intact CSV Editor | ·Not compared |
| Keeps the byte-order mark | Intact CSV Editor | ·Not compared |
| Keeps comment lines | Intact CSV Editor | ·Not compared |
| Refuses a character the encoding cannot hold | Intact CSV Editor | ·Not compared |
| Quoting per column and per cell | Intact CSV Editor | ·Not compared |
| A workbook saved back with its other sheets, formats and charts | Intact CSV Editor | ·Not compared |
| Every character set compared side by side before you choose | Intact CSV Editor | ·Not compared |
| Opening files | ||
| Separator, quotes and line endings detected and shown | Intact CSV Editor | Documented |
| Excel workbooks, opened and saved as workbooks | Intact CSV Editor | —Not in their documentation |
| OpenDocument spreadsheets | Intact CSV Editor | —Not in their documentation |
| JSON, JSON Lines, YAML and XML as tables | Intact CSV Editor | In part |
| Parquet, Avro, ORC and Arrow, read and written | Intact CSV Editor | —Not in their documentation |
| SPSS, Stata, SAS, R and MATLAB files | Intact CSV Editor | —Not in their documentation |
| SQLite databases | Intact CSV Editor | —Not in their documentation |
| Old .xls and binary .xlsb workbooks | Intact CSV Editor | —Not in their documentation |
| Delta Lake and Iceberg tables | Intact CSV Editor | —Not in their documentation |
| NetCDF and HDF5 scientific data | Intact CSV Editor | —Not in their documentation |
| Python pickles, Feather and MessagePack | Intact CSV Editor | —Not in their documentation |
| GeoJSON and TOML | Intact CSV Editor | ·Not compared |
| The value labels of an SPSS or Stata survey kept | Intact CSV Editor | —Not in their documentation |
| Tables from web pages | Intact CSV Editor | ·Not compared |
| vCards and your Mac's Contacts | Intact CSV Editor | —Not in their documentation |
| Log files read into columns by a pattern | Intact CSV Editor | ·Not compared |
| Open a file from a link | Intact CSV Editor | ·Not compared |
| Fixed-width files, with layouts you can keep | Intact CSV Editor | ·Not compared |
| Millions of rows | Intact CSV Editor | Documented |
| Rules for the files in a folder | Intact CSV Editor | ·Not compared |
| Only part of a huge file opened | Intact CSV Editor | ·Not compared |
| A file followed as it grows, like tail -f | Intact CSV Editor | ·Not compared |
| Quick Open by a few letters of a file's name | Intact CSV Editor | ·Not compared |
| Workspaces: the open files and their filters kept under a name | Intact CSV Editor | Documented |
| Editing and cleaning | ||
| The column's own values offered as you type | Intact CSV Editor | ·Not compared |
| Fill handle that continues a series | Intact CSV Editor | Documented |
| JSON inside a cell, edited as a tree | Intact CSV Editor | ·Not compared |
| Find and replace with regular expressions and a preview | Intact CSV Editor | Documented |
| A filter on every column heading, with counts | Intact CSV Editor | Documented |
| Sort by several columns, then back to the file's order | Intact CSV Editor | Documented |
| Duplicates judged on the columns you choose | Intact CSV Editor | Documented |
| Rewrite dates and number formats | Intact CSV Editor | ·Not compared |
| Reshape: wide to long, a cell split into rows | Intact CSV Editor | Documented |
| Stack several files into one | Intact CSV Editor | Documented |
| Clusters of similar values, merged on request | Intact CSV Editor | ·Not compared |
| One change made in every selected cell, as several cursors would | Intact CSV Editor | ·Not compared |
| Paste from the history of recent copies | Intact CSV Editor | Documented |
| The file edited as text, then read back as a table | Intact CSV Editor | ·Not compared |
| Find and replace across every file in a folder | Intact CSV Editor | ·Not compared |
| Matches lit in colours and kept for next time | Intact CSV Editor | Documented |
| A column's spelling checked | Intact CSV Editor | Documented |
| Analysis | ||
| SQL across every open file | Intact CSV Editor | In part |
| Summaries and pivot tables with subtotals | Intact CSV Editor | Documented |
| Statistics for every column | Intact CSV Editor | In part |
| Look values up in another table | Intact CSV Editor | Documented |
| Compare two files, value by value | Intact CSV Editor | Documented |
| Rules for each column, checked on every row | Intact CSV Editor | ·Not compared |
| Charts with trend lines, saved as SVG | Intact CSV Editor | ·Not compared |
| Bars, sparklines and ranks inside the table | Intact CSV Editor | ·Not compared |
| Rules written as, and read from, a JSON Schema | Intact CSV Editor | ·Not compared |
| A web service asked about each row | Intact CSV Editor | ·Not compared |
| Automation | ||
| JavaScript macros | Intact CSV Editor | Documented |
| Send the table through any program | Intact CSV Editor | Documented |
| AppleScript and Shortcuts | Intact CSV Editor | —Not in their documentation |
| A command-line tool and links into the app | Intact CSV Editor | ·Not compared |
| Files converted from the command line, with no window | Intact CSV Editor | ·Not compared |
| A command palette | Intact CSV Editor | Documented |
| Shortcuts you can change, sequences too | Intact CSV Editor | ·Not compared |
| Export | ||
| Export to more than 30 formats | Intact CSV Editor | ·Not compared |
| PDF export, PDF/A too | Intact CSV Editor | In part |
| Word and rich text | Intact CSV Editor | ·Not compared |
| Copy as Markdown, JSON, SQL, HTML and more | Intact CSV Editor | ·Not compared |
| HTML tables that sort themselves | Intact CSV Editor | ·Not compared |
| Saved export presets | Intact CSV Editor | Documented |
| Split a file into several | Intact CSV Editor | Documented |
| Safety | ||
| A copy kept before every save | Intact CSV Editor | ·Not compared |
| Unsaved work recovered after a crash | Intact CSV Editor | Documented |
| Knows when another program changes the file | Intact CSV Editor | ·Not compared |
| Lock a file against changes | Intact CSV Editor | Documented |
| Settings kept in a small file beside the data | Intact CSV Editor | ·Not compared |
| On the Mac | ||
| Eight languages | Intact CSV Editor | Documented |
Choose Intact CSV Editor if…
- You work on a Mac — EmEditor's CSV tools are for Windows.
- Your files must come back exactly as they came — byte for byte, in their own separator, quoting, encoding and line endings.
- You open more than CSV: Excel (old .xls too), JSON, Parquet, Delta Lake, SPSS, Stata, SAS, NetCDF, EBCDIC and more — and export to 38 formats.
- You want SQL across files, charts, column rules, file comparison and a backup before every save, in one app.
- You work on a Mac and want an app made for it, in eight languages, from a company in Zürich you can call.
EChoose EmEditor if…
- A full text editor around its CSV tools.
- A ruler along the columns, as a text editor has.
| Intact CSV Editor | EmEditor | |
|---|---|---|
| What it is | Native Mac editor for CSV and 42 other kinds of data file | Windows text editor with CSV tools |
| Runs on | Mac (macOS 14 or later) | Windows |
| Only here | 12 of the 41 features we compared | 0 of the 24 features it lists |
Where EmEditor goes further
Every feature EmEditor documents is in Intact CSV Editor. In 1 of them, EmEditor does more:
- A ruler
https://www.emeditor.com/text-editor-features/powerful-csv-tools/ — read 6 September 2026: its CSV tools page. Product names belong to their owners. Found something out of date? Tell us.
Everything EmEditor documents — 24 features, and whether Intact CSV Editor does it
| EmEditor documents | In Intact CSV Editor |
|---|---|
| Up to sixty-four saved CSV formats | Yes |
| Freeze the header | Yes |
| Filter lines by column value, and a negative filter that excludes what matches | Yes |
| Insert lines and columns | Yes |
| Remove embedded newlines | Yes |
| Convert between CSV formats | Yes |
| Combine lines | Yes |
| Combine and split columns | Yes |
| Extract columns | Yes |
| Insert sequential numbers | Yes |
| Copy a pattern, and Flash Fill | Yes |
| Transpose | Yes |
| A Manage Columns dialog | Yes |
| Join CSV tables with a real SQL JOIN | Yes |
| Delete duplicate lines, with the duplicates bookmarked | Yes |
| Count common strings, extract the frequent ones | Yes |
| Pivot table | Yes |
| Unpivot — columns back into rows | Yes |
| Sort by several columns | Yes |
| Open only a named part of a very large file | Yes |
| A ruler | Partly |
| Line numbers | Yes |
| Find only inside embedded newlines | Yes |
| AutoFill in cell-selection mode | Yes |
About this comparison
Is Intact CSV Editor a good alternative to EmEditor?
For most people who work on a Mac, yes. It does 23 of the 24 features EmEditor lists, 1 more in part, and 12 things we did not find on EmEditor's CSV tools page — Parquet files, Excel workbooks and SPSS files among them. Where EmEditor is ahead is listed on this page too.
Does Intact CSV Editor have more features than EmEditor?
Of the 41 features of Intact CSV Editor we looked for on EmEditor's CSV tools page, we found 29, some of them only in part; the other 12 we did not find. The other way round, Intact CSV Editor lacks 0 of the 24 features EmEditor lists. Because we read only that page, 39 general features are left out of the comparison rather than counted as missing.
How was this comparison made?
We read its CSV tools page on 6 September 2026. Every feature EmEditor lists was checked against Intact CSV Editor, and every one of Intact CSV Editor's was looked for in EmEditor's pages. A dash means we found nothing like it there; EmEditor may do more than it documents. If something has changed, write to info@marketvision.ch and we will correct it.
Coming from EmEditor? Bring your files.
Join the beta, open the files you work on today, and see them come back unchanged.
macOS 14 Sonoma or later · How we use your address