Ron's Editor - Ultimate CSV Editor

Professional CSV File Editor to edit, view and read, sort and clean, and convert all your data in no time.

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.

With a clean and neat interface Ron's Editor is also ideal to simply view and read CSV, or any text delimited, files.

Ron's Editor is the ultimate CSV editor, whether you need to edit a CSV file, clean some data, or merge and convert to another format, this is the ideal solution for anyone who regularly works with CSV files.

Powerful

Simple or advanced editing for small or large files can be accomplished with equal elegant ease.

Easy

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.

Flexible

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.

Features

  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 capabilites. Its capabilites:

  • Replace
    • Text
    • Date/Time
    • Numbers
  • Add
    • Text
    • Random Text
    • Space
    • Date/Time
    • Numbers
  • Remove
    • Text
    • Space
    • Numbers
  • Other
    • Reverse Text
    • Change Case
    • Split Name

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.
  Visual helpers   Single-click auto-width, auto-height rows, quick zoom.
  Print support    
Note:

Ron's 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).

A FREE 30 day Pro Evaluation License is also available (download Ron's Editor first, and then select 'Try Pro Free').

Free Download!

GO

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...

Brian Henkel

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...

Robert Wilson

More Testimonials >>

Ron's Editor - Ultimate CSV Editor

Learn more

Ron's Renamer - Powerful Batch File Renamer

Learn more

Latest News

    Aaron Stewart

New Version of Ron's Editor

Now that the new web site is live I have been able to turn my attention fully back to product development. As a result, a few new versions of Ron's Editor (now at 2014.12.03.0808) have been released, and between them they contain many small requests from our valued customers. Some of the larger enhancements are still on the list, but it is good to clear the way for work on the new features.

Read >>