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.
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
Hey Ron - had a situation where I could use Data Graph instead of loading things into SQL and just wanted to thank you for seeing the need for this! So time saving for quick graphs.
Sanford Whiteman - FigureOne, Inc.
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 >>
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
- Add Text
- Add Random Text
- Pad Text
- Remove Text
- Reverse Text
-
Space
-
Numbers
- Add Numbers
- Remove Numbers
-
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.
|
What Now?
Why not give it a try? The download is free and the installation simple.
Related Articles
-
Licenses
-
Product
-
Rons Data Edit
-
Application
-
Cell
-
Column
-
Document
-
Row
Our Products
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