Rons Data Edit - Modern CSV Editor

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

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

What are the Differences between Rons CSV Editor and Rons Data Edit?

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.

 

I’ve been using data edit for a while and it’s a massive improvement over Rons CSV Editor.

Daniel

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
 
  • Delimiter Auto Detect. Separators can be configured, to align with file extensions.
  • Import Wizard with preview for any separated format from a file or the clipboard.
  • Full text encoding supported: Utf-7, Utf-8, Utf-16 and Utf-32, with automatic detection.
  • Line break format automatically detected and changeable.
  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.
  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.
  Summarize Data
 
  • Summary view for quick data analysis.
  • Graph Panel to visualize data with line charts, bar charts and pie graphs.
  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.
  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.
  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.
  Power Editing - Data Cleaners
  Combine lists of Toolbox commands into Data Stream Cleaners (macros) to save hours and hours of work.
  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).

Related Articles

Get Rons Data Edit!

Free Download
 Buy Now
$32.50

Rons Data Gear Rons Data Edit
Screen Shots Information & FAQ
Rons Data Stream
Screen Shots Information & FAQ
Version History
Future Plans
Information & FAQ

Already have one of our products?

Loyalty Discount

Our Products

Rons Data Edit - Modern CSV Editor

Learn more

Rons Data Stream - Batch CSV Processor

Learn more

Rons CSV Editor - Professional CSV Editor

Learn more

Rons WebLynx - Desktop Bookmark Manager

Learn more

Rons HTML Cleaner - Batch HTML Processor

Learn more

Rons Renamer - Powerful Batch File Renamer

Learn more