Text To Excel Conversion With 'TXL Wizard'

We've got 3 easy methods to convert Text to Excel

The format of your text file determines which method to use. Find out below which conversion method is best for your text file...

Fast Software

'TXL Wizard' is fast, easy and accurate. Convert simple to complex text files to csv or Excel. Remove the potential for human error! 

'Text to Excel' — BATCH — 80x25
C:\>Use the command line!

C:\>TXT To XLS Converter.bat
-------------SUCCESS!!!

C:\>TXL.EXE /I"C:\In.TXT" /O"C:\Excel.XLS"
-------------SUCCESS!!!

C:\>MyConversionJob.TXL"
-------------SUCCESS!!!

Powerful Command Line

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!

Easy to use
File Conversion Features

Process huge number of files with similar table structures (but with different data/number of rows). 

Convert TXT to Excel with 'TXL Wizard'

'Text to Excel Wizard' Features


If you need to convert TXT to Excel (XLS, XLSX or CSV), this application comes with the features you'll need:

General

Conversion Tool Extras
  • Powerful, fast, recipe driven, and very easy to use. Process huge number of files with similar table structures (but with different data).
  • Eliminates the possibility of human error when moving data from text to Excel/CSV.
  • Command line has been made so simple anyone can use it with no training at all. Automate 'Text to Excel Wizard' using the command line. Run in batches. Optionally use Windows Scheduler for complete hands free conversion jobs.
  • Automatically reads text reports, and creates CSV or Microsoft Excel spreadsheets files.
  • Three methods to handle all text to Excel file conversions (Profile, Recipe and File Marking).
  • Do one or thousands of files and folders.
  • Compatible with future changes in input text file format with minor changes.
  • Generating a new report with different data is a single click process.
  • New Recipe/Profile creation/editing typically takes a few seconds to a few minutes depending on complexity.
  • Installed with numerous examples for training purposes.

Special Promotion: Buy 'Text to Excel Wizard' and get 'Convert XLS' free!

Need to Convert Text to Excel?

'Text to Excel Wizard' in a Few Words

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!


Text Conversions by Command Line

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:

  • TXL 'Conversion Job' files which are saved from the user interface File menu.
  • BAT files created by you using the command line specification in the help file.
  • Windows built in scheduler.
  • Third party apps that have command line interfaces.

Choosing a Method for Converting Input Text Files

 

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).

Method Input File Format Benefits/Features How to implement method using Text to Excel Wizard
Profile 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 conversion!

Extremely fast.

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 column.

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.
Recipe 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.
File Marking
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.

Fixed Width Profile Editor


TXT to Excel Conversion - Profile Editor image

Recipe Editor


convert txt to Excel Recipe Editor image


convert text to Excel  command line simple

What is the command line?

There are two methods to using the command line with Text to Excel Wizard:

  • Specifying a Conversion Job (TXL file)
  • Specifying a traditional command line

Specifying a Conversion Job File

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\


Specifying a Traditional Command Line

convert text to Excel command line traditional

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.

Our Customers


CSV Converter customer

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

CSV Conversion customer

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"  

3

Simple methods to convert your Text files to CSV Files. Profile, Recipe and Mark-up.

54

Non-profit organizations assisted. Are you a member of one? Let us know, we would like to help.

110

Customers in 110 countries. 1 in 3 Fortune 500 companies use our software.
'Text to Excel Wizard' is compatible with Office 97 through Office 2019. Yes, we've been at it that long!

Latest Changes to 'TXL Wizard'

8.10 (1/3/2023)

  • Command line: Faster command line. Program GUI settings are no longer being saved needlessly at very end of job.

8.00 (1/3/2023)

  • Office 2022 compatibility completed. Note: Office 2022 was released at the same time as Windows 11.