Excel 2007 supports several file type for editing or opening workbook files created in other program. It can also convert excel files into other file types compatible with such programs. Below tables lists various files type supported by MS Excel 2007 under following categories….
- MS Excel Formats
- Text Formats
- Clipboard Formats
- Other Formats
Note: If you save a workbook in Text, CSV, Image type or any other format there may be loss for functionality available in the original file.
Excel Format
| Format | Extension | Description |
| Excel Workbook | .xlsx | XML-based file format. Note: It cannot store VBA macro code or MS Excel 4.0 macro sheets (.xlm). |
| Excel Workbook (code) | .xlsm | XML-based, macro-enabled file format. Unlike .xlsx file format it can store VBA macro code or Excel 4.0 macro sheets (.xlm). |
| Excel Binary Workbook | .xlsb | MS Excel 2007 Binary file format (BIFF12). |
| Template | .xltx | Excel 2007 file format for an Excel template. It does not store VBA macro code or Excel 4.0 macro sheets (.xlm). |
| Template (code) | .xltxm | Excel 2007 macro-enabled Excel template file format that can store VBA macro code or Excel 4.0 macro sheets (.xlm). |
| Excel 97- Excel 2003 Workbook | .xls | The Excel 97 - Excel 2003 Binary file format (BIFF8). |
| Excel 97- Excel 2003 Template | .xlt | The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template. |
| MS Excel 5.0/95 Workbook | .xls | The Excel 5.0/95 Binary file format (BIFF5). |
| XML Spreadsheet 2003 | .xml | XML Spreadsheet 2003 file format (XMLSS). |
| XML Data | .xml | XML Data format. |
| Excel Add-In | .xlam | Excel 2007’s XML-based macro-enabled Add-In (a supplemental program that is designed to run additional code) that supports VBA projects & Excel 4.0 macro sheets (.xlm). |
Text Formats
| Format | Extension | Description |
| Formatted Text (Space-delimited) | .prn | Lotus space-delimited format. It can store only the active sheet. |
| Text (Tab-delimited) | .txt | Saves a workbook as a tab-delimited text file. It can store only the active sheet. |
| Text (Macintosh) | .txt | Saves a workbook as a tab-delimited text file. It can store only the active sheet. |
| Text (MS-DOS) | .txt | Saves a workbook as a tab-delimited text file. It can store only the active sheet. |
| Unicode Text | .txt | Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium. |
| CSV (comma delimited) | .csv | Saves a workbook as a tab-delimited text file. It can store only the active sheet. |
| CSV (Macintosh) | .csv | Saves a workbook as a tab-delimited text file. It can store only the active sheet. |
| CSV (MS-DOS) | .csv | Saves a workbook as a tab-delimited text file. It can store only the active sheet. |
| DIF | .dif | Data Interchange Format. Saves only the active sheet. |
| SYLK | .slk | Symbolic Link Format. Saves only the active sheet. |
Clipboard Formats
| Format | Extension | Clipboard type Identifiers |
| Picture | .wmf or .emf | Pictures in Windows Metafile Format (WMF) or Windows Enhanced Metafile Format (EMF). |
| Note If you copy a Windows metafile picture from another program, Excel pastes the picture as an enhanced metafile. | ||
| Bitmap | .bmp | Pictures stored in Bitmap format (BMP). |
| Microsoft Excel file formats | .xls | Binary file formats for Excel versions 5.0/95 (BIFF5), Excel 97-2003 (BIFF8), and Office Excel 2007 (BIFF12). |
| SYLK | .slk | Symbolic Link Format. |
| DIF | .dif | Data Interchange Format. |
| Text (tab-delimited) | .txt | Tab-separated text format. |
| CSV (Comma-delimited) | .csv | Comma-separated values format. |
| Formatted text (Space-delimited) | .rtf | Rich Text Format (RTF). Only from Excel. |
| Embedded object | .gif, .jpg, .doc, .xls, or .bmp | Microsoft Excel objects, objects from properly registered programs that support OLE (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) |
| Linked object | .gif, .jpg, .doc, .xls, or .bmp | OwnerLink, ObjectLink (ObjectLink: An OLE data format that describes a linked object, identifying the class, document name, and name of an object. Each of these data items; is a null-terminated string.), Link, Picture, or other format. |
| Office drawing object | .emf | Office drawing object format or Picture (Windows enhanced metafile format, EMF). |
| Text | .txt | Display Text, OEM Text. |
| HTML | .htm | Hypertext Markup Language. |
| Note When you copy text from another program, Excel pastes the text in HTML format, regardless of the format of the original text. |
Other Formats
| Format | Extension | Description |
| Quattro Pro 5.0 (Win) | .wb1 | Quattro Pro version 5.0 for Windows. You can open Quattro Pro files in Excel by using a converter. You cannot save an Excel file to Quattro Pro format. |
| Quattro Pro 7.0 (Win) | .wb3 | Quattro Pro version 7.0 for Windows. You can open Quattro Pro files in Excel by using a converter. You cannot save an Excel file to Quattro Pro format. |
I hope you found the information useful and Thank you for reading.
No comments:
Post a Comment