Share via

Export MS Project online data into excel

Anonymous
2022-09-13T02:48:05+00:00

Hi There

I want to export MS Project online data into excel. My biggest concern is, I want to export Project summary task, Summary Tasks and tasks (WBS hierarchy levels) into separate columns as shown in attached picture below.

If anyone can help me with would be very much appreciated.

Thanks & Best Regards

Yeshi

Microsoft 365 and Office | Project | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Project 49,695 Reputation points Volunteer Moderator
    2022-09-13T15:05:26+00:00

    Yeshi,

    There are two ways to get what you want. The first is a laborious copy and paste with further manipulation in Excel. The second with with a VBA macro. If you want help with the latter, let me know.

    John

    0 comments
  2. Anonymous
    2022-09-14T01:21:47+00:00

    Thank you John, thank you very much… of course I would greatly appreciate if you could help me with that option.

    Thanks again & Best Regards

    Yeshi

    0 comments
  3. John Project 49,695 Reputation points Volunteer Moderator
    2022-09-14T01:58:40+00:00

    Yeshika Prince,

    It would be very helpful if I had your file to work with directly. Are you able to send it to me? If so, you can contact me at the address below. I will ask some questions.

    John

    jmacprojataticlouddotdotcom

    (remove obvious redundancies)

    0 comments