Export or import data to another file format

The Export Wizard and Import Wizard help you to transfer project data between Microsoft Office Project 2007 and other programs. These wizards provide instructions for placing exported or imported data in the appropriate destination fields. By defining or editing the export or import maps of these wizards, you can easily transfer data to and from the task, resource, or assignment fields that you want. After you define the export or import maps, you can export or import data.

What do you want to do?

Export project information

Import project information

Export project information

You can export information from Office Project 2007 to another format, such as Microsoft Office Excel (as a workbook or PivotTable report), text-only (tab delimited), comma-separated values (CSV), or Extensible Markup Language (XML).

1. On the File menu, click Save As.

2. In the Save as type box, select the file format that you want to export data to.

3. In the File name box, type a name for the exported file.

4. Click Save.

   Note: You can export only an entire project to XML format. Project 2007 maps the data automatically, without the Export Wizard. Also, to minimize the file size, fields that contain null values are not included in the exported XML file.

5. Follow the instructions in the Export Wizard to export the data that you want into the proper fields of the destination file.

6. When the wizard prompts you to create a new map or use an existing one, do one of the following:

   • Click New map to create a new export map from scratch.

   • Click Use existing map to use a default map or a map that you previously defined and saved.

7. On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Export Wizard, verify or edit the mapping assumptions of Project 2007, or create a new map:

   • To export specific project information, type or select the field that you want in the From column, and then press ENTER.

   • To add all task, resource, or assignment fields in your project to the export map, click Add All.

   • To add all task or resource fields of a specific table to the export map, click Base on Table. Click the table you want to use, and then click OK.

   • To remove all task, resource, or assignment fields from an export map, click Clear All.

   • To insert a new field above another field, click a field in the From column, and then click Insert Row.

   • To delete a field, click it in the From column, and then click Delete Row. To change the name of the field in the destination file, click the field in the To column, and then type a new name.

     Tip: On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Export Wizard, under Preview, you can review the layout of the export map.

8. To export certain tasks or resources only, click the filter that you want in the Export filter box.

9. If you want to change the order of the fields in the destination file, click a field in the To column, and then click the Move buttons to move the field to the position that you want.

10. On the last page of the Export Wizard, click Finish to export your data.

    Tip: You can save a new or edited export map if you want to use it again. On the last page of the Export Wizard, click Save Map, and then type a name in the Map name box. The new map will be added to the list of predefined maps.

Note: 

• You can use an existing export map from another project if the map is available in the global file. By using the Organizer, you can copy an export map from a project file to the global file.

• When you create an export map to save data to either CSV file format or TXT file format and you set the text delimiter, the delimiter, not the file extension, controls the file type. For example, if you save to a file named Myproject.csv but you specified a tab delimiter in the map, the CSV file will have tabs instead of commas, even though the file extension indicates commas.

Top of Page

Import project information

You can import information into Microsoft Office Project 2007 by using any entered field from another product's file format, such as Microsoft Office Excel, Microsoft Office Access, Extensible Markup Language (XML), comma-separated values (CSV), or tab delimited text format.

1. Click Open  .

   If you are connected to Microsoft Office Project Server 2007, click Open from File.

2. In the Files of type box, click the file type that you want to import data from.

3. In the Look in box, locate the folder that contains the file you want to import, and then select the file in the file list.

4. Click Open.

5. Follow the instructions in the Import Wizard to import the data that you want into the proper Project 2007 fields.

6. On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Import Wizard, verify or edit the mapping assumptions of Project 2007:

   • To import the data from a field in the source file to a different Project 2007 field, click the field in the To column, select a new field, and then press ENTER.

   • To change the name of a field in the destination file, click the field in the To column, and then type a new name.

   • To delete a field, click it in the From column, and then click Delete Row.

   • To insert a new field above another field, click a field in the From column, and then click Insert Row.

   • To remove all task, resource, or assignment fields from an import map, click Clear All.

   • To add all task, resource, or assignment fields of the destination file to the import map, click Add All.

     Tip: On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Import Wizard, under Preview, you can preview the layout of the import map.

7. If you want to change the order of the fields in the destination file, click a field in the To column, and then click the Move buttons to move the field to the position that you want.

8. On the last page of the Import Wizard, click Finish to import your data.

   Tip: You can save a new or edited import map if you want to use it again. On the last page of the Import Wizard, click Save Map, and then type a name in the Map name box. The new map will be added to the list of predefined maps.

Note: 

• You can use an existing import map from another project if the map is available in the global file. By using the Organizer, you can copy an import map from a project file to the global file.

• When you create an import map to incorporate data from either CSV file format or TXT file format and you set the text delimiter, the delimiter, not the file extension, controls the file type. For example, if you import a file named Myproject.csv but you specified a tab delimiter in the map, the CSV file will have tabs instead of commas, even though the file extension indicates commas.

• Although you can enter values in some calculated fields, Project 2007 may recalculate these values, either automatically or when you specify.

• Project 2007 can import only XML data that can be validated against its data interchange schema.

• If you import information from another file format into an enterprise project that requires you to enter specific information for tasks, you won't be able to save the project until all required information is entered.

• Resource cost fields cannot be updated in an enterprise project. You can import resource cost information only in nonenterprise projects or for nonenterprise resources in a project.

Top of Page