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.

CSV in Text Editor

Numbers:

Numbers CSV Edit

Save as CSV after editing:

Export to CSV

Note that you can choose text encoding as well when exporting if needed for other systems.