Export your job to Excel
Project Online Desktop Client Project for the web Project Professional 2021 Project Standard 2021 Project Professional 2019 Project Standard 2019 Project Professional 2016 Project Standard 2016 Project Professional 2013 Project Standard 2013 Project 2010 Project Standard 2010 More … Less
When handling a job in Project for the web, you can export your job to Excel. Having your job information in an Excel file enables you to:
  • Send a file consisting of job information to external stakeholders

  • Create reports and visuals

  • Archive copies of your task information for audit and compliance

  • Print copies of your job

Here’s how to export your task:

  1. Go to project.microsoft.com and open the job you wish to export to Excel.

  2. In the leading right corner, choose the 3 dots (), then choose Export to Excel

    Screenshot of the menu in Project for the web showing the Export to Excel option

  3. When you see the message “ All done! We’ve exported [your job name]” at the bottom of the screen, you can try to find your brand-new Excel file where you keep your downloads.

When you open the Excel file including your job, you’ll see a tab called “Project jobs” which contains a summary of project-wide info at the top, including its name, job supervisor, and the start and surface dates, period, and percent total for the entire job. You’ll likewise see what date it was exported. Under that, you’ll see a table of all the details for your job.

While Project desktop has numerous integrated reports that let you provide all sortsof task information to your stakeholders, you can likewise export your job information to Excel for extensive information analysis and visual reporting. In Excel, you can produce PivotTable reports, charts, and utilize numerous other functions that assist you produce a more visual report.

You’ll need to map your task information for appropriate plan in Excel, however the Export Wizard will direct you along the method.

  1. Choose File > Export > Save Project as File, and under Other File Types, double-click Microsoft Excel Workbook

    9214b229 95eb 4b62 8382 9c2772defe18

    ( In Project 2010, select File > Save As, and beside Save as type, pick Excel Workbook)

  2. In the Save As dialog box, select an area for the workbook.

  3. In the File name box, type the name you desire, and pick Save

    The Export Wizard appears.

    f61c413b 19c7 455a 9298 c4503b4451a4