Page Icon Rons Data Edit - Modern CSV Editor

Professional modern CSV file editor. The tabular text editor that combines power with ease of use.

Rons Data Edit, part of Rons Data Gear, is a powerful CSV file editor for Windows. 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 Data Edit is also ideal to simply view and read CSV, or any text delimited, files.

Rons Data Edit is a new Modern 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.

 

First of all, great app. Just discover it a few days ago and it's great, fast, and simple but at the same time powerful.

Carlos

More Testimonials >>

Red Pin Icon

Powerful

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

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.
Red Pin Icon

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

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 matched on key columns.
  • Full text encoding supported: 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
 
  • Tabbed Document Layout.
  • Location panel for easy browsing and opening of files.
  • Search and execute commands - configure their keyboard shortcuts.
  • Side and activity panels to maintain focus.
  • 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 used 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.
Note:

Rons Data Edit 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).

Get Rons Data Edit!

Free Download
Buy Now
$35.00

Already have one of our products?

Loyalty Discount

Our Products
Rons Data Edit Icon

Rons Data Edit - Modern CSV Editor

Learn more

Rons Data Stream Icon

Rons Data Stream - Batch CSV Processor

Learn more

Rons CSV Editor Icon

Rons CSV Editor

Learn more

Rons WebLynx Icon

Rons WebLynx - Desktop Bookmark Manager

Learn more

Rons Renamer Icon

Rons Renamer - Powerful Batch File Renamer

Learn more