Export or import data to another file format

You can export (exporting: Transferring data from Project to another program, such as Excel. When you export data, you choose or create a map that specifies the relationship between the fields in Project and the columns in the ouptut file.) information from Microsoft Project to another format using a wizard. The following is a list of formats you export to or import from.

By defining or editing the export or import maps (export/import map: A set of instructions that maps out for Project exactly what types of data you want to export or import, in what order, and their field names in the destination format. Project comes with default export/import maps.) of these wizards, you can easily transfer data to and from the task (task: An activity that has a beginning and an end. Project plans are made up of tasks.), resource (resources: The people, equipment, and material that are used to complete tasks in a project.), or assignment (assignment: A specific resource that is assigned to a particular task.) fields that you want.

What do you want to do?


Export project information

  1. Click the File tab, and then 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.
  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.
  1. On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Export Wizard, verify or edit the mapping assumptions of Project, 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 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.
  1. To export certain tasks or resources only, click the filter that you want in the Export filter box.
  2. 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.
  3. On the last page of the Export Wizard, click Finish to export your data.

 Notes 

Top of Page Top of Page

Import project information

You can import (importing: Transferring data into Project from a source program, such as Excel. When you import data, you choose a map that defines how the data in the source program should be mapped to information in Project.) information into Project by using any entered field (entered field: A field in which you may type or edit information. This is in contrast with a calculated field, in which Project calculates and enters information.) from another product's file format (file format: The particular way in which information is stored in a file. Different programs use different file formats and file name extensions to indicate the format.), such as Microsoft Office Excel, Microsoft Office Access, Extensible Markup Language (XML) (XML: Extensible Markup Language [XML] is a format for delivering rich, structured data from an application in a standard, consistent way. XML describes the content of a document, whereas HTML tags describe how the document looks.), comma-separated values (CSV) (CSV: The comma-separated values [CSV] file format is an ASCII, record-based text format in which each field is separated by a list-separator character, usually a comma or semicolon. Each task or resource record ends with a carriage return and linefeed.), or tab delimited text format (tab delimited text format: A record-based ASCII text format in which each field of a task or resource record is separated by a list-separator character, usually a tab stop. Each task or resource record ends with a carriage return/line feed.).

  1. Click the File tab, and then click Browse.
  2. In the Files of type box, click the file type that you want to import data from.
  3. Navigate to 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 fields.
  6. On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Import Wizard, verify or edit the mapping assumptions of Project:
    • To import the data from a field in the source file to a different Project 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.

  1. 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.
  2. 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.

 Notes 

Top of Page Top of Page

 
 
Applies to:
Project 2010