Easy Data Transform v1.9.0
For Windows and Mac

This release adds bug fixes and improvements to v1.8.2. 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.

You can uninstall old releases after you have successfully installed this version.

Windows and Mac

1. Easy Data Transform now interprets files with extension .txt as fixed column width format files. In fixed width format, data is arranged in columns, but instead of those columns being delimited by a certain character (as they are in CSV) every column is a fixed length.

example fixed column width data

EDT will take an educated guess at the column widths if Columns is set to Automatic. But you can set the column widths manually if Columns is set to Manual.

fixed width automatic input

Setting Columns to Manual or clicking the adjacent ‘…’ button will display the Fixed Column Widths window.

set fixed columns widths

Change the column widths in the table. Select columns in the table or preview. Click Merge to merge 2 or more selected columns. Click Split to split a selected column into 2. For more details see the Windows or Mac documentation.

convert fixed width column data

2. When you import JSON or XML files you can now choose whether to import any arrays/repeat values as Long (more rows) or Wide (more columns).

wide or long input

For example this JSON data:

[
   {
      "name": "1",
      "values": [ "a", "b" ]
   },
   {
      "name": "2",
      "values": [ "c", "d" ]
   }
] 


Input as Long (more rows) is:

JSON input as long example

Input as Wide (more columns) is:

JSON input as wide example

3. If you are outputting to an Excel file you can choose to set Write mode to:

This means you can now write multiple sheets to the same Excel file, as long as you set all the outputs to Overwrite / Sheet.

write to multiple Excel sheets

4. From v1.8.2 Easy Data Transform warns you if you were trying to output a dataset too large for an Excel XLSX format file (1,048,576 rows x 16,384 columns). It now also warns you if you were trying to output a dataset too large for an Excel XLS format file (65,536 rows x 256 columns).

5. The Rename Cols and Split Rows transforms did not correctly encode non-latin characters in some option values. Which meant that non-latin characters would be incorrect when the .transform file was re-opened. This is now fixed. Thanks to Torgrim S. for reporting this.

6. Some transforms did not correctly decode the % character in some option values. Which meant the % character would be incorrect when the .transform file was re-opened. This is now fixed. Thanks to David C. for reporting this.

7. Other minor bug fixes.

Mac only

8. In macOS 10.15 (Catalina), saving a file over an existing file with the same name can cause a crash. This appears to be a macOS bug and we hope Apple will fix it soon. As a workaround you should either:

MacOS 10.14 and earlier are not affected.

Downloads

Windows Logo Windows Download

v1.9.0 for Windows 10 / 8 / 7 (49 MB)

Apple Logo Mac Download

v1.9.0 for Mac 10.15 to 10.12 (23 MB)

Questions or problems?

Email support@easydatatransform.com


Do you have a question?
We would love to help.

This pop-up will not be shown again