Easy Data Transform

Easy Data Transform is a tool designed for modifying and preparing data without the need for programming. It supports multiple formats such as CSV, Excel, and JSON. The graphical interface lets you perform complex operations using drag and drop.

★★★★★

5.0(1 ratings)

• Data import. Loads information from CSV, Excel, JSON, and other file formats. The tool automatically detects delimiters and encodings, ensuring accurate reading of the data. It can handle large volumes of data efficiently.
• Record filtering. Removes rows based on specific conditions. Criteria include numeric comparisons, text matches, and dates. Multiple filters can be applied in sequence for progressive refinement.
• Sorting. Organizes data in ascending or descending order based on one or more columns. Supports alphabetical, numeric, and chronological sorting. Preserves record integrity during the process.
• Table joins. Combines two datasets using common keys. Performs operations similar to SQL JOINs, including inner, outer, and cross joins. Keeps all columns or selects specific ones.
• Column splitting. Separates the contents of a column into multiple parts using delimiters or fixed positions. Useful for addresses, compound names, or concatenated values. Lets you define the maximum number of splits.
• Type conversion. Changes the format of data between text, number, date, and boolean. Automatically detects patterns for dates and decimal numbers. Includes options for handling conversion errors.
• Aggregation. Summarizes data using functions such as sum, average, minimum, and maximum. Groups results by one or more key columns. Produces basic pivot-style summaries without complex setup.
• Duplicate removal. Identifies and removes repeated records by comparing selected columns. Offers options to keep the first or last occurrence. Includes occurrence counts.
• Results export. Saves processed data in formats compatible with other applications. Lets you choose the character encoding and delimiters for CSV. Produces structured output ready to share.
• Workflow automation. Saves sequences of operations for later execution. Supports variable parameters for batch processing. Integrates transformations into existing workflows through the command line.
• Data validation. Checks consistency using customizable rules. Detects out-of-range values, incorrect formats, and empty required fields. Generates detailed reports of the errors found.
• Table transposition. Converts rows into columns and vice versa. Reorganizes data for vertical or horizontal analysis. Preserves relationships between elements during the axis rotation.

Easy Data Transform was developed by a small company specializing in productivity tools. The project began in 2016 as a solution for basic data manipulation needs. The initial version was written in C++ with Qt for cross-platform compatibility. The team maintains regular updates with new features and fixes.

Alternatives to Easy Data Transform: