MS Project - Export projects with WBS to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-987930%22%20slang%3D%22en-US%22%3EMS%20Project%20-%20Export%20projects%20with%20WBS%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-987930%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20MS%20Project%202016%20(Web)%2C%20is%20it%20possible%20to%20export%20all%20the%20projects%20in%20the%20project%20center%20along%20with%20the%20WBS%2C%20baseline%20start%20%26amp%3B%20end%20dates%2C%20actual%20start%20%26amp%3B%20end%20dates%20etc%3F%20I%20need%20this%20data%20to%20prepare%20a%20report%20and%20it%20is%20a%20bit%20urgent.%20Any%20help%20is%20appreciated.%20As%20of%20now%20I%20am%20able%20to%20export%20the%20projects%20to%20excel%20from%20project%20center%20and%20I%20am%20able%20to%20export%20the%20WBS%20under%20each%20project%20to%20excel%20individually.%20What%20I%20want%20to%20achieve%20is%20export%20the%20projects%20and%20WBS%20together%20in%20one%20excel%20file.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-992183%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Project%20-%20Export%20projects%20with%20WBS%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-992183%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F447565%22%20target%3D%22_blank%22%3E%40vikneswaran365%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20using%20Project%20Server%202016%20(sounds%20like%20you%20might%20be)%2C%20you%20could%20create%20a%20report%20in%20Excel%20that%20pulls%20back%20the%20data%20you%20need.%20This%20could%20either%20be%20from%20the%20OLAP%20cube%2C%20the%20Project%20Data%20Reporting%20API%20or%20from%20the%20Project%20Reporting%20schema%20in%20the%20SQL%20database.%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fproject%2Fplanning-project-server-and-project-online-for-technical-decision-makers%23business-intelligence-in-project-server-and-project-online%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fproject%2Fplanning-project-server-and-project-online-for-technical-decision-makers%23business-intelligence-in-project-server-and-project-online%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

Hello All,

 

I am using MS Project 2016 (Web), is it possible to export all the projects in the project center along with the WBS, baseline start & end dates, actual start & end dates etc? I need this data to prepare a report and it is a bit urgent. Any help is appreciated. As of now I am able to export the projects to excel from project center and I am able to export the WBS under each project to excel individually. What I want to achieve is export the projects and WBS together in one excel file. Thank you.

1 Reply
Highlighted

Hello @vikneswaran365 ,

If you are using Project Server 2016 (sounds like you might be), you could create a report in Excel that pulls back the data you need. This could either be from the OLAP cube, the Project Data Reporting API or from the Project Reporting schema in the SQL database. https://docs.microsoft.com/en-us/project/planning-project-server-and-project-online-for-technical-de...

Paul