Rons Data Compare - Features

Clear Comparision

• Clear Layout: The two documents being compared are laid out, side by side, with vertical alignment locked in compare view.
• Clear Control: Collapsible 'Compare Settings' and 'Differences' panels make creating and navigating a compare session intuitive.
• Compare View/Preview: The compare view can be turned on and off for flexible editing workflow, and is presented in the same order as the underlying documents for clarity.
• Differences Highlighted: Differences between columns, rows and cells are shown in different colors depending on their nature.
• Differences Summarised: Differences between columns, rows and cells are summaries for an instant difference overview.

Powerful Comparision

• Five Compare Modes:
  • Match Key - Left and right
  • Match Key - Left only
  • Match Key - Lookup
  • Match full row
  • Match full/partial row
• Key Based Compare: Comparisons are done by matching selected key columns. The remaining columns can be optionally mapped for improved visual differences between rows, or left unmapped and synchronized if needed.
• Full Row Compare: Comparisons are done by matching mapped columns. Any unmapped columns will not be used in the comparision but can be used for synchronized if needed. A partial match mode will try and match rows that contain similar data.
• Easy Updates: Synchronisation updates are applied to Columns, Rows and Cells, either to the current selection or the whole document in one button click.
• Compare Overlay: The compare is a visual layer on top of the underlying documents, so no changes are made until required.
• Underlying Documents: The documents being compared exists independently of the comparison with full undo and redo maintained separately.

Loads any tabular text format

• Delimiter Auto-Detect: Automatically identify delimiters with configurable separators to match file extensions (CSV, TSV, etc.).
• Import Wizard with Preview: Import data from any separated format — including JSON, XML, HTML, Markdown, and tokenized files — from a file or the clipboard, with a preview option.
• Full Text Encoding Support: Handle multiple encodings (UTF-7, UTF-8, UTF-16, UTF-32) with automatic detection for accurate data representation.
• Automatic Line Break Detection: Detect and change line break formats automatically to ensure consistent formatting.

User-Friendly Interface

• Customizable Themes: Switch between light/dark modes and choose your theme colors.
• Tabbed Document Layout: Work with a multi-window, tabbed interface for easy document management.
• Integrated Location Panel: Browse and open files swiftly using the location panel.
• Command Search & Shortcut Configuration: Search for commands and execute them quickly — with fully customizable keyboard shortcuts.
• Logical Side & Activity Panels: Stay focused with well-organized panels displaying your actions and system activity.
• Font Customization & Zoom: Choose any font for editing and adjust zoom levels for comfortable viewing.

Essential Data Editing Tools

• Inline Cell Editing: Edit data directly within cells quickly and intuitively.
• Enhanced Edit Panel: For long or multiline entries, use a dedicated edit panel that supports all standard cut/copy/paste operations — including rows and columns.
• Search & Replace: Find and update data seamlessly across your document.
• Undo/Redo Functionality: Easily revert or reapply changes as needed.

Enhanced Document Handling

• File Lock: Secure your documents to prevent unwanted changes.