If you do a lot of data import and exports, you are probably very familiar with using comma or tab delimited files. If you have to edit these files, however, using a text editor can be challenging because typically these types of files are difficult to work with in just plain text. While Excel is a good tool for working with delimited files, a powerful utility which specializes in this task is CSVed.

CSVed is a free (see below) utility which does a lot more than a text editor or Excel (without some macro/formula magic that is) does, including:

• change separator
• save filtered items
• remove duplicates
• add prefix and suffix

CSVed is designed for working with delimited files only, so it should do just about anything you would need. This tool is postcardware, so if you use it and like it, let the author know.