Rons CSV Editor - Ultimate CSV Editor

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

Rons CSV 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 Rons CSV Editor is also ideal to simply view and read CSV, or any text delimited, files.

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

I love your editor. We work with medical codes and some of them have leading zeroes which Excel recognizes as a number and therefore drops the leading zeroes when saving. Someone wrote a macro for Excel that pre-formats all cells as text before reading in the data but each Excel release tends to break the macro so we have to rework it. Finally I found a solution that treats CSV data as CSV data and that solution would be Ron’s CSV Editor. Many thanks!

Dave Wilbur, Medical Coding - Software Developer

More Testimonials >>

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

  • 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:

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

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

Related Articles

All Coupons (2)

Get Rons CSV Editor!

Free Download
 Buy Now
$40.00

Rons CSV Editor Screen Shots Download
Version History
Information & FAQ

Rons CSV Editor - Ultimate CSV Editor

Learn more

Rons Data Cleanser - Powerful Data Processing

Learn more

Rons WebLynx - Organize Your Internet

Learn more

Rons HTML Cleaner - Easy HTML Processing

Learn more

Rons Renamer - Powerful Batch File Renamer

Learn more

"Rons Data Cleaner" renamed to "Rons Data Cleanser"

    Sylvie Stewart

In September 2019 we decided to change the name of "Rons Data Cleaner" to "Rons Data Cleanser" in order to bring more clarity to the purpose of the application.

Even if there is fundamentally nothing wrong with the word "Cleaner", some other fine applications out there contain the word "Cleaner" in their name and by "cleaning" they imply that the data is "erased".

Rons Data Cleanser does much more: it edits and sorts data, modifies rows and columns through merging and splitting for example, and can also erase data. It basically does any alteration to a file that it is set up to do. We feel that the word "cleansing" will help prevent any misunderstanding.

We still have decided to keep the names of "Cleaners" for the sets of rules that can be saved within the application, because once downloaded and visualized, the purpose of Rons Data Cleanser should be clear to the user.

If you would like to react to this post, please use our

Gaining momentum: Rons WebLynx

    Aaron Stewart

Rons WebLynx has been available for download on our website for a while now, but was not really well known, except by a few early adopters. Well, the cat is out of the bag now! A few websites found our product, gave some good reviews, said some nice things about it, and suddenly we have lots of people using it.

Rons WebLynx is still in active development, and we have more plans for this product so, if anyone has some interest in it, now is the time to contribute to its future and give us some feedback.

Rons WebLynx is an application created to store and manage links. Organize your...

Currently in progress: Rons Data Cleaner

    Aaron Stewart

We would like to introduce a new product available for download on our website: Rons Data Cleaner.

Rons Data Cleaner is still in the early stage of development, but we have been vigorously testing and resolving issues and bugs, so at this point only minor anomalies are expected. We still have a solid list of features to add to Rons Data Cleaner in future releases, so if our customers are interested in shaping the application to their needs, now is the time to contribute and give us feedback.

The design of Rons Data Cleaner was derived directly from the various requests of

New Company and Products Names, New Look and New Blog sections

Welcome to our new Website!

Here is the latest company news:

Our company's name has changed: Ron's Place Apps is now Rons Place Software.

We took the opportunity to change it while going through the many administrative steps to move from The Netherlands to Canada.

Our product names have changed too. These changes have been made to remove a few issues the apostrophe was sometimes causing on the internet. 

  Ron's Editor is now Rons CSV Editor.

  Ron's Renamer is now Rons Renamer.

  Ron's HTML Cleaner is now Rons HTML Cleaner.

  Ron's WebLynx is now Rons WebLynx.

 

We've also freshened our website up a little and added a new blog section at the end of each page.

As for the latest Rons product, it's on its way with an imminent beta version coming out...!...