Ron's Editor Lite is a powerful tool for viewing, searching and editing CSV files.
You could use the program as a simple grid. Drag and drop a CSV file onto Editor, it's displayed in a spreadsheet-type view, and you can scroll through it, select files, lines or columns, sort the document by specific fields, copy selections to the clipboard, and more.
A filter system and powerful search tool (with regular expression support) helps you drill down to the data you need.
Basic editing works just as you'd expect. Click in a field and start typing as required, or right-click for options to edit rows, delete rows or columns, insert rows, columns and more.
There are assorted surprise extras, including some handy Cell Fill tools (fill all or selected cells with a sequence of numbers or other patterns).
Please note, the Lite version of Ron's Editor can only save a maximum number of 1,000 rows (there's no limit for viewing), and doesn't support several advanced tasks (removed empty/ duplicate rows, advanced sort, external editors, template support, various Replace/ Add/ Remove/ Other manipulation functions). The program still works just fine as a viewer, and paying $35 to upgrade to the Pro version will remove any restrictions (you can activate a trial of Pro from the Lite interface).
What's new in 2018.05.08.0855 (see the changelog for more)?
- Filter added to Go to Column window.
- Fixed width column positions can be saved and loaded on import.
- Empty column names now allowed.
- Search(s) can now ignore accented characters.
- More character encodings added to Export.
Ron's Editor Lite is an excellent CSV viewer, powerful and full of features, but the 1,000 row "Save" restriction means it can only edit relatively small files.