Default Theme
(All data in the screenshot is fake data.)
Dialog to open CSV files with different encodings
(All data in the screenshot is fake data.)
Find and Replace dialog
(All data in the screenshot is fake data.)
Use Javascript as a macro language
(All data in the screenshot is fake data.)
Dark Theme
(All data in the screenshot is fake data.)
Solarized Bright Theme
(All data in the screenshot is fake data.)
Cells to be deleted are highlighted
(All data in the screenshot is fake data.)

Tablecruncher

The lightweight, yet powerful CSV Editor for your Mac.

Tabular data is everywhere and developers, data scientists or e-commerce managers have to deal with sometimes very large CSV data sets. But the Mac lacks an editor, that is capable of handling these CSV files in a fast and user-friendly way. Tablecruncher is the tool to open, edit, convert, export and save all kind of CSV files, no matter how large they are or what encoding they use.

Download Free Buy Now!
Version 1.6.0
requires Mac OS X El Capitan, macOS Sierra, High Sierra, Mojave, Catalina, Big Sur (Intel/ARM64), Monterey (Intel/ARM64) or Ventura (Intel/ARM64)

News 8th Aug, 2023: New beta version 2023.1-beta05 available!

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

What's the newest version?

At the moment 1.6.0 is the most up-to-date version. This version has been released on 29 Aug 2021.

A major upgrade to version 2 is due this summer. Every license bought within the last twelve months is eligible for a free upgrade to this new version. (Find more details about version 2 in this blog post.)

What are CSV files?

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.

Where's the formal definition for CSV files?

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.

Does Tablecruncher run on the latest macOS releases?

Yes, the application runs on all macOS releases since 10.11 El Capitan up to the newest macOS Ventura.

Will Tablecruncher run natively on Apple Silicon (ARM architecture)?

Yes! Since version 1.5.1 Tablecruncher runs natively on Apple Silicon (ARM64).

What language and frameworks did you use to create Tablecruncher?

Tablecruncher is written in C++14, using the GUI framework FLTK. UTF-8 handling is provided by UTF8-CPP and Boost Locale. Duktape is the Javascript interpreter for the macro language and the JSON export routines are from Niels Lohmann's JSON libary.

Why does Tablecruncher not look like a typical Mac application?

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.

I miss a feature. How can I request it being implemented?

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.

I don't like applications I have to install. Isn't there a web version available?

There is! Head over to our free online CSV editor hosted at app.tablecruncher.com.