Export MS Project in HTML

%3CLINGO-SUB%20id%3D%22lingo-sub-3339624%22%20slang%3D%22en-US%22%3EExport%20MS%20Project%20in%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3339624%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20often%20have%20a%20need%20to%20export%20tasks%20from%20MS%20Project.%20I%20end%20up%20doing%20a%20copy-paste%20into%20excel%2C%20but%20that%20takes%20away%20the%20ability%20to%20collapse%20the%20summary%20tasks.%20It%20becomes%20a%20flat%20structure%20file.%20Plus%2C%20it%20does%20not%20exports%20the%20gantt%20chart.%20Another%20alternative%20is%20to%20export%20%2F%20print%20as%20pdf%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20am%20wondering%20if%20there%20is%20a%20better%20way%20to%20export%20in%20HTML%20where%20collapsing%20summary%20tasks%20can%20be%20preserved%20and%20the%20user%20can%20expand%20%2F%20collapse%20summary%20tasks.%20Better%20still%20gantt%20chart%20can%20also%20appear%20on%20html%20export.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20related%20question%20is%20whether%20Timeline%20can%20be%20exported%20in%20HTML%20%3F%3C%2FP%3E%3CP%3EI%20have%20few%20parent%20level%20timeline%20task%20and%20a%20few%20child%20tasks%20of%20every%20parent%20task%20also%20added%20to%20timeline.%20Displaying%20all%20of%20these%20parent%20child%20tasks%20on%20timeline%20clutters%20the%20timeline.%20I%20was%20thinking%20whether%20there%20is%20a%20way%20to%20export%20timeline%20as%20HTML%20file%20with%20parents%20tasks%20have%20a%20little%20%2B%20displayed%2C%20which%20upon%20clicking%20shows%20the%20child%20tasks%20on%20timeline.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3340099%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20MS%20Project%20in%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3340099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1370364%22%20target%3D%22_blank%22%3E%40NKumar2010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20know%20you%20won't%20find%20anything%20in%20the%20Microsoft%20suite%20of%20applications%20that%20does%20what%20you%20want%20but%20a%20quick%20web%20search%20finds%20several%20third-party%20applications%20that%20claim%20to%20do%20what%20you%20need%2Fwant.%20You%20might%20want%20to%20check%20that%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20a%20basic%20export%20of%20Project%20field%20data%20to%20Excel%2C%20there%20are%20better%20ways%20than%20copy%2Fpaste.%20The%20first%20is%20an%20export%20map%20but%20one%20thing%20an%20export%20map%20will%20not%20do%20is%20to%20preserve%20the%20full%20content%20of%20extended%20text%20in%20Project's%20Notes%20field.%20To%20work%20around%20that%20limitation%2C%20several%20years%20ago%20I%20wrote%20a%20macro%20for%20exporting%20Project%20data%20to%20Excel.%20You%20can%20check%20it%20out%20in%20this%20Wiki%20article%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F32126.ms-project-troubleshooting-truncated-project-notes-when-viewingexporting.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F32126.ms-project-troubleshooting-truncated-project-notes-when-viewingexporting.aspx%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20as%20you%20already%20noted%2C%20the%20spreadsheet%20in%20Excel%20is%20a%20flat%20file.%20In%20order%20to%20include%20a%20feature%20to%20allow%20expanding%2Fcollapsing%20summary%20levels%20a%20macro%20in%20Excel%20is%20required.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

  I often have a need to export tasks from MS Project. I end up doing a copy-paste into excel, but that takes away the ability to collapse the summary tasks. It becomes a flat structure file. Plus, it does not exports the gantt chart. Another alternative is to export / print as pdf, 

        I am wondering if there is a better way to export in HTML where collapsing summary tasks can be preserved and the user can expand / collapse summary tasks. Better still gantt chart can also appear on html export. 

 

Another related question is whether Timeline can be exported in HTML ?

I have few parent level timeline task and a few child tasks of every parent task also added to timeline. Displaying all of these parent child tasks on timeline clutters the timeline. I was thinking whether there is a way to export timeline as HTML file with parents tasks have a little + displayed, which upon clicking shows the child tasks on timeline. 

 

Thanks, 

1 Reply

@NKumar2010 

As far as I know you won't find anything in the Microsoft suite of applications that does what you want but a quick web search finds several third-party applications that claim to do what you need/want. You might want to check that out.

 

As far as a basic export of Project field data to Excel, there are better ways than copy/paste. The first is an export map but one thing an export map will not do is to preserve the full content of extended text in Project's Notes field. To work around that limitation, several years ago I wrote a macro for exporting Project data to Excel. You can check it out in this Wiki article:

https://social.technet.microsoft.com/wiki/contents/articles/32126.ms-project-troubleshooting-truncat...

 

But, as you already noted, the spreadsheet in Excel is a flat file. In order to include a feature to allow expanding/collapsing summary levels a macro in Excel is required.

 

John