A file format is an arrangement of data in a file that specifies the file type and defines the file in a way that enables any application that can open the file to open it correctly. When you create and save a regular project file, it’s saved as an MPP file. The file name’s .mpp extension indicates that this is indeed a regular project file.
However, you can save project files in other file formats. You can also open files with other file formats in Microsoft Project. Table 29-1 details the file formats supported by Microsoft Project for saving, opening, or both.
Table 29-1. Supported File Formats
File format | Extension | Open or Save | Notes |
---|---|---|---|
Microsoft Project Plan | .mpp | Open Save | Opens or saves the file as a Microsoft Project Plan file, which is the default file type for projects being opened or saved. |
Microsoft Project 2000-2003 Plan | .mpp | Open Save | Opens or saves the file as a Microsoft Project Plan file using the file format used by Microsoft Project 2000, 2002, and 2003. |
Microsoft Project 98 Plan | .mpp | Open | Opens a project file that was saved using the file format used by Project 98. |
Microsoft Project template | .mpt | Open Save | Opens a template file. You can change and save those changes to the template file. Saves the file as a Microsoft Project template file. The template can then be used as a basis for new projects. |
Microsoft Project workspace | .mpw | Open Save | Saves all open project files as a Microsoft Project workspace file through the File, Save Workspace command. When you open an MPW file, all associated projects are opened in a single step. |
Microsoft Project Exchange | .mpx | Open | Opens a file created in a version of Microsoft Project earlier than Microsoft Project 98. This is a record-based ASCII text file format that Project 2007 can read, allowing earlier Microsoft Project files to be converted to Project 2007 files. |
Microsoft Project database | .mpd | Open | Opens a legacy Microsoft Project database. |
Microsoft Access database | .mdb | Open | Opens a Microsoft Access database file in Microsoft Project. |
Open Database Connectivity | Open | Opens a database file created in ODBC-compliant Microsoft SQL Server databases. To open an ODBC file, click the ODBC button in the Open dialog box and follow the instructions in the Select Data Source dialog box. | |
Microsoft Excel workbook | .xls | Open Save | Opens, through the import process, an Excel workbook in Microsoft Project. Saves certain fields as a Microsoft Excel data so the file can then be opened in Microsoft Excel. |
Microsoft Excel PivotTable | .xls | Save | Saves selected field data to a Microsoft Office Excel PivotTable, which can then be opened in Microsoft Office Excel. A PivotTable is a table that combines and compares large amounts of data, and in which you can rotate columns and rows to modify the source data to create different views. |
Text (Tab delimited) | .txt | Open Save | Opens information in a plain text file that uses tabs to separate fields of data. Saves fields from a single Microsoft Project table in the same way. This is ideal for using the project information in a third-party application or on another operating system. |
Text (comma delimited) | .csv | Open Save | Opens a text file that uses commas to separate fields of data. Saves Microsoft Project data as a text file using commas to separate the data. This is ideal for using the project information in a third-party application or on another operating system. |
Extensible Markup Language | .xml | Open Save | You can open an XML file in Microsoft Project. For Microsoft Project to understand and open it, an XML file must conform to the Microsoft Project XML schema. You can also save a project file as XML data. When Microsoft Project saves data as XML, the structure is determined by the Microsoft Project XML schema. |
Opening a file from a different file format in Microsoft Project can be referred to as importing the file. Likewise, saving a project file with a different file format can be referred to as exporting the file. There’s often more to the import and export process than simply opening or saving the file. Often you need to create an import/export map.
For more information about creating an import or export map, see the section titled Importing and Exporting Information in Chapter 16.
18.225.95.245