Rons Data Cleanser - Powerful Data Processing

Professional Data Cleanser to automatically clean, organise and convert multiple data files. A tremendous time saver.

Rons Data Cleanser is a powerful tool for automatically cleaning, converting and processing one or many data sources.

Three Simple Steps

  • Create a Cleaner
  • Create a Job
  • Combine them and run

Or for smaller jobs simply use "Quick Job" for single files or folders.


With the batch processing capability, 100's of data files can be processed in seconds. Multiple files, folders and directories process at the same time.


The Preview shows the original file with the processed one and displays the cleaning rules that perform the changes.

The Data Cleanser is designed to update and clean a data source (for example CSV files) through the use of Cleaners, replacing hours of manual editing.

Cleaners are made up of a list of operations that can be build, saved and applied to a data source as required.

The preview window makes the comparison of the original data with the processed data very clear.

With the batch processing capability, 100's of data files can be processed in seconds, making cleaning a whole directory an easy task!

Create operating rules (the Cleaner), define the source, format and output (the Job), combine and RUN . . . Job done.

General Features

  Jobs: set up of data sources, formats and destinations
  Jobs files can be stored with the data (if the data is in a directory), or separately if needed, and run at the click of a button or from the command line.
  Cleaners: set up of cleaning rules to process data
  One or more Cleaners can be created, named, saved and re-used with multiple Jobs as often as needed.
  Rules: the list of operations to perform on the data
  Numerous column, row and cell operations are combined easily within the cleaner. See List of Rules below.
  Loads data from multiple available sources
  See Source and Destination Information below.
  Outputs to multiple formats
  Source and destination formats can be configured for simple file conversion. See Source and Destination Information below.
  Quick Job
  An alternative window for quickly setting up a cleaning Job. The Quick Job can even be saved as a full Job.
  Preview Screen
  Essential for building cleaning tasks. Clear comparison of the original data with the processed one.
  Log files Output
  Essential for finding errors on large files.
  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.

List of Cleaning rules

The (growing) list of available data operations in Rons Data Cleanser are shown in the table below.

  • Column Processors
    • Update Column(s)
    • Copy Columns
    • Move Columns
    • Delete Columns
    • Merge Columns
    • Split Columns
  • Row Processor
    • Add Row
    • Delete Row
  • Cell Processors
    • Add Text
    • Add Random Text
    • Pad Text
    • Remove Text
    • Replace Text
    • Reverse Text
    • Add Space
    • Remove Space
    • Add Numbers
    • Remove Numbers
    • Replace Numbers
    • Add Date Time
    • Replace Date Time
    • Change Case
    • Split Name
    • HTML Encode
    • HTML Extract
    • Fill Lookup
    • Lookup Replace

Sources and Destinations

Rons Data Cleanser started life as the automation arm of Rons CSV Editor, and as such currently supports text based data formats. It soon became clear that our customers needed support for more data formats, the status of which is indicated in the table below.

Description Source Target
CSV File Separators configured per file (wild card match). Separators configurable.
Token File Tokens (more than one character) configured per file (wild card match). Tokens configurable.
SQL Server If requested. Source mapped to existing table or created if missing.
SQLite If requested. Available.
Parquet If requested. Available.
HTML Table source available. Table output available.
XML Available. Available.
JSON Available. Available.

Get Rons Data Cleanser!

Free Download

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

Merry Christmas, Happy Holidays and Happy New Year 2020!

    Aaron and Sylvie Stewart

Merry Christmas, Happy Holidays and Happy New Year 2020!

Getting ready for the holidays is often, for many, a very busy time but, hopefully, you will all be set to enjoy some relaxing time during the Christmas days.  Whether you are on your own or with your family, whether you’re planning to use the free time to be active or to chill out watching movies, we hope you will enjoy this precious time and make the most of it.

For us, the end of December is family time, so important to us. We are looking forward to it.

Now, the New Year is also approaching very quickly. We wish you all an excellent New Year 2020, in both your private and professional life.

Have a wonderful Christmas time everybody and Happy New Year!

"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

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