NOTE: Items in BOLD can be used in the both the 'Convert XLS' /M2 and MS Excel /M1 Conversion Methods. All items that are not BOLD can only be used with the MS Excel /M1 switch.
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 |
CSV (1) |
(*.CSV) Comma Delimited |
6 |
CSV Unicode (1) |
(*.CSV) Comma Delimited Windows Unicode |
23 |
CSV UTF-8 (1) |
(*.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 |
Text (3) |
(*.TXT) Tab Delimited Text File. Platform Independent. |
-4158 |
PDF (3) |
Portable Document Format |
-1 |
XPS (3) |
XML Paper Specification |
-2 |
XLSM (3) |
(*.XLSM) Open XML Workbook Macro Enabled |
52 |
XLSB (3) |
(*.XLSB) Binary Workbook |
50 |
XLTX (3) |
(*.XLTX) Open XML Template |
54 |
XLTM (3) |
(*.XLTM) Open XML Template Macro Enabeld |
53 |
XLAM (3) |
(*.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 |
Excel 2 (2) |
(*.XLS) Microsoft Excel 2.0 Worksheet |
16 |
Excel 2 Far East (2) |
(*.XLS) Microsoft Excel 2.0 Worksheet Far East |
27 |
Excel 3 (2) |
(*.XLS) Microsoft Excel 3.0 Worksheet |
29 |
Excel 4 (2) |
(*.XLS) Microsoft Excel 4.0 Worksheet |
33 |
Excel 4 Workbook (2) |
(*.XLW) Microsoft Excel 4.0 Workbook |
35 |
Excel 97/95 (2) |
(*.XLS) Microsoft Excel 97-2000 & 5.0/95 Workbook |
43 |
DBF2 (2) |
(*.DBF) dBase II |
7 |
DBF3 (2) |
(*.DBF) dBase III |
8 |
DBF4 (2) |
(*.DBF) dBase IV |
11 |
WK1 (2) |
(*.WK1) Lotus (1-2-3) 2.x Format |
5 |
WK1 All (2) |
(*.WK1) Lotus (1-2-3) 2.x ALL Format |
31 |
WK1 Format (2) |
(*.WK1) Lotus (1-2-3) 2.x FMT Format |
30 |
WK3 (2) |
(*.WK3) Lotus (1-2-3) 3.x FMT Format |
15 |
WK4 (2) |
(*.WK4) Lotus (1-2-3) 4.x Format |
38 |
WK3 Format (2) |
(*.WK3) Lotus (1-2-3) 3.x and Windows Format |
32 |
WKS (2) |
(*.WKS ) MS Works Format |
4 |
Works2 Far East (2) |
(*.WKS ) MS Works (Far East) Format |
28 |
WQ1 (2) |
(*.WQ1) Quattro Pro for MSDOS Format |
34 |
WJ2 WD1 (2) |
(*.WJ2) Japanese 1-2-3 |
14 |
WJ3 (2) |
(*.WJ3) Japanese 1-2-3 |
40 |
WJ3 Format (2) |
(*.WJ3) Japanese 1-2-3 Format |
41 |
(1)Note 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.
(2)No longer supported in MS Excel versions 2007 and above.
(3)Versions of Excel 2007 and up will support this file format. PDF and XPS require the “Microsoft Save as PDF or XPS” add in. Go to Microsoft’s web site and search for “Microsoft Save as PDF or XPS add in”.
See also: