How to Export Microsoft Project to Excel

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:

How to Export Microsoft Project to Excel

YouTubeWatch the Step-by-Step Video

Prefer to follow along visually? This video demonstrates the exact steps you’ll learn below using Microsoft Project Desktop.

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 % Complete and Notes, and click Save Map… (_Client Export to Excel).
  • Step 3: In Excel, convert % Complete text strings to numbers, strip 8:00 AM and 5:00 PM timestamps using Ctrl + H Find & Replace, and format dates as mm/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:

  1. Click the File tab to open the Backstage view, then click Export on the left menu.
  2. Click Save Project as File, select Microsoft Excel Workbook, and click the Save As button.
  3. Choose your destination folder, name your Excel file, and click Save to launch the Export Wizard:
  4. Welcome Page: Click Next.
  5. Data Page: Leave Selected Data chosen and click Next.
  6. Map Page: Select New map (the first time you build this export) and click Next.
  7. 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:

  1. Click the Base on Table… button in the lower-right area of the dialog.
  2. 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, and Resource_Names).
  3. Delete Unneeded Columns: Your client doesn’t need internal scheduling mechanics. Select Indicators, Task Mode, and Predecessors, and click Delete Row for each.
  4. Insert Client-Friendly Columns:
    1. Select the Duration row, click Insert Row, and choose % Complete so progress appears right next to the Task Name.
    2. At the bottom of the list, click the first blank row and choose Notes so task commentary exports as well.

Step 3: How Do I Save a Reusable Export Map for Future Reports?

Before clicking Finish on the final page of the Export Wizard:

  1. Click the Save Map… button.
  2. 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!).
  3. 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

Your email address will not be published. Required fields are marked *

Are you human? Please solve:Captcha