MICROSOFT PROJECT EXCEL TEMPLATE HOW TO

The main benefit is that once you have the vendor and your project activities defined in one integrated view, you can easily identify late tasks and analyze the critical path. Depending on the level of granularity required, you might just want the vendor’s key tasks and milestones instead of the entire project schedule. You can apply these same map concepts to other schedules that lack the Outline Level, but you’ll need to build the Outline Level manually. Applying imports to other project schedules Once the schedules are converted, I insert them as subprojects in the master project schedule.īefore I came up with this solution, I would import the schedule as a new project I ran into calculation issues because the % Complete field is a calculated field and didn’t consistently convert.

The end result is a properly formatted Microsoft Project file that contains the vendor’s project schedule. Click Next and leave Selected Data as the option.Select the Microsoft Excel Workbook (*.xls) as the Save as Type and click Save.(It helps if you have a completed project schedule so the final export will have meaningful data.) Open a sample Microsoft Project schedule.Identifies the Task ID of a predecessor task An Outline Level of 1 is at the highest level in the hierarchy, and an Outline Level of 5 has four summary level tasks above it. The Task ID for the Microsoft Project taskĭetermines the Outline Level in a project’s hierarchy. My solution was to develop an import map that includes the key fields in the table below Field Name When you import an Excel file into Microsoft Project, it also lacks any of the indenting (Figure 1) and summary tasks that make Microsoft Project a valuable roll-up tool. Creating the hierarchy in Excel usually involves grouping and indenting in Excel or using a custom macro to build the hierarchy. When you export data from Microsoft Project into Excel, the data file doesn’t maintain the hierarchy. Faced with the poor usability in scanning hundreds of tasks using Excel, I developed an import map that will properly import the Excel sheet that builds the task hierarchy in Microsoft Project. Ironically, my vendor extracts this information from his Microsoft Project schedule and provides an Excel file that I can scroll through to find key milestones and due dates. In my case, I typically receive an Excel file with tasks and start and finish dates. If you’ve worked with outsourcing vendors, then you’re familiar with some vendors who don’t consistently use Microsoft Project as a scheduling tool. The obvious solution is to have the vendor provide its Microsoft Project schedule the reality is some vendors are reluctant to hand over their detailed schedule because it contains cost data, notes, custom macros, and other private data. One challenge in jointly delivering a project with an external vendor is obtaining the vendor project schedule in a format that can be integrated with Microsoft Project.

MICROSOFT PROJECT EXCEL TEMPLATE HOW TO

The following is a brief tutorial on how to import an Excel spreadsheet project schedule into Microsoft Project.įor the past four years, I’ve worked for companies that outsource the majority of their IT work to external vendors using fixed-price contracts.

In other cases, it is a set of dates described in an email or it is developed in every non-MS Project user’s favorite tool – Excel or a spreadsheet variant. In some cases, it is a formal MS Project schedule. If you’ve worked with external vendors for any length of time, I’m sure you’ve noticed the variety of formats vendors use for a project schedule.

Microsoft project excel template