Ron's Editor is a powerful CSV file editor. It can open any format of separated text, including the standard comma and tab separated files (CSV and TSV), and allows total control over their content and structure.
This is the ultimate CSV editor, whether you need to simply edit a CSV file, clean some some data, or merge and convert to another format, this is the solution for you.
Simple or advanced editing for small or large files can be accomplished with equal elegant ease.
Ease of use has been considered at every stage, and the application has been designed to fully support standard windows editing - everything will be familiar to an Excel user.
Open or import any file format, filter rows and columns, and export to a new format. Edit, clean and convert the data in a number of ways.
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.
Change the type of columns in the document allowing correct sorting and filtering. For example changing a column to a date.
Split and merge. Both rows and columns can be split and merged, providing powerful re-structuring and de-duplication capabilities.
Standard editing functions. Include cut/copy/paste, search/replace, undo/redo.
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 capabilites. 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.
Remove duplicate and empty rows.
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.
Visual helpers. Single-click auto-width, auto-height rows, quick zoom.
See what the users of Ron's Editor think of the product.
Bravo! Ron's Editor is a real time and frustration saver. The Merge Column alone is worth the price of admission. A nice clean inter face makes for an exceptionally low learning curve. Well done!
[...] I'd be delighted to have you add my comments to the web site. Your product saved me hours of trial and error editing a large csv file.
Brian Henkel (E-mail - October 2012)
I do a lot of work with EXCEL but usually only use basic editing. I spend way too much time trying to keep Excel from reformating text or changing values I don't want changed.
I have been looking for a flat file editor that would edit Excel spreadsheets from .csv or .tsv files. I have been looking quite a while without much success.
So far Ron's Editor looks great. It formats and edits in a format that looks like Excel, but it doesn't try to do all sorts of unnatural things to the text I enter.
This seems to be a great editor at a reasonable price.
Robert Wilson (June 2012)
It's amazing!!! I love it... Thank you so much!!!
Anon (August 2012)
This is a really convenient tool, pretty fast and unique on the market : the DBA or software consultant swiss army knife when it comes to handling CSV files...
Anon (May 2012)