 |
|
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, and tokenized files — from a file or the
clipboard, with a preview option.
-
Export Wizard with Preview: Export your data in any separated format,
JSON, XML, HTML, or tokenized output to a file or the clipboard, with a live
preview.
-
Import Join with Preview: Merge data by adding columns to a
document — matching rows on key columns — with an interactive preview.
-
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.
|
|
|
Dynamic Data Management |
| |
-
Sort Rows and Columns: Easily sort your data in both rows and columns.
-
Freeze Panes: Lock rows and columns to keep key information visible while
scrolling.
-
Column Management: Hide, reorder, and rearrange columns to tailor your
view.
-
Auto-Detected Column Types: Utilize automatically recognized column types
for precise sorting and filtering.
-
Duplicate Row Detection: Quickly identify and view duplicate rows.
-
Advanced Filtering: Use quick filters or comprehensive filtering views to
narrow down your data.
-
Custom Data Views: Create and save personalized views by combining filters
and layouts — ideal for different data analysis scenarios.
|
|
|
Quick Analysis & Visualization |
| |
-
Summary View: Get an instant overview of your data with summary metrics
for rapid analysis.
-
Graph Panel: Visualize trends and insights using generating charts (line,
bar, pie) for enhanced data interpretation.
|
|
|
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.
-
Header Management: Set or change header rows with simple commands like
"Make Row Header" for improved structure.
|
|
|
Advanced Data Structuring |
| |
-
Multi-Cell and Special Character Editing: Utilize an advanced edit panel
for cells containing tabs, line breaks, or for multi-cell updates.
-
Page per Row: Edit individual rows in a form-like layout for clarity and
precision.
-
Split and Merge: Restructure your data by splitting and merging rows and
columns as needed, offering powerful deduplication capabilities.
-
Remove Duplicates & Blanks: Eliminate duplicate, empty rows or columns
effortlessly.
-
Cell Fill & Block Operations: Perform batch operations on cells for
quick data entry and consistency.
|
|
|
Robust Cleaning and Conversion Tools |
| |
The Toolbox is your ultimate solution for data cleaning and conversion, featuring
live previews and powerful search capabilities. Its functions include:
-
Replace: (Text, Date/Time, Numbers)
-
Text Manipulation: Add Text, Add Random Text, Pad Text, Remove Text, Reverse
Text
-
Space Adjustment: Add Space, Remove Space
-
Number Operations: Add Numbers, Remove Numbers
-
Date/Time Operations: Add Date/Time
-
Other Conversions: Change Case, Split Name, HTML Encode, HTML Extract
Example: Easily convert dates from one format to another and find all
dates within a document to improve data quality and consistency.
|
|
|
Custom Data Cleaners |
| |
-
Macro Integration: Combine multiple Toolbox commands into Data Stream Cleaners
(macros) to automate repetitive cleaning tasks and save hours of work.
|
|
|
Enhanced Document Handling |
| |
-
File Lock: Secure your documents to prevent unwanted changes.
-
Append and Merge Imports: Import data by appending rows or matching rows by
key values and then adding columns accordingly.
-
Direct Excel Export: Export your data directly to Excel for further
manipulation and analysis.
|
