EasyMorph is a lightweight data transformation tool. Optimized for business users. A free edition available.

The task of data transformation is traditionally believed to belong to IT developers while business users are typically left with Excel, or cumbersome Visual Basic and Python scripting. Although there have been attempts to create easy-to-use so called data preparation utilities, such utilities are suitable only for very simple cases. At the same time enterprise Extract-Transform-Load (ETL) systems while powerful (and very expensive) are prohibitively difficult for non-IT audience, as they simply are not designed for it.

EasyMorph employs a novel approach that combines simplicity similar to that of data preparation utilities, and the power typical for professional ETL systems. It allows business users to design rather complex data transformations without using SQL or scripts, while data experts enjoy simpler and faster ETL development.

data transformationFor business users

  • Transform data visually instead of writing VBA macros, Python scripts or SQL.
  • Merge, filter, aggregate data from databases, spreadsheets, and files.
  • Prepare data for visualization (e.g. in Tableau) or online reporting.
  • Convert text files to spreadsheets, and vice versa.
  • Create simple PDF reports.

data transformationFor data experts

  • Medium-volume ETL capable of particularly complex transformation logic.
  • Fast ETL prototyping and data quality assessment.
  • Quick one-off data manipulations.
  • Powerful non-relational transformations (e.g. Pivot/Unpivot, Fill down, Shift column).
  • Extracting data from loosely structured spreadsheets.

More visual, simpler design of calculations

Data transformation isn't an easy task. One of its main challenges is having a clear understanding of the transformation logic because it's highly prone to human errors. We walked away from the traditional approach to designing transformations in order to bring more clarity into calculations, and make authoring simpler:

  • The full result of every transformation step is stored in memory and is therefore instantly visible when you click a transformation. You can easily trace back to the point where a calculation went wrong.
  • You can manipulate data in a manner typical for data preparation utilities (e.g. pick commands from a context menu). In this case EasyMoprh creates necessary transformations for you, on the fly.
  • EasyMorph automatically re-calculates dependent transformation steps in the background, instantly after a transformation was added or edited. You can immediately see how a change affects the final result.

Here is what it looks like (looped 2-minute animation):

animated demo

Integration with Tableau and Qlik

EasyMorph can integrate with many data visualization tools by exporting data into files and databases. It integrates particularly well with Tableau and Qlik.

With the help of EasyMorph Tableau users can perform complex transformations, automatically generate and publish Tableau Data Extracts.

QlikView and Qlik Sense users can import and export QVD files, and replace entire load scripts with visual transformations in EasyMorph with just 2 lines of script.


Example: US Census 2012
Example: Inc5000
Database Query Editor

See what's under the hood.

Technical features