reCsvEditor

reCsvEditor is an open source, free and platform-independent software project that has been designed from the ground up to act as a standalone tool for editing simple CSV (Comma-separated values) files that contains only one record. It can also be used to view and update XML files.

Features at a glance

Key features include supports for very large CSV files (over 1GB in size), Unicode support, the ability to change field separator and quotes, four different views (Record View, Sorted Tree View, Column View and Filtered View), support for multiple file views, the ability to export files as XML, HTML, Fixed Width Text or via Velocity Template, which must be downloaded separately.

Additionally, the program supports tabs, HEX characters, semi colons, colons, commas, and many other characters that are used as field separators. It allows users to add, copy or move columns, set a fixed position for fields and hide them using the right-click context menu, as well as to easily switch between the Protocol Buffers Editor, Avro Editor and RecordEditor tools.

Its graphical user interface is easy-to-use and independent of a desktop environment or operating system, which means that it looks the same on all supported operating systems (see below section for details).

Under the hood and availability

The application is written entirely in the cross-platform Java programming language and uses Java Swing for its graphical user interface (GUI). It is available for download as a universal binary file in the JAR format, for Linux and Macintosh computers, as well as an installer for Windows PCs.

Supported operating systems

Being written in Java, the program is cross-platform, successfully tested on several GNU/Linux flavors, as well as on the Microsoft Windows and Mac OS X operating systems. It should work on any platform where the Java Runtime Environment is available. Both 64-bit and 32-bit architectures are supported at this time.

What is new in this release:

• New Xml compare and Xml directory compare.
• Fixes for Code-Generation and open using Schema.
• Can now define Csv Quotes in hex format (Single byte character-set).
• Byte level passers upgraded to handle Quotes.
• Field-Name options in the Code-Generate function

What is new in version 0.98.2:

• Options to set default Field Seperators and Csv Quote characters
• Can specify Fields Separators and quotes in unicode format (u00a5)
• Rewritten Fixed width option
• New "File Schema" option
• Support for editing simple Cobol Data files with a Cobol Copybook
• Option to Generate Python/Java code to read/write the file being edited

What is new in version 0.97:

• Fixes for Java 8 + linux/Open-Jdk.
• Updated Csv parser (Extended Basic is now the default Csv parser). The new standard Parser follows Csv standard more closely.
• Updated Main screen with:
• Options to list Drives (Windows) and Recent Directories
• Option to display hidden files (Right Click Menu)
• Updated File-Chooser screen with Recent directory options

What is new in version 0.96g:

• More Cell operations (Right click and Edit menus)
• Added Recent Directory option to File Menu
• Tips displayed on startup
• New JavaScript macros (Delete-Duplicates and Show Duplicates)
• New Jython / Groovy macros to save files as JSon. These require Jython / Groovy interpreter's to be downloaded separately from there Project sites
• New Delete-Duplicate / Sort Macro-Build functions
• Removed Java-7 dependencies that had crept in, Should run in Java 6 again.
• Improved major error reporting
• Fixed issue with spaces in filename (when used as a Startup parameter for ReCsvEditor)

What is new in version 0.96e:

• There have been changes to Key assignment. Ctrl-C and Ctrl-C are now cell copy / cell paste etc. Record-Copy, Record-Cut, Record-Paste, Record-Insert and Record-Delete. are now Alt-C, Alt-X, Alt-V, Alt-Insert and Alt-Delete.
• Can view / update GetText-PO and SwingX-Tip files
• New Highlighted Text view where fields are highlighted
• New Script Build function. Also there is a more detailed explanation here.
• Large number of improvements for Big files including
• Improvements in filtering, copying, pasting in Big files
• Improvements in loading large gzip files
• Improved memory management
• Cell selection is now supported (instead of record selection). Cell copy/paste is now availablee on the Ctrl-C or Ctrl-V.
• Can View/Update Get-Text PO files and SwingX Tip files.
• Major changes to Installers - Better Windows UAC handling, can install in Windows"User" account, Better handling of multiple user's on PC.
• Can specify Character-set on Csv and Fixed width export screens.
• New Csv compare function (Utilities >>>> Compare menu).
• Added file character-set detection for Ebcdic files
• Screen layout changes for new Wide screens.

What is new in version 0.95:

• improved support for Macro's (Scripting languages that suppport JSR223).
• 2 new Csv parsers
• New Text Editor View

What is new in version 0.90:

• Related screens are now displayed as tabs on the one screen (default). There is still the option to display each view in its own screen.
• Different views can be docked / undocked with each other as needed.
• List screens can now have a Record Screen where the current record is displayed.
• Support for foreign languages via GetText po files / resource bundles produced via GetText. There are sample language files generated using Google Translate.
• Filter - added And / Or operators, also added Starts With operator.
• Enhanced HTML Export.
• Option to Open Exported file.
• Highlight changed fields on Compare screen.
• Updated Find function.
• Minor Gui changes.

What is new in version 0.80.6:

• Changes include adding an XML Viewer/Updater and a Fixed Width wizard; a lot of minor GUI changes; and enhanced SaveAs and Export functions.
• You can also view fixed width Cobol files (needs an additional download).

What is new in version 0.69.2e:

• Support for Fields names being on lines other than the first line
• Improved file structure detection
• Support for default column Values (Edit >>>> Update CSV columns)
• Fixed problems in load File_Description

Requirements:

• Java 2 Standard Edition Runtime Environment