Intact CSV Editor vs Tablecruncher
A CSV editor built to open files too big for everything else and to change them with JavaScript macros. Intact CSV Editor does 47 things we did not find in Tablecruncher's manual or on its website — byte-for-byte saving, SQL queries and Parquet files among them — and 18 of the 19 features Tablecruncher lists.
things Intact CSV Editor does that we did not find in Tablecruncher's manual or on its website, of the 57 we compared.
of the features Tablecruncher lists are in Intact CSV Editor too.
of the features Tablecruncher lists Intact CSV Editor does not have yet.
47 things we did not find in Tablecruncher's manual or on its website.
We read the manual (v1.8), the home page and the tutorials on 3 September 2026, and looked for each of them there.
Keeping data intact
- Keeps the byte-order mark
- Keeps comment lines
- Mainframe EBCDIC code pages
- Refuses a character the encoding cannot hold
- Saves a file back byte for byte
Opening files
- Fixed-width files, with layouts you can keep
- Rules for the files in a folder
- Tables from web pages
- Log files read into columns by a pattern
- OpenDocument spreadsheets
- Parquet, Avro, ORC and Arrow, read and written
- SQLite databases
- SPSS, Stata, SAS, R and MATLAB files
- Open a file from a link
- vCards and your Mac's Contacts
- Excel workbooks, opened and saved as workbooks
Editing and cleaning
- The column's own values offered as you type
- Clusters of similar values, merged on request
- A filter on every column heading, with counts
- Fill handle that continues a series
- JSON inside a cell, edited as a tree
- Sort by several columns, then back to the file's order
- Reshape: wide to long, a cell split into rows
- Stack several files into one
Analysis
- Compare two files, value by value
- Look values up in another table
- Summaries and pivot tables with subtotals
- Rules for each column, checked on every row
- SQL across every open file
- Statistics for every column
Automation
- AppleScript and Shortcuts
- A command-line tool and links into the app
- Shortcuts you can change, sequences too
- A command palette
- Send the table through any program
Export
- Copy as Markdown, JSON, SQL, HTML and more
- Word and rich text
- Export to more than 30 formats
- HTML tables that sort themselves
- PDF export, PDF/A too
- Saved export presets
Safety
- A copy kept before every save
- Lock a file against changes
- Unsaved work recovered after a crash
- Settings kept in a small file beside the data
- Knows when another program changes the file
On the Mac
- Eight languages
Every feature we compared.
| Feature | Tablecruncher | |
|---|---|---|
| Keeping data intact | ||
| Saves a file back byte for byte | Intact CSV Editor | —Not in their documentation |
| Detects the text encoding | Intact CSV Editor | Documented |
| Mainframe EBCDIC code pages | Intact CSV Editor | —Not in their documentation |
| Keeps the byte-order mark | Intact CSV Editor | —Not in their documentation |
| Keeps comment lines | Intact CSV Editor | —Not in their documentation |
| Refuses a character the encoding cannot hold | Intact CSV Editor | —Not in their documentation |
| Quoting per column and per cell | Intact CSV Editor | In part |
| 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 |
| Tables from web pages | Intact CSV Editor | —Not in their documentation |
| 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 in their documentation |
| Open a file from a link | Intact CSV Editor | —Not in their documentation |
| Fixed-width files, with layouts you can keep | Intact CSV Editor | —Not in their documentation |
| Millions of rows | Intact CSV Editor | Documented |
| Rules for the files in a folder | Intact CSV Editor | —Not in their documentation |
| Editing and cleaning | ||
| The column's own values offered as you type | Intact CSV Editor | —Not in their documentation |
| Fill handle that continues a series | Intact CSV Editor | —Not in their documentation |
| JSON inside a cell, edited as a tree | Intact CSV Editor | —Not in their documentation |
| Find and replace with regular expressions and a preview | Intact CSV Editor | Documented |
| A filter on every column heading, with counts | Intact CSV Editor | —Not in their documentation |
| Sort by several columns, then back to the file's order | Intact CSV Editor | —Not in their documentation |
| Duplicates judged on the columns you choose | Intact CSV Editor | In part |
| Rewrite dates and number formats | Intact CSV Editor | In part |
| Reshape: wide to long, a cell split into rows | Intact CSV Editor | —Not in their documentation |
| Stack several files into one | Intact CSV Editor | —Not in their documentation |
| Clusters of similar values, merged on request | Intact CSV Editor | —Not in their documentation |
| Analysis | ||
| SQL across every open file | Intact CSV Editor | —Not in their documentation |
| Summaries and pivot tables with subtotals | Intact CSV Editor | —Not in their documentation |
| Statistics for every column | Intact CSV Editor | —Not in their documentation |
| Look values up in another table | Intact CSV Editor | —Not in their documentation |
| Compare two files, value by value | Intact CSV Editor | —Not in their documentation |
| Rules for each column, checked on every row | Intact CSV Editor | —Not in their documentation |
| Automation | ||
| JavaScript macros | Intact CSV Editor | Documented |
| Send the table through any program | Intact CSV Editor | —Not in their documentation |
| AppleScript and Shortcuts | Intact CSV Editor | —Not in their documentation |
| A command-line tool and links into the app | Intact CSV Editor | —Not in their documentation |
| A command palette | Intact CSV Editor | —Not in their documentation |
| Shortcuts you can change, sequences too | Intact CSV Editor | —Not in their documentation |
| Export | ||
| Export to more than 30 formats | Intact CSV Editor | —Not in their documentation |
| PDF export, PDF/A too | Intact CSV Editor | —Not in their documentation |
| Word and rich text | Intact CSV Editor | —Not in their documentation |
| Copy as Markdown, JSON, SQL, HTML and more | Intact CSV Editor | —Not in their documentation |
| HTML tables that sort themselves | Intact CSV Editor | —Not in their documentation |
| Saved export presets | Intact CSV Editor | —Not in their documentation |
| Split a file into several | Intact CSV Editor | Documented |
| Safety | ||
| A copy kept before every save | Intact CSV Editor | —Not in their documentation |
| Unsaved work recovered after a crash | Intact CSV Editor | —Not in their documentation |
| Knows when another program changes the file | Intact CSV Editor | —Not in their documentation |
| Lock a file against changes | Intact CSV Editor | —Not in their documentation |
| Settings kept in a small file beside the data | Intact CSV Editor | —Not in their documentation |
| On the Mac | ||
| Eight languages | Intact CSV Editor | —Not in their documentation |
Choose Intact CSV Editor if…
- You write macros: Intact CSV Editor's macros use Tablecruncher's vocabulary —
getString,setCell,ROWMINand the rest. - 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, JSON, Parquet, SPSS, Stata, SAS, EBCDIC and more — and export to 33 formats.
- You want SQL across files, 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.
TChoose Tablecruncher if…
- A browser version, for machines where nothing can be installed.
- A focused, small tool.
Intact CSV Editor's macros use the same vocabulary as Tablecruncher's — getString, setCell, ROWMIN and the rest — so a Tablecruncher macro runs here.
| Intact CSV Editor | Tablecruncher | |
|---|---|---|
| What it is | Native Mac editor for CSV and 30+ data formats | Large-file CSV editor with macros |
| Runs on | Mac (macOS 14 or later) | Desktop app, plus a browser version |
| Only here | 47 of the 57 features we compared | 0 of the 19 features it lists |
Where Tablecruncher is ahead
Going by its documentation, in no feature: all 19 that Tablecruncher lists are in Intact CSV Editor. It may still be the better choice for you — see above.
https://tablecruncher.com — read 3 September 2026: the manual (v1.8), the home page and the tutorials. Product names belong to their owners. Found something out of date? Tell us.
Everything Tablecruncher documents — 19 features, and whether Intact CSV Editor does it
| Tablecruncher documents | In Intact CSV Editor |
|---|---|
| Row flagging — mark rows by hand and act on the marks | Yes |
| Flag the rows that a search matched | Yes |
| A macro language over the table | Yes |
| Split one file into several by row count | Yes |
| Merge two columns with a glue string, and split a column at the first occurrence of a string | Yes |
| Check data consistency and flag the rows that fail | Yes |
| Jump to a cell by column name | Yes |
| Paste into the selection without parsing it as CSV | Yes |
| Type a newline or a tab into a cell | Yes |
| A mark on cells that hold more than one line | Yes |
| Quoting: around all strings | Yes |
| Undo that can be turned off | Yes |
| A browser version of the app | Not applicable |
| Opening files over 2 GB / 15 million rows | Yes |
| Format detection with a manual override | Yes |
| JSON export, as objects or as arrays | Yes |
Regular expressions in find and replace, with $1 backreferences | Yes |
| Sort by clicking or right-clicking a column header | Yes |
| Four themes including dark | Yes |
About this comparison
Is Intact CSV Editor a good alternative to Tablecruncher?
For most people who work on a Mac, yes. It does 18 of the 19 features Tablecruncher lists, and 47 things we did not find in Tablecruncher's manual or on its website — byte-for-byte saving, SQL queries and Parquet files among them. Where Tablecruncher is ahead is listed on this page too.
Does Intact CSV Editor have more features than Tablecruncher?
Of the 57 features of Intact CSV Editor we looked for in Tablecruncher's manual or on its website, we found 10, some of them only in part; the other 47 we did not find. The other way round, Intact CSV Editor lacks 0 of the 19 features Tablecruncher lists.
How was this comparison made?
We read the manual (v1.8), the home page and the tutorials on 3 September 2026. Every feature Tablecruncher lists was checked against Intact CSV Editor, and every one of Intact CSV Editor's was looked for in Tablecruncher's pages. A dash means we found nothing like it there; Tablecruncher may do more than it documents. If something has changed, write to info@marketvision.ch and we will correct it.
Coming from Tablecruncher? Bring your files.
Open the files you work on today and see them come back unchanged. Seven days free, fourteen with an account, no card.
macOS 14 Sonoma or later · See pricing