In your browser
- Open the MPP Viewer.
- Drop your .mpp, .mpx or Project .xml file on the page. The Gantt chart and the full task table appear free, so you can check the plan first.
- Click Excel. The first time it asks for a license: $19 once, then Excel, CSV and PDF exports work in that browser for every project you open.
What's in the spreadsheet
- Tasks: ID, WBS code, task name indented by level with outline grouping you can collapse, duration, start, finish, % complete, predecessors, resources, milestone and critical flags, baseline dates and notes.
- Resources: the people and materials in the plan.
- Assignments: who works on which task, with units and work.
Dates come through as real Excel dates, so sorting and filtering by start or finish works straight away.
CSV instead
For Google Sheets, Smartsheet, Jira or another tool's importer, the CSV button saves the task table as a plain CSV file. Same license.
With Microsoft Project
If someone near you has Project, File, Save As, Excel Workbook runs an export wizard where you choose and map the fields yourself. It's the right choice if you have Project to hand.
Going back to Project
The Excel file is a copy for reading and reporting. Changes you make in it don't flow back into the .mpp.