There's a tool, CSVfix, which helps with viewing CSV files.

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

• Convert fixed format, multi-line and DSV files to CSV
• 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
• Perform sed/perl style editing
• 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
• Summarise CSV data, calculating averages, modes, frequencies etc.

A simple way to view CSV files on the command-line is to pipe the .csv file into the column utility with the column delimiter set as a comma:

column -s, -t yourfile.csv

There's a tool, CSVfix, which helps with viewing CSV files.

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

• Convert fixed format, multi-line and DSV files to CSV
• 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
• Perform sed/perl style editing
• 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
• Summarise CSV data, calculating averages, modes, frequencies etc.

A simple way to view CSV files on the command-line is to pipe the .csv file into the column utility with the column delimiter set as a comma:

column -s, -t yourfile.csv

There's a tool, CSVfix, which helps with viewing CSV files.

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

• Convert fixed format, multi-line and DSV files to CSV
• 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
• Perform sed/perl style editing
• 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
• Summarise CSV data, calculating averages, modes, frequencies etc.

A simple way to view CSV files on the command-line is to pipe the .csv file into the column utility with the column delimiter set as a comma:

cat yourfile.csv | column -s, -t

There's a tool, CSVfix, which helps with viewing CSV files.

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

• Convert fixed format, multi-line and DSV files to CSV
• 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
• Perform sed/perl style editing
• 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
• Summarise CSV data, calculating averages, modes, frequencies etc.

A simple way to view CSV files on the command-line is to pipe the .csv file into the column utility with the column delimiter set as a comma:

column -s, -t yourfile.csv