Csv editor

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)