Csv Editor

  1. Csv Editor Pro
  2. Best Csv Editor
  3. Csv Editor Windows

CSV file is a very common file format that stores numbers and text ( tabular data ) in text form and all fields are separated with a specific character. Although this format ( .csv ) is widely used you do not have too many options when you have to choose a freeware CSV editor. We found four such applications that enable you to edit CSV files and all are free.

Although this format ( .csv ) is widely used you do not have too many options when you have to choose for a freeware CSV editor. We found four such applications that enable you to edit CSV files and and free.

CSVed is by far the most versatile of the four. Using it, you can work with very large files that store data separated with any separator. You can run multiple operations like: changing separator, split or join columns, search and replace, remove duplicates, add or delete columns, rearrange columns.

Here you can check a few application screenshots:

You can get the installer from here ( csvedsetup.exe – 1.9MB )

Let’s go to our next solution called iMatrixitor. This is a flexible solution that can open CSV files and edit them. it includes a lot of features like the ability to modify files on a remote server, via FTP connection, but also on local HDD. On save it automatically refresh the files both on local disk and FTP server.

Here are some screenshots:

CsvEditSharp is a CSV editor that describes read / write settings with C # script. In the script, write read / write settings using API of 'CsvHelper' which is a open source.Net class library. CSVpad is a handy free CSV (Comma-separated values) editor. It support’s unicode and it is a portable application. CSVpad can manipulate columns and rows. Export CSV files into html / xml / OpenDocument Spreadsheet (ods) and Microsoft Excel 8.0 (xls) files. Edit your CSV files online. No account neccessary! Edit CSV online is a 100% free web app powered by DataGridXL, the no-nonsense fast Excel-like Vanilla Javascript data table library.

Csv

You can get the installer from here ( installation file of ~ 4.1MB )

Out third choice is going to be a CSV editor written in Java and called, how else, Java csveditor :). It does some basic operations like pack rows, pack columns, row insertion before and after, column insertion before and after, delimiters selection. You can also customize the font you want to use.

Here you can view some screenshots:

It can be downloaded from here ( the kit has about 1.4MB )

The last solution is CSVForm – a simple CSV editor written in Java that does not need to be installed. Check the attached screenshot:

You can download it from here ( file size 21KB ).

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

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

Csv

Rons CSV Editor is the ultimate 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.

Bravo! Ron's Editor is a real time and frustration saver. The Merge Column alone is worth the price of admission. A nice clean inter face makes for an exceptionally low learning curve. Well done!

I'd...

Brian Henkel

Excellent product. I have always used Excel to edit CSV files and cursed every time at its multiple confirmation dialogs. At home, I do not have excel and have installed Ron's Editor - wish I'd done this years ago!

Martin Lindley - Scottsdale Construction

I just want to say thank you. I bought your editor about a year ago. I use your editor all the time to do quick data wrangling on CSV files. It does not mess up the data like Excel does in trying to be too smart and convert data types into other types. Thank you and keep up the good work.

Raymond Wong - Qualbe Marketing Group

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

Csv editor app
Loads any tabular text format
Separators can be configured, to align with file extensions. For individual custom formats the Import Wizard can be used to open any separated or fixed width format from a file or the clipboard.
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. Line break format automatically detected and changeable.
Flexible export capabilities
Export to text (separated or fixed width), HTML, XML, and Excel directly.
Edit the structure of a document
Simply cut, copy and paste columns, or for more control, edit the column layout allowing all details to be changed.
Standard editing functions
Include cut/copy/paste (including rows and columns), search/replace, undo/redo.
Change the type
Columns can be given data types to allow correct sorting and filtering. For example changing a column to a type of date.
Enhanced Editing functions
The Edit Panel can easily be activated for cells containing tabs or line breaks, or multi-cell updates. The Page per Row window can be used to edit data layout in a form.
Power Editing functions

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

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

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.

Split and merge
Both rows and columns can be split and merged, providing powerful re-structuring and de-duplication capabilities.
Remove duplicate and empty rows
The columns used to compare rows can be selected for total control.
Filter and Summarize
Quickly and easily filter, sort and summarize the data with quick filter access from a context menu on the table. Quick Find - one key-press to search the whole document.
Visual helpers
Single-click auto-width, auto-height rows, quick zoom.
Print support
Note:

Csv Editor Pro

Rons CSV Editor 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).

A FREE 30 day Pro Evaluation License is also available (download Rons CSV Editor first, and then select 'Try Pro Free').

What Now?

Best Csv Editor

Why not give it a try? The download is free and the installation simple.

Csv Editor Windows

  • Article
  • How To
  • Licenses