When you need to convert multiple files in a single task, remember to include a wildcard character in the Input File(s) field. This can be an asterisk "*" or a question mark "?". For correct file specification, use the format:
"C:\INPUTPATH*.EXT".
Here, "EXT" stands for the file extension of your input files, like in "C:\Samples*.CSV".
Once the asterisk has been typed into the Input File(s) entry box two additional options will appear:
Option |
Purpose |
Save to Input Folder |
The output file path will be the same as the input file path. |
Do Subfolders |
Search and process all files found in the folder and subfolders specified in the Input File(s) entry box. |
NOTE: Both the Do Subfolders and the Save to Input Folder check boxes will only visible when the Input File(s) entry box has a wildcard character specified.
For example to convert from CSV to XLS of all the files within D:\MyXLSFiles\ and even the sub-folders you would enter the following for the Input File location:
D:\MyXLSFiles\*.CSV
Continuing with the above example, you could specify the Output File(s) to be:
D:\MyXLSFiles\*.XLS
When you specify multiple input files you must also specify multiple output files, again by using the wildcard character. By default, 'Convert XLS' does this for you automatically by filling in the Output Files(s) entry box.
NOTE: Please review wildcards for greater flexibility in specifying what files to process.
NOTE: You may specify Date/Time fields for the output folder making it easy to sort outputs by date or time.
See also:
Converting Whole Folders of Files
Conversion of Fixed Width Text Files