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 2019.02.02.1056 (see the changelog for more)?
- File locks on load reduced.
- 'Text Remove' toolbox updated to include missing option.
- Wild card and regular expression added to filter.
- Regular expression added to Column and Row split.
- Document Summary significantly improved.
-Separator formats overhauled and streamlined.