Page Icon Rons Data Stream - Batch CSV Processor

Rons Data Stream is a Windows application for automatically processing, cleaning and/or converting one or many data sources.

Rons Data Stream is a Windows application for automatically executing repetitive tasks on small or large data sources (for example CSV files). Batches of files or folders may be cleaned, organized, and converted in one run.

The application is designed around two concepts, "Cleaners" and "Jobs", which combine to create data processing power. "Cleaners" are sets of data editing operations, and "Jobs" bring it all together to define the data sources, the destination, and the Cleaner(s) to process the data.

Cleaners provide a wealth of editing options

  • Cleaners determines the set up of data editing operations that process data.
  • Column and row selectors provide re-usable flexibility (see Feature list).
  • Column, row and cell operations are combined into simple or complex data operations (see Feature list).
  • One or more Cleaners can be created, named, saved, and shared between multiple Jobs as often as needed.

Set up the Jobs to process 100's of (large) data files in seconds

  • A Job determines the data sources, their formats, and the destination of the output files.
  • One or more cleaners can be added to any Job and shared between Jobs.
  • Jobs can be created, named, and saved. They can load data from multiple available sources and have Full control over text format.

A great conversion tool

Rons Data Stream outputs different files formats like CSV, SQLite, HTML, XML, JSON. Rons Data Stream can write data to SQL Server.

Preview Screen for clear editing

The Preview Window makes the comparison of the original data with the processed data very clear. Essential for building and checking Cleaners.


"Thank you very much for this (it works), sometimes I forget how powerful Data Stream is."

Vashisht Bihariesingh - BCons

More Testimonials >>


General Features

Green Tick Icon   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.
Green Tick Icon   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.
Green Tick Icon   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.
Green Tick Icon   Loads data from multiple available sources
  See Source and Destination Information below.
Green Tick Icon   Outputs to multiple formats
  Source and destination formats can be configured for simple file conversion. See Source and Destination Information below.
Green Tick Icon   Quick Job
  An alternative window for quickly setting up a cleaning Job. The Quick Job can even be saved as a full Job.
Green Tick Icon   Clean Layout
  The Data Stream window is clean and easy to use.
Light/dark mode, and theme colors available.
Green Tick Icon   Preview Screen
  Essential for building cleaning tasks. Clear comparison of the original data with the processed one.
Green Tick Icon   Log files Output
  Essential for finding errors on large files.
Green Tick Icon   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 Stream are shown in the table below.

  • Column Processors
    • Add Column(s)
    • Update Column
    • Copy Columns
    • Move Columns
    • Delete Columns
    • Merge Columns
    • Split Columns
  • Row Processor
    • Add Row
    • Delete Row
    • Split 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 Stream 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
File Storage Files can be read directly from a local disk or Azure Blob storage. Files can be written directly to a local disk or Azure Blob storage.
Note: Azure Blob Storage does not support random access so some output formats cannot be used with it.
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.
Text Template N/A Generate any textual representation of the source data. For example turn a CSV file into an SQL Insert statement.
Note: Not supported in Azure Blob Storage.
SQL Server Available Source mapped to existing table or created if missing.
SQLite If requested. Available.
Note: Not supported in Azure Blob Storage.
HTML Table source available. Table output available.
XML Available. Available.
JSON Available. Available.

Spring Promotion Extra Discount Rons WebLynx

20% off

All Coupons (1)

Get Rons Data Stream!

Free Download
Buy Now
$35.00

Our Products
Rons Data Edit Icon

Rons Data Edit - Professional CSV Editor

Learn more

Rons Data Stream Icon

Rons Data Stream - Batch CSV Processor

Learn more

Rons WebLynx Icon

Rons WebLynx - Desktop Bookmark Manager

Learn more

Rons CSV Editor Icon

Rons CSV Editor - now Rons Data Edit

Learn more

Rons Renamer Icon

Rons Renamer - Powerful Batch File Renamer

Learn more