how to export from ms project to excel

Export MS Project to Excel: A Comprehensive Guide

By Kevin Davis
AD

Exporting data from Microsoft Project (MS Project) to Excel can streamline your project management, allowing you to analyze and manipulate data with Excel's powerful tools. Here's a step-by-step guide on how to achieve this efficiently.

Before we dive into the process, ensure you have both MS Project and Excel installed on your computer. The procedure outlined here mainly applies to the desktop versions of these applications.

Preparing Your Data in MS Project

Before exporting, organize your project data to ensure a smooth transition to Excel. Hide any columns you don't need, and sort or filter data to your preference.

AD
the settings dialog box in windows xp with options to select file formats and type
the settings dialog box in windows xp with options to select file formats and type
Create a hyperlink to another worksheet in the same workbook
Create a hyperlink to another worksheet in the same workbook
10 Powerful Excel Project Management Templates for Tracking Anything
10 Powerful Excel Project Management Templates for Tracking Anything

To do this, click on the 'View' tab, then 'Data', and select 'Filter' to apply filters. For sorting, click on the column header and choose 'Sort & Group', then 'Sort'.

Selecting the Data to Export

Choose which data to export by selecting the relevant columns or rows. To select columns, click and drag on the row numbers at the top of the worksheet. For rows, click and drag on the column letters at the left.

a screenshot of a project schedule with multiple tasks in the workflow diagram below
a screenshot of a project schedule with multiple tasks in the workflow diagram below
Ms excel excersices
Ms excel excersices

You can also select data by holding 'Ctrl' and clicking on individual cells, or by drawing a marquee around the area.

Exporting Data to Excel

With your data selected, click on the 'File' tab, then 'Export', and choose 'Change File Type'. From the list, select 'Single File Web Page' (.mht) or 'Excel'.

AD

If you choose 'Single File Web Page', an HTML and related files will be created. If you select 'Excel', an Excel workbook (.xlsx) will be generated.

Importing Data into Excel

If you've exported your MS Project data as an HTML (.mht) file, you'll need to import it into Excel. First, open Excel, then click on the 'Data' tab, and select 'Get Data' from the 'Get & Transform Data' group.

Choose 'From Web' and enter the path to your .mht file. Click 'OK', then 'Load'. The data will be imported into Excel as a table, which you can convert to a range by clicking 'Close & Load' or 'Load to'.

AD

Working with the Data in Excel

Once your data is in Excel, you can utilize its various features to analyze and format the data. Use sorting and filtering tools, create pivot tables, or apply conditional formatting.

To copy the data to a new worksheet or workbook, select the table, click 'Home', then 'Format as Table'. In the 'Create Table' dialog box, ensure the data range is correct, then click 'OK'. With the table selected, click 'Home', then 'Copy', then 'Paste' into the new location.

Mastering the export from MS Project to Excel lets you take full advantage of Excel's capabilities, helping you make informed decisions about your projects. Happy exporting!

AD
AD