A simple CSV editor for OS X.
The CSV format is a common used file format to store and exchange tabular data. Almost all spreadsheet and database apps (e.g. Excel and Numbers) support it. Unfortunately, not all CSV files are made equal. There are differences either in record delimiter, character encoding, decimal separator or quote style. These differences can lead to serious errors.
TableTool handles these issues automatically. It detects the specification of a CSV file for you and displays its contents in a table view. Using TableTool is the easy way to create, edit and convert CSV files.
Open Files: When opening a CSV file, TableTool detects the format specifications (record delimiter, character encoding, etc.) automatically. You can also set the specifications manually.
Edit Files: Edit the contents of the cells, rows and columns of the document easily in a grid based user interface.
Convert Files: Convert an existing CSV file to a different format.
Table Tool is released as Open Source under the MIT License. The source code is available on Github.
- fixed a problem where files with unrecognised format could not be opened
- fixed an issue where Table Tool didn't work on older versions of macOS
Ratings and Reviews
This is what I was looking for
I was looking for a way to view data files that are CSV-like (tab-delimited, with multiple header rows), and this app basically does the job. I do wish for a few things:
- Allow opening a file by drag-and-drop
- Allow setting the default Separator (rather than always assuming comma)
- Allow setting the number of header rows, rather than assuming there is only 1 header row. For me, the header is actually on line 5 or 7, etc, and the previous rows are just comments.
Nice for copy/pasting individual columns into Numbers
I work with Python to generate CSVs that eventually are imported into Numbers for graphing. While I could just open the CSV in numbers, select the column I want to import, copy it, and paste it into the target table, Numbers opens new documents in a window that stretches to the full height of the screen, which hides the target table. Very irritating. Another option I've used is AppleScript within an Automator workflow, but AppleScript is likely not long for this world (aside from being the most unintuitive language on the face of the Earth) so I'm weaning myself from being so dependent on it. Hoping Swift + Automator will be a thing soon...
Table Tool to the rescue. Using Open with... -> Table Tool (I've set this as the default app for CSV), I can now select the column heading to copy in Table Tool, Cmd+C from that and Cmd+V into the Numbers table (which is no longer hidden). It's a small thing, but every bit of friction removed from daily workflows is welcome!
Thanks to the devs for this lightweight tool!
Near Perfect - one minor item
Nice easy to use comma delimited file editor. Perfect for Salesforce Administrators looking to clean up Data Loader import or error files or anybody tired of the Excel importer transmogrifiying the original data when you don't want it to.
It's hard to complain about this near perfect free utility. I only have one nit pick about this app and that is the inablity to edit the header line on new or existing columns.
I purchase this authors great MDB ACCDB Viewer and recommend it as well.
With Family Sharing set up, up to six family members can use this app.