Others

How to Create an MS Project Template and Export Data to Excel

John WilsonJohn Wilson Oct 28, 2026 872 views

Question details

The user needs to export and import custom fields, task data, and resource availability between Microsoft Project and Excel to create an automated project template.

How to Create an MS Project Template with Custom Fields and Export to Excel
Product
Microsoft Project / Microsoft Excel
Device & OS
not provided
Scenario
Creating an automated project template by exporting and importing resource and task data between MS Project and Excel.
Observed behavior
Needs a reliable method to map custom fields, manage resource availability (Max. Units), and automate the data transfer process.
Before you start

Ensure you have the Developer tab enabled in MS Project to run VBA macros, and back up your project file before running any automated import/export scripts.

Solution 1Recommended

Use VBA and Project Import Maps to Automate Data Transfer

Create custom import/export maps in MS Project and use a VBA macro to automate the transfer of tasks and resource data to Excel.

Microsoft Project allows you to create custom maps to define exactly how fields are transferred to and from Excel. By recording a macro while executing these maps, you can automate the entire process for future templates.

1
Create a Custom Export Map

Open MS Project, go to File > Export > Save Project as File, and choose Microsoft Excel Workbook. In the Export Wizard, select 'Selected Data' and click 'New Map' to map your task and resource data fields.

2
Select Tasks and Resources

When configuring the map for importing or exporting, ensure you select both 'Tasks' and 'Resources' in the Import/Export Wizard.

3
Map the Entry Table and Resource Availability

For resources, choose the 'Entry' table. Ensure that resource availability (FTE) is mapped specifically to the 'Max. Units' field in MS Project.

4
Automate with a VBA Macro

Go to the Developer tab, click 'Record Macro', and run through your import/export map process manually. Stop recording, and you can now use this VBA code to export static or time-phased data to a new or existing project automatically.

Use VBA and Project Import Maps to Automate Data Transfer
Exporting Time-Phased Data: Custom VBA macros can be written to export time-phased Project data to Excel, allowing for more granular resource availability tracking over specific periods.
Free Microsoft Office alternative

Manage Your Exported Project Templates with WPS Spreadsheet

While Microsoft Project handles complex scheduling, you need a reliable spreadsheet tool to analyze your exported task data, custom fields, and resource availability. WPS Office provides a lightweight, highly compatible, and free alternative to Excel for all your project data management needs.

  1. 1. Download and Install: Download WPS Office for free and install it on your device.
  2. 2. Open Exported Data: Launch WPS Spreadsheet and open the .xlsx file you exported from Microsoft Project.
  3. 3. Analyze and Format: Use WPS Spreadsheet's formatting, formulas, and charts to review resource availability and task custom fields.
Fully compatible with Microsoft Excel (.xlsx) formats exported from MS ProjectLightweight application that opens large dataset files quicklyFamiliar user interface with zero learning curve for Excel usersBuilt-in pivot tables and charts for project resource analysis
microsoft office alternative - wps office

Frequently Asked Questions

How do I calculate task duration from resource units in MS Project?

In MS Project, task duration is calculated automatically based on the formula: Duration = Work / Assignment Units. When importing your Excel data, ensure your 'Max. Units' and 'Work' fields are mapped correctly so Project can recalculate the duration accurately.

What field in MS Project represents FTE or resource availability?

Resource availability, often referred to as Full-Time Equivalent (FTE), is represented by the 'Max. Units' column in Microsoft Project. You must map your Excel availability data to this specific field during the import process.

Can I use VBA to create a new project from an Excel template?

Yes, you can write a VBA macro in MS Project that reads an Excel file containing task and resource data, and uses that data to either update an existing project file or initialize a completely new project.