Features
⚡
Open files bigger than 2GB and containing more than 15 million rows. Opening a 100MB CSV file with more than 500,000 lines takes less than 5 seconds on a dual-core Macbook Pro.
⌨
Use Javascript as a macro language to manipulate your CSV files. A simple API gives you access to all cells and you can change cell content as well as do abitrary calculations.
➟
Export your table data to JSON. The exported JSON is an array-of-objects if there's a header row present in your CSV data. Otherwise you'll get an array-of-arrays.
🗃
Automatically detects most CSV file formats and file encodings for you. If you want, you can easily override the automatic detection and choose the appropriate CSV parameters.
📄
Open and save CSV files with one of these encodings: UTF-8, UTF-16LE, UTF-16BE, Latin-1 (ISO-8859-1) and Windows 1252 files. (These list will be extended in future updates.)
🔎
Use the powerful Find and Replace dialog to search for patterns in your table or in a selected area. Regular Expressions according to the ECMAScript 5 standard are supported.
🎨
Enjoy crunching your data with four beautifully designed color themes, including a dark theme that fits well with the Mac's dark mode.
𝌘
Flag rows manually or with the Find and Replace dialog and export flagged rows as a new CSV file.
𝌅
Modify your CSV data grid easily. You can sort lines alphabetically or numerically, move columns right or left or delete columns. Or set your first CSV row as a header row.
FAQ
CSV files are text files containing tabular data. The fields of the tables are separated by a special character, usually a comma, while a line break denotes a new record. The abbreviation CSV stands for Comma Separated Values.
There is no formal definition, it's an ad-hoc-format. There exists an RFC 4180 that describes a best practice approach, but it's in no way an official formal definition.
Yes, the application runs on all macOS releases since 10.15 Catalina up to the newest macOS Sequoia (macOS 15).
Yes! Tablecruncher was one of the first applications to natively support Apple Silicon (ARM64) like M1, M2, M3 etc.
Since version 1.7.0 Tablecruncher we offer a dedicated Apple Silicon version and a version for Intel Macs. This allows us to
support older Intel Macs while concentrating on the newer macOS versions for Apple Silicon.
Tablecruncher is written in C++17, using the GUI framework FLTK. UTF-8 handling is provided by UTF8-CPP. Duktape is the Javascript interpreter for the macro language and the JSON export routines are from Niels Lohmann's JSON libary.
To achieve the best possible performance, I decided to use C++ and the extremely fast FLTK toolkit. So, Tablecruncher is not written with an Apple-only tech stack. Result is a really fast application, but I know it never will win any design price. It aims to be a tool and like real tools it's not necessarily beautiful.
Just send an email to info@tablecruncher.com. I'll be happy to include it on my ever growing list of planned features, but make no promise that it'll ever be implemented.