Page Icon Rons Data Edit - Professional CSV Editor

Professional CSV file editor for Windows. A modern tabular text editor that combines elegance, power and ease of use.

Rons Data Edit is a powerful new modern CSV file editor for Windows. It can open any format of separated text (CSV, TSV etc.), and allows total control over their content and structure. Built from ground up to present both application control and data clearly, it provides the ideal data editing environment.

Whatever your needs, this is the perfect application for anyone who works with tabular text files.

Rons Data Edit has not forgotten it is a text editor. While Excel is a state-of-the-art spreadsheet application, using it to edit CSV files can be problematic. Rons Data Edit will not try and 'help' with your data as Excel does, but instead provides a range of tools to work with the actual text data.

For anyone who regularly works with CSV files, Rons Data Edit will pay for itself in days . . . even sooner if you use the free version ;-).

Clear Control, Elegant Data

The application is presented in a clean manner, with quickly discoverable capabilities. Simple for first time customers, more advanced options open in logically ordered panels, and experimentation is safe with full undo/redo.

The data grid provides in cell editing and a clear layout that can be customized with features like auto sizing columns, column/row freeze and multi-line cells. Columns can be hidden and moved, and layouts saved for later use.

Page per Row presents rows in a form layout.

It's All About Text (opens anything)

Profiles are used to create sets of delimiters that can be associated with file extensions, and/or copy/paste formats so any format of separated text (e.g. CSV, TSV, PSV, TAB, etc.) can be edited.

Auto-detect can be enabled to automatically detect delimiters and combine with Profiles for smooth file opening.

Full text encoding supported, including Utf-7, Utf-8, Utf-16 and Utf-32, with automatic detection.

Discover the Power

Cells contents can be edited inline or in a separate editing panel for long/multiline cells.

Next to the standard editing options, panels can be opened containing the Toolbox, Columns Tools, Row Tools and Cell Tools. These contain features like split/merge rows and columns, remove duplicates/empty, and fill to name a few.

Wherever possible data can be used in its 'real' format, e.g. sorting/filtering by numerical value, and multi-national support is applied throughout.

Loads of Ways to get Data IN

Aside from being able to open any delimited text file, data can be imported from clipboard, file and the web in any separated format, JSON, XML, HTML and token.

Imported data can be appended or joined on one or more row keys.

Loads of Ways to get Data OUT

Of course data can also be exported to a file or the clipboard in any separated format, JSON, XML, HTML and token.

A file, view or all open documents can be exported to Excel directly.

Slice and Dice

Views can be created, and saved, from the main document that provide different insights:

  • Quick filter and Filter to find or group rows.
  • Duplicate Rows to find rows with matching values in one or more columns.
  • Construct where customers build a report based on their own criterion.

For customers who wish to view summaries of their data, a Data Summary is available for quick data analysis, as well as a Data Graph to visualize data with line charts, bar charts and pie graphs.

Automation

Sets of editing rules, called Cleaners (shared with Rons Data Stream - free Lite version available) can also be run in Rons Data Edit to execute multiple editing actions on a document in one go.

Cleaners are partly made from the same 'rules' that are used in the Toolbox, but also include row and column operations.


BTW, I love the tools. Simple and easy to use. I am a "data guy" and have used a ton of high-priced, complex solutions. I use Ron's Data Edit (and previously Rons CSV Editor) religiously. So "simple" yet so powerful. Please pass along my thanks to Aaron and team.

Tony

More Testimonials >>


General Features

Green Tick Icon   Loads any tabular text format
 
  • Delimiter Auto Detect. Separators can be configured, to align with file extensions.
  • Import Wizard with preview for any separated format, JSON, XML, HTML and token, from a file or the clipboard.
  • Export Wizard with preview for any separated format, JSON, XML, HTML and token to a file or the clipboard.
  • Import Join with preview to add columns to a document matching rows on key columns.
  • Full text encoding supported, including Utf-7, Utf-8, Utf-16 and Utf-32, with automatic detection.
  • Line break format automatically detected and changeable.
Green Tick Icon   Clear Layout and Presentation
 
  • Light/dark mode, and theme colors.
  • Tabbed Document Layout, with multi-window control.
  • Location panel for easy browsing and opening of files.
  • Search and execute commands - configure their keyboard shortcuts.
  • logical side and activity panels to maintain focus.
  • Choose any font for editing.
  • Zoom.
Green Tick Icon   Full Control over Data View
 
  • Sort rows and columns.
  • Freeze rows and columns.
  • Hide or re-order columns.
  • Auto detected column types, and use directly in sort, filter etc.
  • Duplicate row view.
  • Quick filter and full power filter views.
  • Construct/custom views - useful for bookmarks, or combining views and filters.
Green Tick Icon   Summarize Data
 
  • Summary view for quick data analysis.
  • Graph Panel to visualize data with line charts, bar charts and pie graphs.
Green Tick Icon   Standard Editing
 
  • Inline cell editing.
  • Edit panel for long/multiline cells.
  • Include cut/copy/paste (including rows and columns).
  • Search/replace.
  • Undo/redo.
  • "Make Row Header"/"Make Header Row" to change the Header.
Green Tick Icon   Enhanced Editing functions
 
  • Edit Panel for cells containing tabs or line breaks, or multi-cell updates.
  • Page per Row to edit one or more rows in a form layout.
  • Split and merge rows and columns, providing powerful re-structuring and de-duplication capabilities.
  • Remove duplicate and empty rows.
  • Remove empty columns.
  • Cell fill and block operations.
Green Tick Icon   Power Editing - Toolbox
 

The Toolbox is the ultimate cleaning and conversion tool, with live preview and search capabilities. Its capabilities:

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

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.

Green Tick Icon   Power Editing - Data Cleaners
  Combine lists of Toolbox commands into Data Stream Cleaners (macros) to save hours and hours of work.
Green Tick Icon   Document Features
 
  • File Lock.
  • Import data by appending rows to the document, or matching rows by data values (keys) and adding the columns to the document.
  • Export to Excel directly.

Get Rons Data Edit!

Free Download
Buy Now
$40.00

Already have one of our products?

Loyalty Discount

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