CSVed

CSVed is the most complete and fully fledged editor for CSV files (comma-separated values). Such files are commonly exported from a database that needs special treatment on other programs, it is the preferred format to exchange data.

By defining field and line separators, it is very easy to rebuild the original tabular structure before generating the CSV file.
This tiny and freeware utility can be called the swiss-knife of CSV manipulation. You can do everything you want, really: alter the structure, add/delete records, modify data, search/replace, text view, set a fixed length per column and many, many more.
One of the best features is the on-demand data load. Because of this feature, this little program can handle very large files without problem.
If you work daily with databases and data export, you will love this software. It takes a while to get familiar with the complicated user interface, because of the number of options presented all together on the screen. But you will save a valuable time later, I'm sure.