CSVPad is a compact, free and portable editor for CSV and similar files.
The program can handle all kinds of format variations: tab separated, colons, semicolons, pipes, dollars and more. Fortunately you don't have to worry about the details as by default CSVPad automatically detects and uses the correct format all on its own.
Your target file opens in a table, and you can immediately browse or search it, edit individual fields, extend the file with new records.
If the file structure isn't right then you can also reorder rows by dragging and dropping, insert new rows or columns, duplicate or swap them, copy and paste them, or just move your selected rows/ columns around to some new position.
There are one or two surprise bonus features: "Snapshot" saves a JPG of the table, "Search Online" opens a web page with the results of a Google search for the selected cell.
When you're done, the file can be saved in CSV or with the other supported separators (tab/ colon/ semi-colon etc), or exported as XLS, ODS, XML or HTML.
Verdict:
CSVPad is a convenient way to edit CSV and similar files, and can be very useful if you don't have a full-scale spreadsheet editor around.
Your Comments & Opinion
View, search and edit CSV files
View, search, edit and convert CSV files
A powerful but complex CSV editor
Create, view and edit Office documents on your Android device
View, sort, convert and generally process CSV files
A free office suite
Save paper and ink by customising documents before you print them
Boost your text editing productivity with this powerful Notepad replacement
Keep track of your appointments with this unobtrusive calendar tool
Keep track of your appointments with this unobtrusive Mac calendar tool
Create industry-standard PDF files from any Windows application.