Tablecruncher

The lightning-fast CSV editor for your Mac.

New version published: Dec 4th, 2018
Download Tablecruncher Beta

requires Mac OS X El Capitan, macOS Sierra, High Sierra or Mojave

License credentials for beta versions:
Name: Beta
Key: A794-F864-DC40-4B02-B1CB-9690-ED90-BBAE-F3AF-3212-8AA0

  • [screenshot]
    (All data in the screenshot is fake data.)
  • [screenshot]
    New: Solarized Bright Theme
    (All data in the screenshot is fake data.)
  • [screenshot]
    New: Dark Theme
    (All data in the screenshot is fake data.)
  • [screenshot]
    Improved: Find and Replace dialog
    (All data in the screenshot is fake data.)
  • [screenshot]
    Dialog to open CSV files with different encodings
  • [screenshot]
    Cells to be deleted are highlighted
Tabular data is everywhere and developers have to deal with sometimes very huge 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.

Features

  • Automatically detects most CSV file formats and file encodings.
  • Currently opens and saves UTF-8, UTF-16LE, UTF-16BE, Latin-1 (ISO-8859-1) and Windows 1252 files.
  • Sort lines alphabetically or numerically
  • Move columns left or right
  • Handles 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.

FAQ

  • What's the newest version?
  • At the moment 0.9.6 beta is the most up-to-date version. This beta version will work until Jun 30, 2019.
  • 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 macOS Mojave?
  • Yes, the application runs on macOS 10.14 called Mojave. But there is no real support for Mojave's dark mode at the moment. The newly introduced dark theme is intended to be used in dark mode as it should fit in a dark desktop environment.
  • What language and frameworks did you use to create Tablecruncher?
  • Tablecruncher is written in C++11, using the GUI framework FLTK. UTF-8 handling is provided by UTF8-CPP and Boost Locale.
  • 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.

The Story So Far

Beta 0.9.6 published

This shiny new beta version is again loaded with several new features you've requested. Columns can be moved to the left or the right now, while rows can be sorted. Additionally Tablecruncher is now able to open and save CSV files with UTF-16LE and UTF-16BE encoding, thus providing even better interoperability. If the first row of a file looks like a header row, Tablecruncher will show it as a header row on opening the file.
A license key is now needed to activate copying and saving data. For beta versions the license credentials can be found above just below the download link and are also noted in the readme file provided with the application.

Beta 0.9.5 published

As we're getting closer to 1.0 release, this new beta version introduces several new features and improvements. A lot of work went into improving the user experience, including two new color themes and a better zoom feature. The number of undo steps is now unlimited and should come handy when editing CSV files. The first row can be treated as a header row and you can easily switch between both views. The Window menu provides better support now for handling multiple windows and tabs.

Working on 1.0 release

I'm working heavily to get version 1.0 ready for autumn. A lot of bug fixing, refactoring and implementing new features is going on. But my main focus is on improving the user experience a lot. Stay tuned for further releases.

Beta 0.9.2 published

I've just published 0.9.2 beta containing several minor bug fixes. Please continue testing and I'll appreciate your feedback!

Public Beta test started today

Today the first public beta 0.9.0 has been released. I'm very excited and looking forward for your feedback. Happy testing!

Starting Beta test in just a few days

Having implemented the last missing features several weeks ago, I'm testing the application with lots of different CSV files right now. Be prepared that the public beta test will start early in October. If you haven't done so, please sign up for the newsletter to get a message when the test will start.

A name for my CSV editor

I have now used my internal versions for nearly a year, and soon will be the day to start beta testing my application. So I finally needed a website as well as a name. Choosing a name for your application isn't really easy. Finding names is the fun part, but checking available accounts and researching legal concerns is extremely time consuming. After having played with a dozen ideas, I now settled for Tablecruncher.

I hope the name describes well enough, what I want my editor to do: To easily crunch all your tabular data in all the CSV files that you get in your projects from different sources.

First internal Alpha Build

More than a year later, I now have a working early alpha version. As performance is one of my major concerns, the CSV editor is written plain C++ using the FLTK framework. The FLTK table view widget handles really large tables extremely well and the editor is impressingly fast.

I just started to work on an CSV editor for the Mac

As I'm working on several projects where a lot of data from different databases or spreadsheet exports is involved, I'm lacking an editor on my Mac that can easily handle large CSV files, guess the correct format and open documents with the right encoding. Always looking for an excuse to avoid my day to day work, I started writing my own CSV editor today.