File formats supported in the 2007 Office system (corrected)


Hello, my name is Ben and I’m a technical writer on the Office Resource Kit team. My article on Office 2007 file formats was published this week (http://technet.microsoft.com/en-us/library/cc179078.aspx), but due to a publishing system error, the wrong version was published. The version up there right now is probably the very first draft (and more like a template), and it has gone through several iterations since then. We are fixing the issue, and the correct version should be up by this Thursday, April 9th. In the meantime, I’m pasting the correct article here. Sorry for any inconvenience and thanks for your patience!

In this article:

This article discusses the file formats that are supported in Microsoft Office Word 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, and Microsoft Office Access 2007. It also provides additional information about file formats that applies to all four applications.

File formats supported in Word 2007

You can save an Office Word 2007 file in another file format by clicking the Microsoft Office Button, and then Save As.

You can open a file that was created in another file format (in an earlier version of Microsoft Office Word or in another program) by clicking the Microsoft Office Button, and then Open. You will be prompted to save the file to an Office Word 2007 format. For files that were created in an earlier version of Word, you have the option to keep the original format.


Word file formats

File format File extension Description

Word Document

.docx

The default Office Word 2007 file format.

Word Macro-Enabled Document

.docm

The Office Word 2007 XML-based and macro-enabled file format. Stores Visual Basic for Applications (VBA) macro code.

Word 97-2003 Document

.doc

The default Word 97-2003 file format.

Word Template

.dotx

Template for creating new Office Word 2007 files that do not contain macros.

Word Macro-Enabled Template

.dotm

Template for creating new Office Word 2007 files that contain macros. If you want to include UI customizations or macros in the template, use this file format.

Word 97-2003 Template

.dot

Template for Word 97-2003 files.

Word XML Document

.xml

The XML file format supported in Office Word 2007 (Open XML).

Word 2003 XML Document

.xml

The XML format supported in Office Word 2003.

Other file formats

File format File extension Description

Portable Document Format (PDF)

.pdf

PDF is a fixed-layout file format that enables a file to retain the intended format when either viewed or printed, and is not easily changed. The ability to save an Office Word 2007 document in PDF file format (directly from Office Word 2007) is enabled by installing the 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (http://go.microsoft.com/fwlink/?LinkId=111590).

XML Paper Specification (XPS)

.xps

XPS is another fixed-layout file format that enables a file to retain the intended format when either viewed or printed, and is not easily changed. The ability to save an Office Word 2007 document in XPS file format (directly from Office Word 2007) is enabled by installing the 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (http://go.microsoft.com/fwlink/?LinkId=111590).

Single File Web Page

.mht; .mhtml

A Web page as a single file with an .htm file and all supporting files, such as images, sound files, cascading style sheets, scripts, and more.

Web Page

.htm

A Web page as a folder with an .htm file and all supporting files, such as images, sound files, cascading style sheets, scripts, and more. Good for posting on a site or editing with Microsoft Office FrontPage or another HTML editor.

Web Page, Filtered

.htm

Saving in the Web Page, Filtered file format removes Microsoft Office-specific tags. If you save in filtered HTML and then re-open the file in an Office application, text and general appearance will be preserved, but some features might work differently.

Rich Text Format

.rtf

RTF controls the representation and formatting of a document, both on the screen and in print. With the RTF file format, documents created under different operating systems and with different software applications can be transferred between those operating systems and applications.

Plain Text

.txt

When you save a Office Word 2007 document as a .txt file, you lose all formatting.

Works 6.0-9.0

.wps

This is the default file format of Microsoft Works, versions 6.0 through 9.0.

File formats supported in Excel 2007

You can save an Office Excel 2007 file in another file format by clicking the Microsoft Office Button, and then Save As. The file formats that are available in the Save As dialog box vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet).

You can open a file that was created in another file format (in an earlier version of Microsoft Office Excel or in another program) by clicking the Microsoft Office Button, and then Open. You will be prompted to save it to an Office Excel 2007 format, unless you open a workbook that is shared. For files that were created in an earlier version of Office Excel, you have the option to keep the original format.


Excel file formats

File format File extension Description

Excel Workbook

.xlsx

The default Office Excel 2007 XML-based file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm).

Excel Macro-Enabled Workbook

.xlsm

The Office Excel 2007 XML-based and macro-enabled file format. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).

Excel Binary Workbook

.xlsb

The Office Excel 2007 Binary file format (BIFF12).

Excel Template

.xltx

The default Office Excel 2007 file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).

Excel Macro-Enabled Template

.xltxm

The Office Excel 2007 macro-enabled file format for an Excel template. Stores 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.

Microsoft Excel 5.0/95 Workbook

.xls

The Excel 5.0/95 Binary file format (BIFF5).

