Exporting Shared Column Reports - Excel | Community
Skip to main content
KierstenKollins
Community Advisor
Community Advisor
February 3, 2023
Solved

Exporting Shared Column Reports - Excel

  • February 3, 2023
  • 2 replies
  • 983 views

We love to use shared columns in our reports but need to be able to take the same format and export it into Excel. Has anyone been able to successfully export a report with shared columns into Excel or found any workarounds? Thank you in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Madalyn_Destafney

I've found the same experience, unfortunately. I think even if you are sharing columns in WF, they are still technically separate fields so therefore export as separate columns. Looks like there's an idea for this that I just upvoted, it could use some votes! 
https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/retain-simple-formatting-when-exporting-to-excel-such-as-having/idc-p/572162#M21385

2 replies

skyehansen
Community Advisor and Adobe Champion
February 6, 2023

this may be too fiddly but have you considered saving as a PDF and then converting the PDF to an excel? Otherwise, I would ping Doug Den Hoed.

KierstenKollins
Community Advisor
Community Advisor
February 6, 2023

Thank you for the suggestion. I tried it out and could not get it to work as I would have hoped for unfortunately. 😞

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity AdvisorAccepted solution
Community Advisor
February 7, 2023

I've found the same experience, unfortunately. I think even if you are sharing columns in WF, they are still technically separate fields so therefore export as separate columns. Looks like there's an idea for this that I just upvoted, it could use some votes! 
https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/retain-simple-formatting-when-exporting-to-excel-such-as-having/idc-p/572162#M21385

If this helped you, please mark correct to help others : )
KierstenKollins
Community Advisor
Community Advisor
February 8, 2023

Thank you! Upvoting this idea.