How to Convert Microsoft Project to Microsoft Excel
Typically, Microsoft Office applications don't easily save to the native document types of other Microsoft Office applications. This is understandable, as Microsoft Office is packaged as a suite, so anyone who has Word, Excel or Powerpoint probably has all three applications. However, less-common Office programs, such as Microsoft Project, have some overlap with other applications in the types of files they produce. Since these applications are less common, Microsoft has provided more file type options so that someone using Project can save her file to an Excel format and share it with individuals not running the Project application.
Double-click on your Microsoft Project file.
Click "File" at the top of the screen (Project 2003 or earlier) or the Windows button in the top-left corner (Project 2007).
Choose the "Save As" option (Project 2003 or earlier) or "Save As," and then "Other file formats" (Project 2007).
Click the arrow for the drop-down menu next to "Save file type as" and select the "Microsoft Excel (.xls)" option.
Select the location for your saved file and change the name, if necessary. Click the "Save" button.
Tips & Warnings
- Project can only save one file at a time to the Excel format. If you need to save multiple reports, charts or timelines from one Project file, you must save each one individually.