File formats supported in the 2007 Office system
This topic provides information about the file formats supported by different applications in 2007 Microsoft Office system.
PDF and XPS fixed-layout file formats
The 2007 Office release offers a free add-in to save or export files in a fixed-layout format. By using an add-in, you can save or export a file from your Microsoft Office program into the following formats:
Portable Document Format (PDF). PDF is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The PDF format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods.
XML Paper Specification (XPS). XPS is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The XPS format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed.
This add-in applies to the following products:
Microsoft Office Word 2007
Microsoft Office Excel 2007
Microsoft Office PowerPoint 2007
Microsoft Office Access 2007
Microsoft Office Publisher 2007
Microsoft Office Visio 2007
Microsoft Office OneNote 2007
To download this add-in, go to 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (go.microsoft.com/fwlink/?LinkID=82472) and follow the instructions on that page.
Word 2007
You can save a 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 formats
| Format | Extension | Description |
|---|---|---|
Document |
.docx |
|
Macro-enabled document |
.docm |
|
Template |
.dotx |
|
Macro-enabled template |
.dotm |
|
Text formats
| Format | 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 Microsoft 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. |
Note
If you save a workbook in text format, all formatting is lost.
Other formats
| Format | Extension | Description |
|---|---|---|
Clipboard formats
You can paste data from the Microsoft Office Clipboard into Word by using the Paste or Paste Special command (Home tab, Clipboard group, Paste button) if the Office Clipboard data is in one of the following formats.
| Format | Extension | Description |
|---|---|---|
Picture |
.wmf or .emf |
Pictures in Windows Metafile Format (WMF) or Windows Enhanced Metafile Format (EMF). |
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). |
Embedded object |
.gif, .jpg, .doc, .xls, or .bmp |
Microsoft Word objects, objects from properly registered programs that support OLE 2.0 (OwnerLink ), and Picture or another presentation format. |
Linked object |
.gif, .jpg, .doc, .xls, or .bmp |
OwnerLink, ObjectLink , 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. |
File formats that are not supported in Word 2007
If the file format that you want to use is not supported in Office Word 2007, you can try the following:
Search the Internet for a company that makes file format converters for file formats that are not supported in Word 2007.
Save to a file format that another program supports. For example, you may want to import your document into another program that does not support the Word file format. But the other program may be able to import another supported file format, such as a text file format. In this case, you can save your document to the XML format, and then from the other program, import the XML file.
Excel 2007
You can save a 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 formats
| Format | Extension | Description |
|---|---|---|
Excel Workbook |
.xlsx |
The default Office Excel 2007 XML-based file format. Cannot store VBA macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). |
Excel Workbook (code) |
.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). |
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). |
Template (code) |
.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). |
XML Spreadsheet 2003 |
.xml |
XML Spreadsheet 2003 file format (XMLSS). |
XML Data |
.xml |
XML Data format. |
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 formats
| Format | 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 Microsoft 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 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. |
Clipboard formats
You can paste data from the Microsoft Office Clipboard into Excel by using the Paste or Paste Special command (Home tab, Clipboard group, Paste button) if the Office Clipboard data is in one of the following formats.
| Format | Extension | Description |
|---|---|---|
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 2.0 (OwnerLink ), and Picture or another presentation format. |
Linked object |
.gif, .jpg, .doc, .xls, or .bmp |
OwnerLink, ObjectLink , 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. When you copy text from another program, Excel pastes the text in HTML format, regardless of the format of the original text. |
File formats that are not supported in Excel 2007
If the file format that you want to use is not supported in Office Excel 2007, you can try the following:
Search the Internet for a company that makes file format converters for file formats that are not supported in Excel.
Save to a file format that another program supports. For example, you may want to import your spreadsheet into another program that does not support the Excel file format. But the other program may be able to import another supported file format, such as an XML spreadsheet or a text file format. In this case, you can save your workbook to the XML spreadsheet format, and then from the other program, import the XML file.
PowerPoint 2007
With Office PowerPoint 2007, you can save your presentation into any of the file types listed in the table below.
Important
Office PowerPoint 2007 does not support saving to PowerPoint 95 (or earlier) file formats or Pack and Go Wizard (.ppz) files.
| Save As file type | Extension | Use to save |
|---|---|---|
PowerPoint Presentation |
.pptx |
A 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) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) code. |
PowerPoint 97-2003 Presentation |
.ppt |
A presentation that you can open in PowerPoint 97 to Office PowerPoint 2003. |
PDF Document Format |
Publish as PDF or XPS: A PostScript-based electronic file format developed by Adobe Systems that preserves document formatting and enables file sharing. You can save as a PDF or XPS file from a 2007 Microsoft Office system program only after you install an add-in. For more information, see Enable support for other file formats, such as PDF and XPS. |
|
XPS Document Format |
.xps |
Publish as PDF or XPS: A new Microsoft electronic paper format for exchanging documents in their final form. You can save as a PDF or XPS file from a 2007 Microsoft Office system program only after you install an add-in. For more information, see Enable support for other file formats, such as PDF and XPS. |
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. Note If you are unable to open a .pps file, see I am unable to open a .pps file. |
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. |
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) FileFormat |
.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 tha provides smaller file sizes and the ability to share macro-free files with others who may 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. |
Outlook 2007
With Microsoft Office Outlook 2007, users can open and use Outlook data files that were created in earlier versions of Outlook. Users that have Outlook Offline (OST) files—for example, users configured to use Cached Exchange Mode—do not need to recreate those files. Similarly, users with Outlook Personal Folder (PST) files can continue to use the files without converting or migrating the files.
Outlook PST and OST files that are created by using Microsoft Office Outlook 2003 and later use the updated Unicode file format that allows larger file sizes (the 2 gigabyte limit is eliminated). The data file format used by Outlook 2002 and earlier is also supported by Office Outlook 2007.
There is no tool available to convert groups of previous PST and OST files to the newer format, but you can provide a procedure to your users for individual file update. The steps to convert data files are provided in Convert a non-Unicode data file (.pst) to a Unicode data file (.pst) (https://go.microsoft.com/fwlink/?LinkId=88147).
You can also configure settings that ensure that new files are created in the more current format. For more information about configuring and working with Unicode Outlook data files, see Configure Unicode options in Outlook 2007.
Access 2007
This section describes the differences between the new Microsoft Office Access 2007 ACCDB file format and the earlier-version MDB file format. In Office Access 2007, the Microsoft Jet database engine (Microsoft Jet database engine: The part of the Access database system that retrieves and stores data in user and system databases. It can be thought of as a data manager upon which database systems, such as Access, are built.) has been customized for 2007 Microsoft Office system applications. This Office-specific version of Jet, called the Access Database Engine, enables integration with Microsoft Windows SharePoint Services 3.0 and Microsoft Office Outlook 2007, creation of multivalued lookup fields, and other improvements.
New features of the Office Access 2007 file format
Multivalued 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, then revise your forms and reports to use the new data structure. In Office Access 2007, this is made much easier by implementing a multivalued 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 Microsoft 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 Microsoft Windows SharePoint Services 3.0 and Microsoft Office Outlook 2007 In the past, Access files have been blocked from Windows SharePoint Services 3.0 and Office Outlook 2007 due to the fact that 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 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).
File extensions
Office Access 2007 introduces a few new file extensions:
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 Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) source code removed. A user of an ACCDE file can only execute VBA code, not modify it. ACCDE takes the place of the MDE file extension.
ACCDT The file extension for Access Database Templates.
ACCDR ACCDR is a new file extension that enables you to open a database in runtime mode. By simply changing a database's file extension from .accdb to .accdr, you can create a "locked-down" version of your Office Access 2007 database. You can change the file extension back to .accdb to restore full functionality.
Workgroup Information Files (MDW)
Workgroup Information Files store information for secured databases. No changes have been made to the .mdw file format for Office Access 2007. The Office Access 2007 Workgroup Manager will create .mdw files that are identical to those created in Access 2000 through Access 2003, and .mdw files created in those earlier versions can be used by Office Access 2007 databases.
Locking files
When a database is opened, file locking is controlled by a locking file. When you open an .mdb file, Access creates and opens an .ldb locking file. This is true even if you use Office Access 2007 to open an .mdb database file. For example, if you open the file Db1.mdb, Access creates and opens a file named Db1.ldb — this .ldb file controls locking. For files created in the Office Access 2007 file format (.accdb files), Access controls locking by creating and opening a file with a file name extension of .laccdb. For example, if you open Db1.accdb, Access creates and opens a locking file named Db1.laccdb. As with .ldb files, .laccdb files are deleted automatically when the database has been closed by all users.
By maintaining separate locking files for Office Access 2007 files and for files created in earlier versions of Access, it is possible to have both Db1.mdb and Db1.accdb open in Office Access 2007 at the same time without creating any conflicts in the locking file, because two different locking files are created. It is possible to have the same .mdb file open in Office Access 2007 and in an earlier version of Access at the same time, with both versions using the same .ldb locking file.
ACCDE files
An .accde file is the Office Access 2007 version of the .mde file in earlier versions of Access. It is a locked-down version of the original .accdb file. If the .accdb file contained any VBA code, only the compiled code is included in the .accde file — as a result, the VBA code cannot be viewed or modified by the user. Also, .accde file users do not have permissions to make design changes to forms or reports. You create .accde files from .accdb files by using the following procedure:
Create an ACCDE file in Office Access 2007
In Office Access 2007, open the database you want to save as an .accde file.
On the Database Tools tab, in the Database Tools group, click Make ACCDE.
In the Save As dialog box, browse to the folder in which you want to save the file, type a name for the file in the File name box, and then click Save.
Linked tables
You can link a table from an earlier Access format to a database in a later version of Access, but you cannot link a table from a later version of Access to a database in an earlier version of Access. For example, you can link from an .accdb database to tables in another .accdb database, or to tables in an .mdb database; but you cannot link from an .mdb database to tables in an .accdb database.
Replication
Replication is not supported in the Office Access 2007 file format. You can use Office Access 2007 to replicate a database that was created in older file format, but not one that was created in the Office Access 2007 format.
Project 2007
You can open and save project files in the following file formats. Some formats allow you to save all the information in your project, and some formats allow you to save only the data contained in Project fields.
| Format | Extension | Description |
|---|---|---|
Microsoft Project Plan (MPP) |
The standard file format for a project, which uses the .mpp extension. |
|
Microsoft Project 2000-2003 file |
The standard file format for a project, which uses the .mpp extension. Microsoft Office Project 2007 supports opening from and saving to the file format used by Microsoft Project 2000-2002 and Microsoft Office Project 2003. |
|
Microsoft Project 98 file |
The standard file format for a project, which uses the .mpp extension. Microsoft Office Project 2007 supports opening from the Microsoft Project 98 file format. |
|
Microsoft Project Template (MPT) |
This is a template file in which you can save boilerplate information. This format uses the .mpt extension. The global file (Global.mpt) is a master template file that can contain formatting information for all projects but it cannot store tasks, resources, or assignments. |
|
Microsoft Project Exchange (MPX) |
An ASCII format used with project management and various other programs that support MPX 4.0. This format uses the .mpx extension. Microsoft Project 4.0, Microsoft Project 4.1, and Microsoft Project 98 use the MPX 4.0 file format. In Microsoft Project 2000-2002 and Microsoft Office Project, you cannot save project information to this file format. |
|
Microsoft Excel |
A format used by the Microsoft Office Excel spreadsheet program. This format uses the .xls extension. You can export field data to this format, but you cannot export an entire project. |
|
Microsoft Excel PivotTable |
A format used by the Microsoft Office Excel spreadsheet programs for a PivotTable report. You can export field data to this format, but you cannot export an entire project. You can only export to an Excel PivotTable report. You cannot import data from an Excel PivotTable report into Project. |
|
Microsoft Project Database (MPD) |
A database format used by Project for storing entire projects. This format uses the .mpd extension. You cannot save to the MPD format using Microsoft Office Project 2007, but you can open projects that are stored in MPD files. |
|
Microsoft Access Database (MDB) |
A database format used by the Microsoft Office Access database program, which uses the .mdb extension. You cannot save to the MDB format using Microsoft Office Project 2007, but you can open projects that are stored in MDB files. |
|
Open Database Connectivity (ODBC) |
A format used by ODBC-compliant Microsoft SQL Server databases. You cannot save to the ODBC format using Microsoft Office Project 2007, but you can open projects that are stored in ODBC files. |
|
Text-only or ASCII |
Text-only or ASCII format is a generic text format used by word-processing and other programs. This format uses the .txt extension and is tab delimited. You can export field data from a single Project table to this format, but you cannot export an entire project. |
|
Comma-separated values (CSV) |
Comma-separated values (CSV) is a generic text format used with word-processing and other programs. This format uses the .csv extension and is comma delimited, where values are separated by the system list separator. You can export field data from a single Project table to this format, but you cannot export an entire project. |
|
Extensible Markup Language (XML) |
Extensible Markup Language (XML) is a format used to deliver rich, structured data in a standard, consistent way. This format uses the .xml extension. You can export and import project data with this format. Like the MPX format used in older versions of Project, the XML format can be used to interchange project data between Project and other programs. |