Rons CSV Editor is our well established, venerable, CSV file editor, used around the world by thousands of customers. Over the years feedback and suggestions from our loyal customers has helped created the ultimate CSV editor. However as technology moved on there was no choice but to move on with it, and so our new modern CSV editor, Rons Data Edit, was created.
Rons CSV Editor remains a powerful CSV file editor, with a clean interface, but we would recommend Rons Data Edit now as the best modern CSV editor.
Gene Steinbacher - Preferred Physicians Medical
Best CSV Editor around! I have tried numerous CSV Editors and they all fall short, until I came across your editor. I have been using it for several months now and I have yet to come across something I have wanted to do that this does not do for me. I love it! Thanks for all your hard work in creating a complete tool.
|Loads any tabular text format|
|Separators can be configured, to align with file extensions. For individual custom formats the Import Wizard can be used to open any separated or fixed width format from a file or the clipboard.|
|Full control over text format|
|Full text encoding supported: Utf-7, Utf-8, Utf-16 and Utf-32 (both big endian and little endian), with automatic detection. Line break format automatically detected and changeable.|
|Flexible export capabilities|
|Export to text (separated or fixed width), HTML, XML, and Excel directly.|
|Edit the structure of a document|
|Simply cut, copy and paste columns, or for more control, edit the column layout allowing all details to be changed.|
|Standard editing functions|
|Include cut/copy/paste (including rows and columns), search/replace, undo/redo.|
|Change the type|
|Columns can be given data types to allow correct sorting and filtering. For example changing a column to a type of date.|
|Enhanced Editing functions|
|The Edit Panel can easily be activated for cells containing tabs or line breaks, or multi-cell updates. The Page per Row window can be used to edit data layout in a form.|
|Power Editing functions|
The Toolbox is the ultimate cleaning and conversion tool, with live preview and search capabilities. Its capabilities:
For example not only can a date be converted from one format to another, all dates in a document can be easily located. Perfect for cleaning data and improving data quality.
|Split and merge|
|Both rows and columns can be split and merged, providing powerful re-structuring and de-duplication capabilities.|
|Remove duplicate and empty rows|
|The columns used to compare rows can be selected for total control.|
|Filter and Summarize|
|Quickly and easily filter, sort and summarize the data with quick filter access from a context menu on the table. Quick Find - one key-press to search the whole document.|
|Single-click auto-width, auto-height rows, quick zoom.|
Rons CSV Editor is free to download, but it contains some restrictions in its Lite version that can only be unlocked with a Pro license key (see Differences between Lite and Pro version).