Office 97 through 2013 Compatible!
Empower yourself with Excel Converter tools from Softinterface.


Product Navigation
Clients
 

Excel Converter

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

Excel Converter

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
convert CSV to PDF software, no viruses

You need to convert from

XLS to CSV (Unicode/ASCII/ANSI)

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

XLS  to HTML/XML

XLS to XLSX

XLSX to CSV (Unicode/ASCII/ANSI)

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

XLSX  to HTML/XML

XLSX to XLS

XLSM to CSV (Unicode/ASCII/ANSI)

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

XLSM  to HTML/XML

XLSM to XLSX

XLSM to XLS

Excel to PDF

Excel to XPS

CSV to XLS

CSV to XLSX

CSV to HTML/XML

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

CSV to PDF

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

 

'Convert XLS'

(MS Excel Conversion and Sheet Manipulation Utility)

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

Convert Excel with ' Convert XLS '

Convert XLS is a simple to use, yet sophisticated Excel converter utility specifically designed for Excel, text and CSV (character/comma delimited) files. If you need to convert/manipulate one or thousands of files, located in one or many folders this is the tool!  Conversions can be done 10-15 times faster without MS Excel.

Repeat complex conversion tasks simply by restoring prior 'Conversion Jobs'.  A 'Conversion Job' consists of all 'Conversion Tasks' that you specify to be done within the 'Convert XLS' user interface.  Each task can be detailed one at a time with Convert XLS s friendly user interface.  This makes your future work to manipulate and convert XLS/XLSX /CSV/TXT files on a regular basis mindless endeavor!

Convert Excel with ' Convert XLS '

Automate your Excel Conversion tasks by using:

Need to Convert Excel files?  Download and Try It (Free)!   For on line documentation... click here.

Need to convert from a highly complicated text file to a XLS or CSV File (not a character delimited or fixed width text file)?  See 'TXL Wizard'

Additional information for using 'Convert XLS' from the command line is shown below.

‘Convert XLS’ Features

  • Save and restore complex conversion configurations.
  • Convert Excel files to and from XLS/XLSX/Text/CSV/HTML/XML without requiring MS Excel to be installed. If you do have MS Excel, 'Convert XLS' will support all file types in addition to TXT, XML, CSV etc. (see table below for a listing).
  • Advanced Excel Manipulation Special processes including moving, deleting, adding and copying sheets.  Append/Concatenate Excel files into a single sheet.
  • Special processing of files including appending/concatenation, removing extra lines, launching 3rd party programs, search and replace strings and much more.
  • XLSX Conversion now supported! Convert XLSX to CSV, HTML, XML, XLS, TXT etc.
  • Numerous CSV (comma delimited file) manipulation features including padding, swapping out the delimiter and more. See below for more details.
  • Move or delete input files after processing.
  • Convert Fixed Width Text Files to/from Excel or CSV files.
  • Supports recursive subfolders.
  • Batch can be stopped midway and resumed at a later time. 
  • Automate 'Convert XLS' from the command line or use the COM/ActiveX interface. Complete flexibility, complete power.
  • Can be adapted for all languages.

If you need to manipulate Excel file data, ‘ Convert XLS comes with numerous specialized processes including:

  • Convert Excel to/from to many file types including CSV, XML, HTM, TXT, SLK, WKS, DBF, Lotus and others. See below for listing.
  • Copy Sheet Data/Formula from the same or different workbook. Specify ranges! Can be used to merge data from many sheets/workbooks.
  • Copy Worksheet(s) whole (including formatting) to the same or different workbook, and specify location within the workbook.
  • Merge Excel File Data. Combine Excel worksheet data by specifying the sheet(s) (and/or Range within each sheet) from a whole folder of workbooks to a single sheet.
  • Change cell(s) Value or Formula.
  • Batch printing of Excel (or any file MS Excel can open).
  • Run Excel Macros from command line or user interface.
  • Convert Word Tables To Excel
  • Change cell numeric formatting of sheets/cells you specify. (e.g. apply currency format, text format, general number format, etc.)
  • Search and Replace Cell Contents of the sheets/cells you specify
  • Add a new sheet and specify where to place the new sheet
  • Delete a single or whole range of sheets within a workbook
  • Move a sheet to a specific place within a workbook
  • Rename an existing sheet
  • Delete specified rows or columns, leaving the rest of the worksheet intact
  • Transpose sheet data by converting rows to columns and columns to rows.
  • Change/Remove Workbook Passwords

