Skip to main content
ryan
ryan
Contributor ⭐️⭐️
May 24, 2016
Question

Exporting Reports to Excel: Formatting

  • May 24, 2016
  • 5 replies
  • 95 views
We are in the process of rolling out a process where CSMs will post account updates in the CTA comments section. From there, we plan to pull reports off these and manipulate the data as needed in Excel for executive reporting.  When exporting to excel, we loose all formatting and line breaks. This makes the comments very hard to read and requires manual work to reformat the text as needed.  Ideally, when exported to excel, all text formatting will remain.  

    5 replies

    ankita_yadav
    ankita_yadav
    Contributor ⭐️⭐️⭐️⭐️
    May 25, 2016
    Hi Ryan, Can you please provide us the report name where this issue has been observed? 
    ryan
    ryanAuthor
    Contributor ⭐️⭐️
    May 25, 2016
    Hi Ankita,

    This is happening on any report where I pull the CTA comments from.  If you would like to jump on a call I would be happy to show you.

    Ryan 
    ankita_yadav
    ankita_yadav
    Contributor ⭐️⭐️⭐️⭐️
    May 26, 2016
    Hey Ryan,

    Sorry that could not make call yesterday, actually,I work in IST time zone . Can you please tell me the suitable time when we can have call?
    sai_ram
    sai_ram
    Expert ⭐️⭐️
    June 13, 2017
    Hi Ryan,

    I recently started going through all of the unanswered or unresolved problems and questions here. Was checking to see if this issue has been resolved or if it is an ongoing issue/question?
    venky_reddy_k
    venky_reddy_k
    Helper ⭐️
    August 9, 2017
    In winter '16 we worked on this item. With that release following tags are honored; italics, bold, underline and newline, div, paragraph and li. I hope this answers a lot of formatting concerns while exporting a regular report as excel (non scorecard mass edit reports).
    Terms & ConditionsAccessibility statement