Quick start guide

<< Click to Display Table of Contents >>

Navigation:  Getting started >

Quick start guide

 

This is a quick tour of some of Easy Data Transform's features. It should only take a few minutes to complete.

 

Start Easy Data Transform. If the Free Trial window appears, click Continue free trial. If the Getting Started window appears, click I got this! (or you will just end up back on this page). You should now see the main window.

 

Easy Data Transform

 

Drag a data file you want to transform onto Easy Data Transform. For example a .csv file or an Excel .xlsx/.xls file. XML, JSON, fixed width and vCard formats are also supported.

 

transform csv file

 

Notice that the available transforms are shown in the Left pane and the selected dataset is shown in the Right pane.

 

In the Right pane, you can check has header, depending on whether you want to treat the first row of the dataset as a header.

 

extract header

 

All the transforms available for a single dataset are now enabled in the Left pane. Hover over the transforms to see tooltips explaining what they do. Click on the ? next to a transform button for more details.

 

Ensure the input item is selected and click on the Case transform button to change the case of your data.

 

transform case

 

A Case transform item will now be added.

 

covert case

 

In the Right pane, check one of the columns and set Change case to to Upper case. All the text in that column will now be converted to upper case. You don't have to click a 'run' button.

 

convert to upper case

 

You can create a sequence of transforms to perform complex manipulations.

 

data transform pipeline

 

Some transforms require more than one input dataset. For example, to stack two datasets, one on top of the other:

Select File>New to start again. Don't save the changes.

Drag two data files onto the Center pane.

Select both input items (by dragging a box around them or using Ctrl+click).

Click the Stack transform button (you may need to scroll the Left pane to see the button).

 

merge CSV files

 

The tables are now stacked one on top of the other in a new dataset item. You can choose to match the columns by Header name or Column number.

 

stack CSV files

 

Note that the vertical (Y) position of the inputs affects the order the datasets are stacked. Try swapping the two inputs around and re-select Stack to see the affect.

 

Any changes to input files will be automatically read in. Any changes to input datasets or transform options will be automatically propagated 'downstream'.

 

To export your transformed dataset to a file or the clipboard, view it in a local editor or see it with whitespace displayed, click on the appropriate button in the Right pane.

 

export CSV files

 

You can also add an output item to automatically write a dataset to file whenever it changes.

 

merge CSV files

 

You will be asked for a file to write to. You can choose amongst CSV, Excel, HTML, JSON, Markdown, TSV, vCard, XML and YAML file formats. Select CSV file.

 

output to CSV

 

Your dataset will then be written to this file every time it changes.

 

export CSV

 

You can also specify the Delimiter, Quoting, Encoding, Line endings etc for your CSV files in the Right pane.

 

CSV delimiter

 

You can save your transforms to a transform template document to use again with File>Save.

 

Have a play!

 

Tips:

You can also paste in data from the clipboard (for example, a table from a web page or Word document).

The Compare Cols, Filter, If and Sort transforms take account of dates, numbers and text. You can define what date formats to recognize in the Preferences window.

New columns are always added to the right of a dataset.

Comparisons of text are always sensitive to case, unless stated otherwise. E.g. "CASE", "case" and "Case" are treated differently.

Comparisons of text are always sensitive to whitespace (e.g. spaces and tabs), unless stated otherwise. You can use the Whitespace transform to remove leading and trailing whitespace.

The contents of input and output data files are not saved in Easy Data Transform, only their locations.

As well as stacking two datasets, you can also Join them, side-by-side, if they have a common ('key') column.

You can insert a new transform between existing items by selecting the connection between the items and then adding the transform.

To be more productive with Easy Data Transform see expert tips.

 

We are interested in your feedback, so please contact us to ask a question, report a bug or request an enhancement.