In addition to the worksheet manipulation, many other special processing for text, CSV, DOC, RTF and HTML files have been included. These include:

  • (DOC, RTF, HTM and TXT) Append (Concatenate) files. Original file(s) contents is placed at the end of the Target file.
  • (DOC, RTF, HTM and TXT) Remove Empty Lines
  • (DOC, RTF, HTM and TXT) Search and Replace a String
  • (CSV and TXT) Replace a character
  • (*.CSV) Surround field with quotes
  • (*.CSV) Pad field with spaces
  • (*.CSV) Change comma to other delimiter
  • (*.CSV) Remove Empty Lines
  • (*.CSV) Created Fixed Width Fields
  • (*.CSV) Include specified ROWS, discard all others
  • (*.CSV) Include specified COLUMNS, discard all others
  • (*.CSV) Remove control characters
  • (*.CSV) Trim excess commas
  • (*.CSV) Pad field(s) to a fixed length
  • Launch (Run) a program
Not sure which product of ours to use? Click here.
 

What is the Command Line?

If know how to use the command line and don't want to read the documentation skip straight to the examples.

‘Convert XLS’ can be run without a user interface with command line arguments much like in the good old DOS days.  Alternatively you can initiate command line execution by going to the operating system 'command prompt' or within Windows at the START-RUN menu and typing it in there.  Lastly, the command line interface can be used from Batch files (files with *.BAT extension). 

There are two approaches to using the command line:

     A)  Specify a 'Conversion Job' that was built using the graphical user interface (GUI); or

     B)   Specify a 'Conversion Task' in detail from the command line.

Specifying a 'Conversion Job' is very easy, as you only need to tell Convert XLS where to find the associated *.SII 'Conversion Job' file that you created from the GUI interface.  All the details associated with this task are executed in one fell swoop.  Specifying a 'Conversion Task' is much more tedious, but does not require the prior creation of a 'Conversion Job' file.  Each approach is discussed in more detail below.

Important: To use the command line successfully you must do one of the following:

A) Set the path in your environment variables to the location of ConvertXLS.EXE; or,

B) Use the full path in the command line (with double quotes) like so:
"C:\Program Files\Softinterface, Inc\Convert XLS\ConvertXLS.EXE" /S"C:\test\test.csv" /T "C:\test\test.xls" /C-4143 /F6 /M2 /V
 

Otherwise, you'll see the following error: 
"'Convert XLS' is not recognized as an internal or external command, operable program or batch file."

 

Specifying a 'Conversion Job'

Once a conversion job has been created from the GUI interface, the syntax for specifying a 'Conversion Job'  is:

 ConvertXLS /J{ConversionJobFile}  [/V] [/L{LogFile}] [/B{LogToJobFile}] [/W{pw}] [/X{pw}] [/Y{pw}] [/Z{pw}]

Items above enclosed in square brackets “[ ]” are optional, all other ‘switches’ are required.  Therefore /J should always be specified on the command line.

 Example:

To run the 'Conversion Job' specified by the "C:\MyJobs\ApplesOranges.SII" type the following in at the 'Command Prompt':

 ConvertXLS /J"C:\MyJobs\ApplesOranges.SII"

You can include or exclude spaces between switches and parameters.  For example,  "/C6" is the same as "/C  6".  For long file names you may be required to use double quotes.  For example /J"C:\Program Files\MyApp\MyDoc.DOC".

Specifying a 'Conversion Task'

The documentation has a comprehensive set of examples, below are a selected few.  Modifying the examples can be a quick way to get going.

The syntax for the command line for specifying a conversion task is:

ConvertXLS /S{Original File(s)} /T{Target File(s)} /F# /C# [/M#][/N"{Sheet^Range^DelimChar}"] [/G] [/V] [/R] [/L{Logfile}] [/B{LogToJobFile}][/U] [/W{pw}] [/X{pw}] [/Y{pw}] [/Z{pw}]

Items above enclosed in square brackets "[ ]" are optional, all other 'switches' are required. Therefore /S, /T, /C# should always be specified on the command line. There is one exception, however, and that is when /G (Save to original folder) is specified, the /T switch is not necessary.

You can include or exclude spaces between switches and parameters. For example, "/C6" is the same as "/C 6". For long file names you may be required to use double quotes. For example /S"C:\Program Files\MyApp\MyDoc.DOC".

/S{Original File(s)} is used to specify which files to convert. You can specify a single file, or in some cases a whole set of files using the wildcard syntax (i.e. "C:\MyFiles\*.XLS"). /T{Target files} should always be different from /S{Original File(s)}.

