In this blog post, I’m going to walk you through how to export a Microsoft Project schedule into a Microsoft Excel workbook and clean it up so it looks executive-ready before you send it to a client or project sponsor.
Companion Articles in This Reports, Timelines, Excel & Printing Series: Explore these connected tutorials in the same topic area to build your skills step by step:
- Current Article (You Are Here): How to Export Microsoft Project to Excel
- Companion Tutorial: How to Print a Project Schedule in Microsoft Project (Including 1-Page Printing)
- Companion Tutorial: How to Export Your Microsoft Project Schedule to a PDF File
- Companion Tutorial: How to Create Multiple Project Timelines in Microsoft Project
- Full Topic Hub: Browse All Reports, Timelines & Printing Tutorials →
At a Glance: How to Export Microsoft Project to Excel:
- Applies to: Microsoft Project Standard, Project Professional, and Project Server / Project Online Desktop Client (with desktop Microsoft Excel installed).
- Step 1: Click File → Export → Save Project as File → Microsoft Excel Workbook and click Save As to launch the Export Wizard.
- Step 2: On the Task Mapping page, click Base on Table…, select Entry, remove internal columns (
Indicators,Task Mode,Predecessors), add% CompleteandNotes, and click Save Map… (_Client Export to Excel). - Step 3: In Excel, convert
% Completetext strings to numbers, strip8:00 AMand5:00 PMtimestamps usingCtrl + HFind & Replace, and format dates asmm/dd/yyyy.
Need hands-on help with your schedule? Explore my $399 Microsoft Project Desktop Course, Project Server Training, or book 1-on-1 Private Training & Consulting.
Step 1: How Do I Launch the Microsoft Project Export Wizard?
To export your Microsoft Project schedule into a Microsoft Excel workbook:
- Click the File tab to open the Backstage view, then click Export on the left menu.
- Click Save Project as File, select Microsoft Excel Workbook, and click the Save As button.
- Choose your destination folder, name your Excel file, and click Save to launch the Export Wizard:
- Welcome Page: Click Next.
- Data Page: Leave Selected Data chosen and click Next.
- Map Page: Select New map (the first time you build this export) and click Next.
- Map Options Page: Check Tasks and click Next.
Step 2: How to Use “Base on Table” to Map Columns Fast
On the Task Mapping page, selecting every Microsoft Project field one at a time from scratch is way too much work. Instead, start from an existing table:
- Click the Base on Table… button in the lower-right area of the dialog.
- Select Entry from the table list and click OK. This automatically populates all standard columns from the Entry table (
ID,Indicators,Task Mode,Name,Duration,Start_Date,Finish_Date,Predecessors, andResource_Names). - Delete Unneeded Columns: Your client doesn’t need internal scheduling mechanics. Select
Indicators,Task Mode, andPredecessors, and click Delete Row for each. - Insert Client-Friendly Columns:
- Select the
Durationrow, click Insert Row, and choose% Completeso progress appears right next to the Task Name. - At the bottom of the list, click the first blank row and choose
Notesso task commentary exports as well.
- Select the
Step 3: How Do I Save a Reusable Export Map for Future Reports?
Before clicking Finish on the final page of the Export Wizard:
- Click the Save Map… button.
- Name your map
_Client Export to Excel(starting the name with an underscore_forces your custom map to the very top of the alphabetical map list!). - Click Save, and then click Finish.
Next week, when you need to send an updated Excel report, simply choose Use existing map in the wizard, select _Client Export to Excel, and click Finish!
Step 4: How Do I Clean Up the Exported Excel File for Stakeholders?
Just between you and me, I would never hand the raw exported Excel workbook to a client as-is, percentages export as text strings, and dates include unsightly timestamps. Use these four fast cleanup steps in Excel:
1. Best-Fit Columns, Bold Headers, and Label Row 0
Click the Select All triangle in the upper-left corner of the worksheet and double-click any column boundary to auto-fit widths. Bold Row 1 (Ctrl + B), and if you display the Project Summary Task (ID 0), type Project Summary into its blank Task Name cell.
2. Convert % Complete from Text to True Percentages
Select all cells in the Percent_Complete column (Ctrl + Shift + Down Arrow), click the yellow warning diamond tooltip, select Convert to Number, and click the % button on the Home ribbon.
3. Strip 8:00 AM and 5:00 PM Timestamps from Start & Finish Dates
Select the Start_Date and Finish_Date columns and press Ctrl + H (Find and Replace):
* In Find what, press the Spacebar once and type 8:00 AM (8:00 AM). Leave Replace with blank and click Replace All.
* In Find what, press the Spacebar once and type 5:00 PM (5:00 PM). Leave Replace with blank and click Replace All.
4. Apply Clean Two-Digit Date Formatting (mm/dd/yyyy)
With the Start and Finish columns still selected, open the Number Format dialog, choose Custom, enter mm/dd/yyyy, and click OK.
Frequently Asked Questions
Can I export a visual Gantt Chart to PDF instead of Excel?
Yes! If your stakeholders want to see the visual Gantt bars rather than a spreadsheet table, read my step-by-step guide on How to Print a Project Schedule to PDF in Microsoft Project.
Where is my saved Export Map stored?
When you save an Export Map, Microsoft Project copies it automatically into your Global.mpt template file (File → Info → Organizer → Maps tab), so it is available in every project you open on your PC.
Ready to master Microsoft Project? If you found this article helpful, check out my free tutorials on my YouTube channel, download my Free Microsoft Project Quality Filters, or explore my structured, expert-led training courses and 1-on-1 coaching at dalehowardmvp.com.





Leave a Reply