Comma separated value (CSV) files store tabular data as text files. Lots of programs use them, including spreadsheets, e-mail clients, and databases. CSVed is freeware that can manipulate any CSV file with any separator. It can add, delete, edit, and insert items; import and export data; remove duplicates; join and split columns; add, delete, and rearrange columns; search and sort; and more.
CSVed has a full-featured interface with a four-in-one toolbar, a navigation/clipboard sidebar, and a main document view above a handy editing panel that is tabbed with all the program's major functions. There's a Font manager, naturally, but we were surprised to see quite a few skins available under the Tools menu, as well as a portable version. CSVed is quite easy to use. We opened a single-column CSV file and started by adding a second column. We clicked the Column Tab, selected Add-Insert Column, and entered a Value and Caption; simply "Column 2." CSVed added our new column, which we could edit extensively from the Start and Edit Item tab. Next we joined Column 2 to Column 1 with the Join Column tool, which also gave us the option of inserting text between the columns. This tab also let us split the file and columns in various ways. Other tabs let us add leading zeros; modify items with prefixes, suffixes, and other values; filter text and remove duplicates; and save, sort, and search items. An XML tab let us export CSV files to XML format with various options, while the interesting Fixed Field Length Manager let us configure minimum and maximum field length, set values for all fields and checked fields, and set the minimum space between columns.
If there's something you need to do with CSV files, CSVed seems able to handle it. It's the most capable and comprehensive tool of its type we've come across, yet it's intuitive and well laid out. Since it's free, there's no reason not to avail yourself of its powerful capabilities, even if you only handle CSV files now and then. If CSV files are a regular part of your Windows experience, CSVed is probably just what you've been waiting for.