Additional Note: Any file type that MS Excel can open is a valid original file /S{Original File} type.

/T{Target File(s)} is used to specify where to save the converted file(s) to. You can specify a single file, or in some cases a whole set of files using the wildcard syntax (i.e. "C:\MyFiles\*.XLS"). /T{Target files} should always be different from /S{Original File(s)}.

/F# tells 'Convert XLS' what file type the Original file (/S{Original File}) is. This is only required when using the 'Convert XLS' conversion method /M2. For all constants see File Type Constants.

/C# tells 'Convert XLS' what the file type to convert the /T{Target File(s)} files to. For all constants see File Type Constants.

[/M#] Specifies the Conversion Method to be used (if converting).  The following values are valid:

1 = MS Excel (Default value)

2 = 'Convert XLS' 

          This switch is not required if you are using the 'Convert XLS' method.

[/N{"Sheet^Range^DelimChar"}] is used only when converting to/from an Excel file. It specifies which Sheets to convert, what Range to convert and what delimitation/separation character to use. The syntax for this parameter is critical, the 3 items are separated by a carrot character "^". If you do not include Sheet, Range or DelimChar they will default to all sheets, all used ranges and the comma delimitation character.  Also, the double quotation marks should always enclose this parameter.

Use "*" or "" for all sheets. You can use names of sheets, or the numeric index. If using numeric indices, you can specify ranges of sheets (i.e. "1,4,10-20" and "4-10,9" etc.). Range and DelimChar are optional.

For example to specify sheets "Apples" and "Oranges", with a Range of "A2:B20" and using a tab (ASCII decimal value of 9) as a separation character the syntax would be:

/N"Apples,Oranges^A2:B20^9"

[/G] Save files to their original folders. Use this instead of /T to place the converted files in the same folder as the original file. Cannot be used when converting a single, specified file from within a folder. Use the /T switch instead.

[/V] Verbose mode. Specify this switch to display a message box indicating how the conversion went. See also /L

[/R] Seek out and do all files found in the sub-folders specified in the /S switch. Recursive subdirectories. You may add this switch if you are processing whole directories of files. See /S, /T and /G for more details on selecting whole directories to be converted.

[/L{LogFile}] Log file path and name (i.e. d:\mylogs\WCE.LOG) If this switch is specified a log file with the given path and name will be created and the results of the conversion will be written to it. See also /V

[/B{LogToJobFile}] Save the Log file as a 'Conversion Job' ONLY IF ERRORS OCCURRED. This is useful if the files that had problems can be done at a later time, or with a different method. /B is different from /L, since the file generated with /B will not include extraneous comments not allowed in a 'Conversion Job' file. Save as a .SII file type so it can be loaded as a job.

[/U] If converting an XLS file with multiple sheets specified, the /U switch will generate multiple files instead of a single file.

[/W{PasswordToOpenOriginalFile(s)}]   Password to open the original file.

[/X{PasswordToWriteToOriginalFile(s)}]   Password to allow for the writing to the original file.

[/Y{PasswordToOpenTargetFile(s)}]   Password to open the target file.

[/Z{ PasswordToWriteToTargetFile (s)}]   Password to allow for the writing to the target file.

 

See Also:
Web Based Documentation which includes example usage of the command line.

File Type

Description Constant

Unicode Text

(*.TXT) Unicode Text. Tab delimited.

42

Text MS DOS

(*.TXT) Text (MS-DOS) Tab delimited.

21

XML

(*.XML) Extensible Markup Language

46

HTML

(*.HTM, *.HTML) Web Page

44

XLS

(*.XLS) Microsoft Excel 97-2003 Workbook

-4143

XLSX

(*.XLSX) Microsoft Open XML Excel Workbook

This is also the default file type as set in Excel’s:

Office Button>Excel Options>Save

51

XLSM

(*.XLSM) Excel Macro-Enabled Workbook

52

1CSV

(*.CSV) Comma Delimited

6

1CSV Unicode

(*.CSV) Comma Delimited Windows Unicode

23

1CSV UTF-8

(*.CSV) Comma Delimited

NOTE: ‘Convert XLS’ conversion method only.

25

CSV Mac

(*.CSV) Comma Delimited Macintosh

22

CSV MS DOS

(*.CSV) Comma Delimited DOS

24

Web Page

(*.MHT) Single File Web Page

45

Text Printer

(*.PRN) Space Delimited Text File

36

Text Windows

(*.TXT) Tab Delimited Text File

20

Text Macintosh

(*.TXT) Tab Delimited Text File

19

3Text

(*.TXT) Tab Delimited Text File. Platform Independent.

-4158

3XLSM

(*.XLSM) Open XML Workbook Macro Enabled

52

3XLSB

(*.XLSB) Binary Workbook

50

3XLTX

(*.XLTX) Open XML Template

54

3XLTM

(*.XLTM) Open XML Template Macro Enabeld

53

3XLAM

(*.XLAM) Open XML Add-In

55

DIF

(*.DIF) Data Interchange Format

9

Excel 5

(*.XLW) Microsoft Excel 5.0/95 Workbook

39

Excel 7

(*.XLW) Microsoft Excel 7.0/95 Workbook

39

SYLK

(*.SLK) SYLK (Symbolik Link)

2

Template

(*.XLT) Template

17

Add In

(*.XLA) Microsoft Excel Add In

18

International Add In

Excel International add-in

26

International Macro

Excel International macro

25

2Excel 2

(*.XLS) Microsoft Excel 2.0 Worksheet

16

2Excel 2 Far East

(*.XLS) Microsoft Excel 2.0 Worksheet Far East

27

2Excel 3

(*.XLS) Microsoft Excel 3.0 Worksheet

29

2Excel 4

(*.XLS) Microsoft Excel 4.0 Worksheet

33

2Excel 4 Workbook

(*.XLW) Microsoft Excel 4.0 Workbook

35

2Excel 97/95

(*.XLS) Microsoft Excel 97-2000 & 5.0/95 Workbook

43

2DBF2

(*.DBF) dBase II

7

2DBF3

(*.DBF) dBase III

8

2DBF4

(*.DBF) dBase IV

11

2WK1

(*.WK1) Lotus (1-2-3) 2.x Format

5

2WK1 All

(*.WK1) Lotus (1-2-3) 2.x ALL Format

31

2WK1 Format

(*.WK1) Lotus (1-2-3) 2.x FMT Format

30

2WK3

(*.WK3) Lotus (1-2-3) 3.x FMT Format

15

2WK4

(*.WK4) Lotus (1-2-3) 4.x Format

38

2WK3 Format

(*.WK3) Lotus (1-2-3) 3.x and Windows Format

32

2WKS

(*.WKS ) MS Works Format

4

2Works2 Far East

(*.WKS ) MS Works (Far East) Format

28

2WQ1

(*.WQ1) Quattro Pro for MSDOS Format

34

2WJ2 WD1

(*.WJ2) Japanese 1-2-3

14

2WJ3

(*.WJ3) Japanese 1-2-3

40

2WJ3 Format

(*.WJ3) Japanese 1-2-3 Format

41

 'Convert XLS' Supported File Types, Items in bold can be done without MS Excel installed.

1Note that the ‘Convert XLS’ conversion method can specify any character be used to delimit the data. So including the comma character, you could specify the TAB, Semicolon, Bar or any character in the ASCII chart. Specify the character by going to the OPTIONS button then click on the "CSV, TSV…" tab.

2No longer supported in MS Excel versions 2007 and above.

3Versions of Excel 2007 and up will support this file format.

 

 

Text, CSV, and HTML (various database formats also) are just a few of the many formats you may use this Excel converter to go to and from.   Convert Excel files with 'Convert XLS'!

 

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 'Convert XLS'  Linda Romano

"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 June 2003.

Convert Excel with ' Convert XLS '

ATLANTA, GA --- MDdatacor, inc., a leading provider of clinical information management products for physician practices and the healthcare industry, recently choose Convert Doc, a document conversion utility, from SoftInterface, Inc. as its product of choice to convert "Office" style documents to standard text files.

"We are very pleased with our decision to go with Convert Doc," commented Tim Lewis, MDdatacor Vice President of Information Systems. "It is a resource efficient program that currently converts over 75,000 documents a day for us. We like the fact that the program has a command line interface that allows us to integrate it into our automation routine. We evaluated other software packages costing 10 to 20 times more, but selected Convert Doc due to its speed and SoftInterface's service. We have been very pleased with how quickly SoftInterface's development team responds to our feedback and requests."

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  'Diff Doc'  + 'Convert Doc'

Special Promotion: Buy 'Convert XLS' and get 'Convert Doc', 'Convert Image' and 'Convert PowerPoint' free!
Google