<< Click to Display Table of Contents >> Navigation: Reference > Output > Output data |
Once you have finished transforming your data you can output it in the following formats:
•CSV
•JSON
•HTML
•TSV
•XML
•YAML
To create an output, select 1 input and/or transform item in the Center pane and then click the To File button at the bottom of the Left pane. You can choose the file type in the Save as type drop-down list of the Output window.
You can select the output item in the Center pane and change any options related to the output in the Right pane.
Set File to the location of the file you want to output. If you are writing to a .xls or .xlsx file the output will be written to a sheet called 'Easy Data Transform' by default. You can change this by adding the sheet name inside [], e.g. myfile.xlsx[mysheet].
Set Delimiter to the delimiter you wish to use (only available for delimited text files, such as CSV and TSV).
Set Encoding to the text encoding you wish to use (only available for text files).
Set Format as depending on how you want to set the Excel formatting of cells (only available for Excel files).
Set Byte Order Mark checked write a Unicode Byte Order Mark to the file (only available for UTF encodings).
Set Root name and Row name depending on the name you want to use for the root and row XML records (only available for XML files).
Use Write mode to determine how existing files are treated:
Write mode for Excel files |
File exists with named sheet |
File exists without named sheet |
File does not exist |
---|---|---|---|
Overwrite / File |
Overwrite named sheet, delete all other sheets |
Add named sheet, delete all other sheets |
Create file with only named sheet |
Overwrite / Sheet |
Overwrite named sheet |
Add named sheet |
Create file with only named sheet |
Append |
Append to named sheet |
Add named sheet |
Create file with only named sheet |
New |
Do nothing |
Do nothing |
Create file with only named sheet |
Disabled |
Do nothing |
Do nothing |
Do nothing |
Write mode for non-Excel files |
File exists |
File does not exist |
---|---|---|
Overwrite |
Overwrite file |
Create file |
Append |
Append to file |
Create file |
New |
Do nothing |
Create file |
Disabled |
Do nothing |
Do nothing |
Use Alias to identify the file for batch processing.
Use Comment to record any notes that might be useful to a colleague or your future self.