|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:
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.
|Single-click auto-width, auto-height rows, quick zoom.