Skip to content Skip to sidebar Skip to footer

Export Gantt Chart From Ms Project To Excel

Microsoft Project is a project management software that is used by many businesses and organizations around the world. It is used to plan, track, and manage projects of all sizes. One of the most useful features of Microsoft Project is the ability to create Gantt charts. Gantt charts are an important tool for project managers as they provide a visual representation of a project's schedule. However, sometimes it is necessary to export the Gantt chart from Microsoft Project to Excel. This article will guide you through the process of exporting a Gantt chart from Microsoft Project to Excel.

Step 1: Open Microsoft Project

Microsoft Project Logo

The first step in exporting a Gantt chart from Microsoft Project to Excel is to open Microsoft Project. You should have a project file already created with a Gantt chart. If you do not have a project file, you will need to create one first.

Step 2: Click on the Gantt Chart

Microsoft Project Gantt Chart

Once you have opened your project file, click on the Gantt chart. This will select the Gantt chart and make it the active view.

Step 3: Click on File

Microsoft Project File Menu

Next, click on the File menu in the top left corner of the screen. This will open a drop-down menu with several options.

Step 4: Click on Save As

Microsoft Project Save As

From the drop-down menu, click on Save As. This will open a new dialog box with several options.

Step 5: Choose Excel Workbook

Microsoft Project Save As Excel

In the Save As dialog box, choose Excel Workbook from the Save as type drop-down menu. This will save the Gantt chart as an Excel file.

Step 6: Choose a Location and Name for the File

Microsoft Project Save As Location

Choose a location and name for the Excel file. You can save the file in any location on your computer and give it any name you like.

Step 7: Click on Save

Microsoft Project Save

Finally, click on the Save button to export the Gantt chart from Microsoft Project to Excel. The file will be saved in the location and with the name you specified.

Conclusion

Exporting a Gantt chart from Microsoft Project to Excel is a simple process that can be completed in just a few steps. By following the steps outlined in this article, you can easily export a Gantt chart from Microsoft Project to Excel and use it to track and manage your project more effectively.

Related video of Export Gantt Chart From Ms Project To Excel