CSV Converter is a simple application for opening, editing and saving CSV files. The CSV file format is widely used to exchange data arranged in a table, like in a Numbers or Excel spreadsheet.
CSV Converter was writted to be able to open CSV files that some apps are having problems with, preview the tabular data and re-save it without the internal inconsistencies that cause the issue.
Additionally, it can export the table in various formats like RTF, Word, Open Document text and as a MultiMarkdown table. It can also copy the table to the clipboard in the format that iWork uses.
The supported separators are comma, semicolon (;), tab and pipe symbol (|).
There is automatic text encoding detection, but you can choose the encoding manually from the "File" menu. The same goes for the header row: automatic detection with a manual override. Just open your file and let CSV Converter reopen it with different settings if you have a file that is out of the ordinary.
The detected values for line endings, list separator and encoding are displayed when using "Save As". This is also useful if you need to match a certain set of CSV parameters. Just set them to those CSV Converter found for the file, whose structure needs to match that of another.
You can ask CSV Converter to open any file. It doesn't need to have a ".csv" at the end of the file name. This doesn't mean CSV Converter can do something useful with every file, but it will try very hard.
There is basic editing support, but the main purpose of the app is getting usable data out of CSV files and into other formats. You can edit the contents of cells with full undo and redo. Column headers can be edited via their contextual menu.
If you need to sort multiple columns, you can do it this way: you sort the columns in the reverse (!) order of precedence. So if you want to sort by Last Name and then First Name you just sort the First Name column and then the Last Name column.