To create a complete Excel workbook of project information from your project file, follow these steps:ġ In Microsoft Project, open the project whose information you want to export to Excel.ģ Browse to the drive and folder where you want to save your information.Ĥ In the Save As File Type list, click Microsoft Excel Workbook (*.xls).ĥ In the File Name box, enter a name for the Excel file and then click Save.Ħ On the Export Wizard Welcome page, click Next.ħ On the Data page, click Project Excel Template and then click Finish. With this method, Microsoft Project organizes data into Task, Resource, and Assignment data types, which in turn are presented in their own separate worksheets in the single Excel workbook. You can export more complete information about tasks, resources, and assignments.
