CSV2CSV reformats CSV files, and in the process, allows for various modifications. Columns from a source CSV can be copied verbatim, or merged together, or re-ordered; columns can also be deleted, new columns can be added, and static data can be appended and prepended to existing columns.

If a record has too many or too few fields, or if a field is too long, a form will be displayed where manual corrections can be made.

No changes are made to the source CSV; each modified record is written to a new CSV file.

Summary of features

• supports up to 500 different rulesets
• interactive problem record and field editors
• option to ignore first x lines of sourcefile (usually fieldnames)
• option to output customised fieldnames as first line of outfile
• can amalgamate multiple columns into one (with customisable separator character)
• can add new columns
• can append/prepend data to columns
• can substitute one item of data for another
• can clean up numeric data
• can strip whitespace
• can insert today's date into the data
• supports delimited, partially-delimited or undelimited sourcefiles
• input/output filesize limited only by available diskspace
• full logging

Screenshots:

raw data A sample input file. configuration The contents of CSV2CSV.INI

in action This shot shows off CSV2CSV's record editor. A field editor is also provided.

output A sample output file.