Skip to main content
KierstenKollins
Adobe Champion, Community Advisor, UG Leader
KierstenKollinsAdobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Feb 3, 2023 4:57 PM UTC
Solved

Exporting Shared Column Reports - Excel

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.
    Madalyn_Destafney
    Madalyn_DestafneyAccepted solution
    Community Advisor
    Feb 7, 2023 7:17 PM UTC

    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 : )
    View in thread

    4 replies

    skyehansen
    Adobe Champion and Community Advisor
    skyehansenAdobe Champion and Community Advisor
    Feb 6, 2023 8:21 PM UTC

    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.

    Translate
    KierstenKollins
    Adobe Champion, Community Advisor, UG Leader
    KierstenKollinsAdobe Champion, Community Advisor, UG LeaderAuthor
    Adobe Champion, Community Advisor, UG Leader
    Feb 6, 2023 9:49 PM UTC

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

    Translate
    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity AdvisorAccepted solution
    Community Advisor
    Feb 7, 2023 7:17 PM UTC

    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

    Translate
    If this helped you, please mark correct to help others : )
      KierstenKollins
      Adobe Champion, Community Advisor, UG Leader
      KierstenKollinsAdobe Champion, Community Advisor, UG LeaderAuthor
      Adobe Champion, Community Advisor, UG Leader
      Feb 8, 2023 5:31 PM UTC

      Thank you! Upvoting this idea.

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...