CSVfix: Windows/UNIX command-line tool for dealing with CSV data

CSV file extension logo

http://neilb.bitbucket.org/csvfix/

CSVfix is a command-line tool specifically designed to deal with CSV data. With it you can, among other things:

  • Reorder, remove, split and merge fields
  • Convert case, trim leading & trailing spaces
  • Search for specific content using regular expressions
  • Filter out duplicate data or data on exclusion lists
  • Enrich with data from other sources
  • Add sequence numbers and file source information
  • Split large CSV files into smaller files based on field contents
  • Perform arithmetic calculations on individual fields
  • Validate CSV data against a collection of validation rules
  • Convert between CSV and fixed format, XML, SQL and DSV