Easy Data Transform v1.2.0
For Windows and Mac

This release adds improvements to v1.1.0. The download links are at the bottom of the page.

We recommend that you back-up important transform files before installing any new release. Please let us know of any problems or issues you encounter with the release.

Windows and Mac

1. Much faster input of CSV files.

2. Improvements to CSV reading to better handle badly formed CSV files.

3. Faster output of CSV files.

4. The Gather transform has been added. Sometimes called ‘pivot longer’ or ‘group by’, this transform allows you to convert multiple columns in a key column and a value column. For example you can transform:

pivot long example

Into:

pivot long example

Using:

gather transform example

5. The Spread transform has been added. Sometimes called ‘pivot wider’ or ‘crosstab’, this transform allows you to convert a pair of columns into multiple columns. For example you can transform:

pivot wide example

Into:

pivot wide example

Using:

spread transform example

NB/ Spread is the opposite of Gather.

6. The Summary transform has been added. This transform creates a new dataset that is a summary of the values in the input dataset. For each selected column it reports:

Working out which values fit the allowed date formats (specified in the Preferences) can be slow for large datasets. You can turn this off by unchecking check for dates.

7. The Substitution transform has been added. This transform allows you to substitute one or more column values into text. For example you could use it to create SQL statements to insert the values into a database:

CSV to SQL example

8. You can now uncheck simplify whitespace in the Right pane for input items, if you want to preserve carriage returns and tabs while reading in CSV files. Otherwise they will be converted to spaces.

9. You can now uncheck ignore empty rows in the Right pane for input items, if you want to preserve empty rows while reading in CSV files.

10. You can now uncheck Byte Order Mark in the Right pane for output items, if you don’t want to write a BOM to UTF encoded output files.

11. Added an Export data button in the Right pane for input items.

12. When outputting XML, spaces in column header names are now replaced by ‘-‘ (dash) characters to ensure that the XML produced is valid. The comment has also been moved after the <?xml ..?> line to better conform to the XML specification.

Windows only

13. The user interface font size is now a better size on high resolution displays.

Downloads

Windows Logo Windows Download

v1.2.0 for Windows 10 / 8 / 7 (22 MB)

Apple Logo Mac Download

v1.2.0 for Mac 10.15 to 10.12 (21 MB)

Questions or problems?

Email support@easydatatransform.com