CSV (comma-separated values) files are everywhere, though sometimes field are separated by tabs or spaces instead of comma. I see many people edit CSV files using spreadsheet software like Microsoft Excel. I edit CSV files using Emacs, so I do not have leave my programming environment.
Emacs can recognize CSV files if you installed the csv-mode: http://www.emacswiki.org/emacs-fr/download/csv-mode.el. Just download it and save it anywhere, and add the following line into your
Before you can edit your CSV file, make sure values were separated by comma. If they are not, the following simple command-line can help:
cat your_file | sed 's/\t/, /g' > your_file.csv
This command converts every tab in your_file into a comma and a space. The result file, your_file.csv, can be recognized by csv-mode now.
After opening your_file.csv using Emacs, you might want to use
M-x toggle-truncate-lines to disable the warping of long lines. Then, you can use
M-x csv-align-fields to align fields. This makes the file look like it is in Microsoft Excel.