Convert Fixed Width Text Files to CSV Easily with 'Convert XLS' from Softinterface


Customers
 

convert fixed width text files to csv software, adobe customer

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

convert fixed width text files to csv IBM 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


Click for the BBB Business Review of this Computers Hardware, Software & Services in Santa Monica CA

no viruses


You need to convert from

Fixed Width Text File to XLS

Fixed Width Text File to XLSX

Fixed Width Text File to CSV

Fixed Width Text File to HTML/XML

CSV to XLS

CSV to XLSX

CSV to HTML/XML

CSV to Fixed Width Text (ASCII/ANSI/Unicode)

Others   

Convert Fixed Width Text to CSV Files

(Batch Conversion of Fixed Width Text Files to/from XLS, CSV etc.)

English, Deutsch, Franšais, Italiano, 日本語, Brazilian Portuguese, Espa˝ol, Other Languages

'Convert XLS'  Used to convert Fixed Width Text Files to CSV

Do you need software to Convert Fixed Width Text Files to CSV?  If the answer is yes, then we have just the tool you need. Simply specify each column width, character to pad with and left or right alignment (justification) for each column with our built in fixed width text profile editor. Managing multiple fixed width text profiles is easy. We store each profile in a simple text file for easy archiving, manual editing etc.

'Convert XLS' can convert Fixed Width Text Files to CSV (as well as HTML, XML, XLS) extremely fast and it does not require any other software to be installed. Converting the other way, that is from CSV to a fixed width text file is also possible.

Note: We can handle HUGE text file sizes (gigabytes) without a problem. Unicode and other text encodings (ASCII, ANSI, UTF8 etc.) are supported.

All of our conversion tools allow you to automate the process by using the built in scheduler, command line (batch files, command prompt etc.), or for you programmers a COM/ActiveX interface.

Download 'Convert XLS' a tool which can be used to convert Fixed Width Text Files to CSV

See the bottom of this page for some examples showing how to convert fixed width text files to CSV from the command line.

Convert Fixed Width Text Files to CSV with the User Interface

'Convert XLS' video, showing how to convert Fixed Width Text Files to CSV 

Fixed Width Profile Editor (click to enlarge)

Converting From Fixed Width Text file to a CSV file

1.  Select the Convert Files Action To Do

2. Select the input file path. For a whole folder be certain to use the *.ext format.  For example if you want to convert the folder of txt files located in “C:\input folder\” then use “C:\input folder\*.txt”.

     Choose the Convert XLS conversion method.

     Specify the input file format.  In this case it may be "Text (ASCII), Fixed Width (*.TXT)" or for Unicode "Text (Unicode), Fixed Width (*.TXT)".

    Click on the Options button and then the Converting to/from a Fixed Width Text File tab and specify each column width for the input file.

3.  Now specify the output file path. If you are doing a whole folder, then specify the whole folder using the “*.ext” format (for example "c:\output\*.csv").  Finally, specify the ‘Convert To File Format” target (output) file type, in this case it may be one of two choices, “[6] Character Separated (*.CSV)” or if using Unicode “[23] Character Separated Unicode (*.CSV)”. 

4. Click the CONVERT button on the tool bar to start converting.

 

Converting To Fixed Width Text file from a CSV file

1.  Select the Convert Files Action To Do

2. Select the input file path. For a whole folder be certain to use the *.ext format.  For example if you want to convert the folder of xls files located in “C:\input folder\” then use “C:\input folder\*.xls”.

     Choose the Convert XLS conversion method.

     Specify the Original File Format.  In this case it may be one of two choices, “[6] Character Separated (*.CSV)” or if using Unicode “[23] Character Separated Unicode (*.CSV)”. 

    Click on the Options button and then the Converting to/from a Fixed Width Text File tab and specify each column width, pad character, and alignment for the output file.  Also, choose the sheets from the input file(s), ranges and whether to include values or 'formulas and values' to convert.

3.  Now specify the output file path. If you are doing a whole folder, then specify the whole folder using the “*.ext” format (for example "c:\output\*.txt").  Finally, specify the ‘Convert To File Format” target (output) file type, in this case it may be "[21] Text (ASCII), Fixed Width (*.TXT)" or for Unicode "[42] Text (Unicode), Fixed Width (*.TXT)".  Note that you will have more choices available if you choose the ‘MS Excel’ conversion method.

4. Click the CONVERT button on the tool bar to start converting.