Input data

<< Click to Display Table of Contents >>

Navigation:  Reference > Input >

Input data

You need to input data before you can transform it. Data can be input by:

dragging a file onto the Center pane; or

clicking the From File or From Clipboard button in the Left pane

 

Easy Data Transform can understand most types of table and list data. It will make an intelligent guess at the:

column delimiter (e.g. comma)

text encoding (e.g. UTF-8)

presence of a header row in the data

 

But you can also do this manually by selecting the input item and changing the Delimiter, Encoding and has header fields in the Right pane.

 

It will also trim any whitespace off the start or end of data values if trim white space is selected.

 

input-right-pane

 

It can also read Excel .xls/.xlsx files, if you have Excel installed.

 

If you are inputting a file, Easy Data Transform will monitor when the file changes and re-input it automatically and update anything 'downstream'.