Excel Add-In

.xlam

The Office Excel 2007 XML-based and macro-enabled Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).

Excel 97-2003 Add-In

.xla

The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects.

Text file formats

File format File extension Description

Formatted Text (Space-delimited)

.prn

Lotus space-delimited format. Saves only the active sheet.

Text (Tab-delimited)

.txt

Saves a workbook as a tab-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

Text (Macintosh)

.txt

Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

Text (MS-DOS)

.txt

Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves 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 comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

CSV (Macintosh)

.csv

Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

CSV (MS-DOS)

.csv

Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

DIF

.dif

Data Interchange Format. Saves only the active sheet.

SYLK

.slk

Symbolic Link Format. Saves only the active sheet.

Note:
If you save a workbook in text format, all formatting is lost.

 

 

Other file formats

File format File extension Description

Portable Document Format (PDF)

.pdf

PDF is a fixed-layout file format that enables a file to retain the intended format when either viewed or printed, and is not easily changed. The ability to save an Office Excel 2007 document in PDF file format (directly from Office Excel 2007) is enabled by installing the 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (http://go.microsoft.com/fwlink/?LinkId=111590).

XML Paper Specification (XPS)

.xps

XPS is another fixed-layout file format that enables a file to retain the intended format when either viewed or printed, and is not easily changed. The ability to save an Office Excel 2007 document in XPS file format (directly from Office Excel 2007) is enabled by installing the 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (http://go.microsoft.com/fwlink/?LinkId=111590).

XML Spreadsheet 2003

.xml

XML Spreadsheet 2003 file format.

XML Data

.xml

XML Data format.

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.

File formats supported in PowerPoint 2007

You can save an Office PowerPoint 2007 file in another file format by clicking the Microsoft Office Button, and then Save As.

You can open a file that was created in another file format (in an earlier version of Microsoft Office PowerPoint or in another program) by clicking the Microsoft Office Button, and then Open. You will be prompted to save the file to an Office PowerPoint 2007 format. For files that were created in an earlier version of PowerPoint, you have the option to keep the original format.

Important:
Office PowerPoint 2007 does not support saving to PowerPoint 95 (or earlier) file formats or Pack and Go Wizard (.ppz) files.

 

 


PowerPoint file formats

File format File extension Description

PowerPoint Presentation

.pptx

An Office PowerPoint 2007 presentation, which is an XML-enabled file format, by default.

PowerPoint Macro-Enabled Presentation

.pptm

A presentation that contains Visual Basic for Applications (VBA) code.

PowerPoint 97-2003 Presentation

.ppt

A presentation that you can open in PowerPoint 97 to Office PowerPoint 2003.

PowerPoint Design Templates

.potx

A presentation as a template that you can use to format future presentations.

PowerPoint Macro-Enabled Design Template

.potm

A template that includes pre-approved macros that you can add to a template to be used in a presentation.

PowerPoint 97-2003 Design Template

.pot

A template that you can open in PowerPoint 97 to Office PowerPoint 2003.

Office Theme

.thmx

A style sheet that includes definitions of a color theme, font theme, and effect theme.

PowerPoint Show

.pps; .ppsx

A presentation that always opens in Slide Show view rather than in Normal view.

PowerPoint Macro-Enabled Show

.ppsm

A slide show that includes pre-approved macros that you can run from within a slide show.

PowerPoint 97-2003 Show

.ppt

A slide show that you can open in PowerPoint 97 to Office PowerPoint 2003.

PowerPoint Add-In

.ppam

An add-in that stores custom commands, Visual Basic for Applications (VBA) code, and specialized features such as an add-in.

PowerPoint 97-2003 Add-In

.ppa

An add-in that you can open in PowerPoint 97 to Office PowerPoint 2003.

Other file formats

File format File extension Description

Portable Document Format (PDF)

.pdf

PDF is a fixed-layout file format that enables a file to retain the intended format when either viewed or printed, and is not easily changed. The ability to save an Office PowerPoint 2007 document in PDF file format (directly from Office PowerPoint 2007) is enabled by installing the 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (http://go.microsoft.com/fwlink/?LinkId=111590).

XML Paper Specification (XPS)

.xps

XPS is another fixed-layout file format that enables a file to retain the intended format when either viewed or printed, and is not easily changed. The ability to save an Office PowerPoint 2007 document in XPS file format (directly from Office PowerPoint 2007) is enabled by installing the 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (http://go.microsoft.com/fwlink/?LinkId=111590).

Single File Web Page

.mht; .mhtml

A Web page as a single file with an .htm file and all supporting files, such as images, sound files, cascading style sheets, scripts, and more. Good for sending a presentation in e-mail.

Web Page

.htm; .html

A Web page as a folder with an .htm file and all supporting files, such as images, sound files, cascading style sheets, scripts, and more. Good for posting on a site or editing with Microsoft Office FrontPage or another HTML editor.

GIF (Graphics Interchange Format)

.gif

A slide as a graphic for use on Web pages.

The GIF file format is limited to supporting 256 colors, and therefore, it is more effective for scanned images such as illustrations rather than color photographs. GIF can also be good for line drawings, black and white images, and small text that is only a few pixels high. GIF supports animation and transparent backgrounds.

JPEG (Joint Photographic Experts Group) File Format

.jpg

A slide as a graphic for use on Web pages.

The JPEG file format supports 16 million colors and is best suited for photographs and complex graphics.

PNG (Portable Network Graphics) Format

.png

A slide as a graphic for use on Web pages.

PNG was approved as a standard by the World Wide Web Consortium (W3C) to replace GIF. PNG does not support animation as GIF does, and some older browsers do not support this file format.

TIFF (Tag Image File Format)

.tif

A slide as a graphic for use on Web pages.

TIFF is the best file format for storing bit-mapped images on personal computers. TIFF graphics can be any resolution, and they can be black and white, gray-scaled, or color.

Device Independent Bitmap

.bmp

A slide as a graphic for use on Web pages.

A bitmap is a representation, consisting of rows and columns of dots, of a graphics image in computer memory. The value of each dot (whether it is filled in or not) is stored in one or more bits of data.

Windows Metafile

.wmf

A slide as a 16-bit graphic (for use with Microsoft Windows 3.x and later).

Enhanced Windows Metafile

.emf

A slide as a 32-bit graphic (for use with Microsoft Windows 95 and later).

Outline/RTF

.rtf

A presentation outline as a text-only document that provides smaller file sizes and the ability to share macro-free files with others who might not have the same version of PowerPoint or the operating system that you have. Any text in the notes pane is not saved with this file format.

File formats supported in Access 2007

This section describes the differences between the new Office Access 2007 ACCDB file format and the earlier-version MDB file format. In Office Access 2007, the Microsoft Jet database engine has been customized for the 2007 Office system applications. This Office-specific version of Jet, called the Access Database Engine, enables integration with Windows SharePoint Services 3.0 and Microsoft Office Outlook 2007, creation of multi-valued lookup fields, and other improvements.


New features of the Office Access 2007 file format

Feature Description

Multi-valued lookup fields

Most database programs, including prior versions of Access, only allow you to store a single value in each field. In Office Access 2007, however, you can now create a lookup field that allows you to store more than one value in each field. In effect, it creates a many-to-many relationship within the field, and hides the details of the implementation using system tables.

For example, suppose you have a Task table with a lookup field that you used to assign the task to an employee. What if you have a task that you need to assign to several employees? In earlier versions of Access, you would need to set up a new cross-reference table to store each combination of task and employee, and then revise your forms and reports to use the new data structure. In Office Access 2007, this is made much easier by implementing a multi-valued lookup field. Instead of being able to select only one item from a drop-down list, now each item in the list has a check box next to it so that you can select as many as you like. The multiple selections are displayed in the field, separated by commas.

Attachment data type

The new Attachment data type lets you easily store all types of documents and binary files in your database without unnecessary database bloat. Attachments are automatically compressed when appropriate to maximize space usage. You can attach a Office Word 2007 document to a record, or save a series of digital pictures. You can even have multiple attachments attached to a single record.

Integration with Windows SharePoint Services 3.0 and Office Outlook 2007

In the past, Access files have been blocked from Windows SharePoint Services 3.0 and Office Outlook 2007 because unsafe code could be included within an Access database. Office Access 2007 implements a new format that allows code to be either verified as safe or disabled. This makes it possible to integrate Access databases much more fully with Windows SharePoint Services 3.0 and Office Outlook 2007, and it also allows anti-virus programs to inspect Access database files much more easily.

Work with your SharePoint data offline

You can take your SharePoint lists offline with one click by using Office Access 2007. Work on your data in Access and then synchronize your changes, or reconnect with the SharePoint site at a later time.

Memo field history tracking

Memo fields are useful for storing large amounts of information. Starting with Office Access 2007, you can set a property (AppendOnly) that forces Access to retain a history of all changes to a Memo field. You can then view a history of those changes. This feature also supports the versioning feature in Windows SharePoint Services 3.0 so that you can use Access to track changes in a multiple lines of text field stored in a SharePoint list (provided that the field has the Append Changes to Existing Text option set to Yes).

New file extensions

File extension Description

ACCDB

The file extension for the new Office Access 2007 file format. This takes the place of the MDB file extension.

ACCDE

The file extension for Office Access 2007 files that are in “execute only” mode. ACCDE files have all Visual Basic for App