Sometimes it’s nice to save spreadsheet as a CSV file because it’s such a basic format that a lot of programs support it. If you’re using Excel to work with CSV files it might be a little overkill, and maybe you’d instead be happier with a more basic editor such as the Tabular Text Editor. The interface is really basic, but at the same time offers a lot of the features you’d want for managing a CSV file. Here’s an overview of what you’ll find in the app:
- Opens data from any format of text file (delimiters can be configured).
- Edit panel easily acivated for multi-line cells or multi-cell updates.
- Organize the columns in your table – add/remove, change the name, change the type.
- Changing the type of the fields in the table allowing correct sorting and filtering. For example changing a column to a date.
- Editing functions include search/replace, split column, merge columns and undo/redo.
- Quickly and easily filter, sort and summarize the data – quick filter access from a context menu on the table.
- Rows can be set to auto-height to display multi-line rows.
- One key press easy search to search the whole table.
- Export to text, HTML, and Excel directly.
The only thing this seems to be lacking is a portable version that makes it easy to run on any machine you work at.
Tabular Text Editor Homepage (Windows only; Freeware)