Free .CSV text file editor for Mac OS X?
I am looking for a free editor to edit comma-delimited text files, or .csv format.
Solution 1:
Table Tool
Free and Open Source (MIT License).
Table Tool opens CSV files. It auto-detects character encoding and record separator (comma/semicolon/tab), and supports basic editing operations (like add row, delete row, add column delete column etc).
Table Tool can convert files to a different format.
Table Tool is also available on the Mac App Store.
Solution 2:
Google Docs
I just used Google Docs for exactly this purpose but all I needed to do was extract a column of email addresses from a CSV file.
Note: Google Docs has file size limits, so this is not a silver bullet. A great bullet, but those limitations are critical when applied.
Solution 3:
LibreOffice
LibreOffice does quite a good job now and is compatible even with OS X 10.9
Solution 4:
Numbers
Disclaimer: Free on new Macs
Apple Numbers also opens and saves to CSV. Just had to add to the list.
Numbers:
Save as CSV after editing:
Note that you can choose text encoding as well when exporting if needed for other systems.