Question
Exporting Reports to Excel: Formatting
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.
Hi Ryan, Can you please provide us the report name where this issue has been observed?
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
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
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?
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?
+1Hi 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?
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?
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).
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.