A visual tool for easy data transformation. Designed for business users, without compromising on power.

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 usually end up having rather limited applicability due to a lack of features required for real-life tasks. 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.

Due to multiple optimizations and focus on usability EasyMorph combines simplicity similar to that of data preparation utilities without giving up on the power and flexibility typical for professional ETL tools. EasyMorph is targeted mostly at business users, although it has something to offer to veteran data experts as well.

data transformationFor business users

  • Visually transform data without using macros or scripting
  • Merge, filter, aggregate data from multiple sources — databases, spreadsheets, text and XML files
  • Prepara data for analysis (e.g. in Tableau)
  • Convert text files to spreadsheets, and vice versa
  • Create simple PDF reports

data transformationFor data experts

  • Complex ETL projects with tens and even hundreds of transformation steps
  • Ad hoc data profiling and analysis
  • Powerful non-relational transformations (e.g. Fill down, Pivot or Unpivot)
  • Built-in data visualization for better insights into the data and its quality
  • Mass operations on files, e.g. rule-based renaming, copying or deleting

Simplified 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 abstract approach to designing transformations in order to bring maximum clarity into calculations, and make authoring simpler:

  • Clean "arrowless" design — no need to connect transformations with arrows as in traditional ETL tools. Also grouping together transformations related to each table allows better organization of calculations.
  • Some frequently used transformations are created automatically when you manipulate data directly (i.e. using the right-click menu) in a manner typical for data preparation utilities.
  • The full result of every transformation step is stored in memory and is therefore instantly visible when you click a transformation. You always see what you get. On every transformation step.

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

animated demo


When you change parameters or properties of a transformation EasyMorph smartly recalculates only transformations that are affected by the change. It can do this because, remember, it stores full results of all transformation steps in memory. Therefore it can keep results of unaffected transformations, and recalculate only affected ones. Auto-calculation eliminates the need to re-run everything from the beginning again and again. Meanwhile you can even keep working with the project as the recalculation takes place in the background, and is triggered automatically.

Relaxed type system

EasyMorph doesn't force you to define data types explicitly for each column of every table, because in EasyMorph values of different types (e.g. numbers and text) can be mixed in the same column, just as in Excel.

Think about data types only when you have to export a table to a database, or to Tableau. Or don't bother at all as EasyMorph will autodetect data types for you when it becomes necessary.

Native support for Tableau and Qlik

EasyMorph natively supports data formats of popular data analysis applications such as Tableau and Qlik.

Tableau users can automatically generate Tableau Data Extracts and then publish them to Tableau Server (see example).

Qlik users can import and export QVD files, and replace load scripts with visual transformations in EasyMorph (see example).

Learn more about EasyMorph

See features