Text To CSV Conversion With 'TXL Wizard'

We've got 3 easy methods to convert TXT to CSV

The format of your text file determines which method to use. Below, find out which conversion method is best for your text file...

Try it for free!

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 CSV' — BATCH — 80x25
C:\>Use the command line!

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

C:\>TXL.EXE /I"C:\In.TXT" /O"D:\Out.CSV"
-------------SUCCESS!!!

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

Powerful Command Line

We've made it so simple anyone can use TXL Wizard with the command line. Zero training required. Regardless, 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 CSV with 'TXL Wizard'

'TXL Wizard' Features

If you need to convert TXT to 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 CSV/Excel.
  • Command line has been made so simple anyone can use it with no training at all. Automate 'TXL Wizard' using the command line. Run in batches. Optionally use Windows Scheduler for complete hands free conversion jobs.
  • Automatically reads text reports and creates a CSV or Microsoft Excel spreadsheets files.
  • Three methods to handle most text file formats (Profile, Recipe and File Marking).
  • Do one or thousands of files and folders, set and forget.
  • Compatible with future changes in input 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 many examples for training purposes.

Special Promotion: Buy 'TXL Wizard' and get 'Convert XLS' free!

Need to Convert Text to CSV?

'TXL Wizard' in a Few Words

'TXL Wizard' is a simple to use, yet powerful tool specifically designed to convert text files to CSV (character/comma delimited) files and 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 Maui 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 csv 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 TXT 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 TXL 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 csv conversion!

Extremely fast.

You may choose the delimitation character within the CSV file. Normally a comma, you can alternatively create tab delimited, bar delimited text files. In fact you can pick any character you want.		 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 TXL 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. 		Excel not required for converting to CSV.

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.

If converting to CSV you may choose the delimitation character. 		Essentially, you will write a recipe, using the recipe editor. This recipe tells TXL 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 'TXL Wizard' the most comprehensive "Convert TXT to CSV" tool ever built.

Fixed Width Profile Editor


convert txt to csv profile editor image

Recipe Editor


convert txt to csv Recipe Editor image


convert text to csv command line simple

More info on using the command line to convert text to csv

What is the command line?

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

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

Specifying a Conversion Job File

The command line is extremely simple with TXL 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 TXL 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 way the conversion job is done.

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 csv command line

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 TXL 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

Great customer service, prompt attention to our requirements and lightening speed development has been my experience with the staff at Softinterface Inc. Within a few hours of installing...
Bruce King, IBM Canada, Toronto, Ontario



"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.
'TXL Wizard' is compatible with Office 97 through Office 2019. Yes, we've been at it that long!

Popular Conversions Text and Excel

Popular Conversions TXT and CSV

Popular Conversions by Command Line

Copyright © 1999-2024 by SoftInterface, Inc. All Rights Reserved.

Providing Software Interfaces to automate your business.