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 |
|
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 |
|
3PDF |
Portable Document Format |
-1 |
|
3XPS |
XML Paper Specification |
-2 |
|
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 |
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. 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: