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) for CSV/text files
•text encoding (e.g. UTF-8) for CSV/text files
•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.
Check watch file if you want the file to be automatically reloaded every time that Easy Data Transform detects that it has been changed (which will then update everything 'downstream').
It will also trim any whitespace off the start or end of data values if trim white space is selected.
It can also read Excel .xlsx/.xls files, even if you don't have Excel installed.