Clicking the Options button brings up a page offering three tabbed options.
1. General
If Show Excel Application while processing is checked, Excel will become briefly visible while TXL Wizard is processing
2. Input Text File
When working with tab delineated files, you can adjust the default stop size of the tab. Enter a number between 2 and 16 to specify tab size based on your system settings. Eight is the most common tab size.
If your columns are not copying to Excel correctly from a tab delineated text file, try adjusting tab size.
3. Output Excel File
When checked, output sheet data and formatting will be cleared before processing. If unchecked the contents will not be cleared before processing, and cells will be overwritten if the input and output files share cells in common. For example, if the output file has data in cells A1:F20 before processing, and the input file has data in cells A1:F6 then after processing the data in A1:F6 will be from the input sheet, with all data in cells A7:F20 remaining unaltered.
Note that this option is only applicable to Excel files. Output CSV files will always be cleared before processing.