Export data from MS Project Pro to MS Excel

Contents:

1. Export data from MS Project Pro to MS Excel
2. Chat

Export data from MS Project Pro to MS Excel

Steps to export data from MS Project Pro to MS Excel

1. Click the "File" item in the top menu.
2. Click the "Export" item in the left manu.
3. Click the "Save Project as File" button of the "Export" window.
4. Click the "Microsoft Excel Workbook" button in the "Other File Types" block.
5. Click the "Save as" button.

Steps to create a new template to export data from MS Project Pro to MS Excel:

1. Enter a name and location file in the "Save As" window.
2. Click the "Next >" button in the "Welcome" window.
3. Select the type of export template. If you would like to create your own template, click the "Select Data" button.
4. Click the "Next >" button.
5. Select the map. If you would like to create a new map, click the "New map" button.
6. Click the "Next >" button.
7. Select the type of project data in the "Select the type of date you want to export" block.
8. Click the "Next >" button.
9. If you want to export field header, click the "Export includes header" box.
10. If you want to export assignment data, click the "Include assignment rows in output" box.
11. Click the "Next >" button.

Steps create a new map:

1. Enter the worksheet name in the "Destiantion worksheet name:" filed.
2. Select the filter in the "Export filter:" field.
3. Set the project fields mame in the "From: Microsoft Project Field" field.
4. You an change excel fields name in the "To: Excel Field" filed.
5. You can see the data type in the "Data Type" field.
6. If you want to add all (tasks, resources, assigments) field, click the "Add All" button.
7. If you want to delete all field, click the "Clear All" button.
8. If you want to insert field, click the "Insert Row" button or click the "Insert" button on the keyboard.
9. If you want to delete field, select the field and click the "Delete Row" button or click the "Delete" button on the keyboard.
10. You can add field form the table. click the "Base on Table ..." button and select the table name from the list.
11. Click the "Next >" button.
12. You can save the map, click the "Save Map ..." button.
13. Enter the map name in the "Map name" field in the "Save Map" window.
14. Click the "Save" button in the "Save Map" window..
15. Click the "Finish" button.

You can see the export result in an excel file.

You can customize this file like any excel file.