'TXL Wizard' is fast, easy and accurate. Convert simple to complex text files to csv or Excel. Remove the potential for human error!
We've made it so simple anyone can use TXL Wizard with the command line. Literally, zero training required. Nevertheless, we are always here to help you implement our software. Use the command line with the Windows scheduler and automate everything!
Process huge number of files with similar table structures (but with different data/number of rows).
If you need to convert TXT to Excel (XLS, XLSX or CSV), this application comes with the features you'll need:
Special Promotion: Buy 'Text to Excel Wizard' and get
'Convert XLS' free!
Text to Excel Wizard ('TXL Wizard' for short) is a simple to use, yet powerful tool specifically designed to convert text files to Excel files. If you need to convert one or thousands of files, located in one or many folders this is the tool! Conversions can be done 10-20 times faster without using MS Excel.
Save/restore all details of a conversion task by saving/opening a 'Conversion Job' file (*.txl) from the file menu. The same conversion job file can be used within the command line for quick automation. Combine this with the Windows Scheduler and you can take that vacation to Hawaii you've been dreaming of!
The command line is one of the most widely known, accepted and implemented methods for allowing one software app to initiate another app. That's why we've made it our goal to make all of our software command line able.
Automate text to Excel file conversions using:
The best method of conversion will depend on the input text file layout/type and
any features you find necessary. The table below will help you quickly choose. If
you are not sure which method would be best, send us an input file. The input file
need not contain proprietary data, dummy data is sufficient.
Email us at (Our response time will impress you).
|Input File Format
|How to implement method using Text to Excel Wizard
Fixed Width Text File
format. Usually a single table.
File type may be ASCII or UNICODE.
Supports both Windows/Unix style text files.
Excel not required for text to Excel
Text files with data beginning with zeroes (e.g."00214123") can be processed without losing the leading zeroes.
If you have the specification for your fixed width text file, using this method is
very simple. Use the built in Profile Editor to tell Text
to Excel Wizard the width of each
Additional properties may be specified for each column such as: Padding character to use, Alignment (which side to pad), Remove column from output, Reorder column in output.
1 to many tables of varying format can be within this file.
Typically a unique marker denotes the start and end of the table(s). Ending marker not required for the last table.
Text file can contain TAB characters.
Supports both Windows/Unix style text files.
Input text file can have multiple tables of varying format/size.
Output Excel files can optionally be pre-existing which will allow for the preservation of previously saved formatting information. That means you can transfer text file data directly into a pre-formatted Excel file.
Essentially, you will write a recipe, using the recipe editor. This recipe tells 'Text to Excel Wizard'
the position and format of each table you want to convert. The format for the recipe
is quite simple.
Once mastered this method is extremely powerful.
Same as Recipe.
Same as Recipe.
|This method requires that you modify the input file with special character sequences typed directly into the original document. This may be easiest choice if you only expect to process a given text file once.
The Profile and Recipe File method can be used to process similar text files and
requires specifying a profile/recipe only once. This profile/recipe can then be applied
to multiple documents.
If you anticipate having many files with similar layout, the Profile or Recipe method may be the appropriate choice. Keep in mind, similar layout does not mean each input text file must be exactly the same. The number of rows in a given table can be different for example, and the same profile/recipe will work. For the recipe method what must be similar between files are specific text strings that the program uses to denote the start and end of a table. For the profile method, the specific widths, padding, and alignment used for each input file must be identical.
Below we show a couple of snapshots of 'Text to Excel Wizard' the most comprehensive "Convert TXT to Excel" tool ever built.
There are two methods to using the command line with Text
to Excel Wizard:
The command line is extremely simple with 'Text to Excel Wizard'. In fact you need only to use the user interface to set up exactly what you would like done, go to the File menu and save a 'Conversion Job' file. A 'Conversion Job' file is saved with the *.TXL file extension. This file extension will be recognized by your operating system as a 'Text to Excel Wizard' file. So simply double clicking the ConversionJob.TXL file from Windows Explorer, or specifying it within the Windows Task Scheduler is really all you need to do. The TXL file is a simple text file that can be easily understood and modified within any text editor. See the TXL File Specification for modifying the conversion job properties.
Several example conversion job files are installed. You can run these from the command
line or simply double click on them from Windows Explorer. You can get to the
example files within Windows Explorer by going to this folder:
%appdata%\SoftInterface, Inc\TXL Wizard\
If you still find you need the control of a classical command line to convert text to csv, no worries, we've provided it. You can find example batch (*.bat) files for quick and easy usage by going to:
%appdata%\SoftInterface, Inc\TXL Wizard\Example1-Profile Method\Example1-Command-Line-Demo.BAT
%appdata%\SoftInterface, Inc\TXL Wizard\Example2-Recipe Method\Example2-Command-Line-Demo.BAT
%appdata%\SoftInterface, Inc\TXL Wizard\Example3-Recipe Method\Example3-Command-Line-Demo.BAT
%appdata%\SoftInterface, Inc\TXL Wizard\Example4-File Marking Method\Example4-Command-Line-Demo.BAT
These will work without modification provided you installed in the default folder.
For a full discussion and list of command line switches please refer to the Command Line Manual for 'Text To Excel Wizard'. Email us at if you have any questions or need additional examples. We will get you up and running fast! After all, converting text to csv files is what we do for a living.
TXL-Wizard: "We love this program. We use it to help with some conversions in Finance and it makes it so easy. It is a wonderful product. During the time were working out the kinks in what we were developing the software expired and your customer service was so accommodating and courteous in assisting us. I would highly recommend this product and your company by extension."
Stanacius Wallace, Four Seasons
"Thanks. The product is terrific. It did exactly what I needed it to do. I had 1321 text files I needed
to convert to Word. It did it in about 6 minutes."
Don Geiger Cullen and Dykman
Adobe Systems Inc. Chooses 'Convert Doc'. A custom site license has been signed by Adobe allowing them to install 'Convert Doc' on their servers. They will be using it specifically to do Doc to HTML conversions. "We look forward to using your product and potentially working together in the future", Bob Free, Adobe
Your products are very impressive, easy to use and script compatible, for what we desired in the management of MS Word and Excel
files. Thank you for your continue contact with me in regards to these tools. Mark Purinton EMC Corporation
"Your wonderful utility took a mere ten minutes to append all 22,000 files into one gigantic 2 gigabyte file. For comparison purposes, the program that wrote the files took approximately 30 hours to write out said 22,000 files. System: 1GHz Pentium/512 Meg RAM Laptop"
3Simple methods to convert your Text files to CSV Files. Profile, Recipe and Mark-up.
54Non-profit organizations assisted. Are you a member of one? Let us know, we would like to help.
110Customers in 110 countries. 1 in 3 Fortune 500 companies use our software.