Skip to main content
michael_sweeney
michael_sweeney
Helper ⭐️
Nov 29, 2017 11:15 PM UTC
Question

Would like to see the same formatting when exporting a report to Excel and CSV

Reaching out for a customer who would like to see the same formatting when exporting a Report to Excel and exporting to a CSV. As of now the reports show in different formats.

    9 replies

    karl_rumelhart
    karl_rumelhart
    Expert ⭐️
    Nov 30, 2017 2:08 PM UTC
    Be aware that CSV by its nature has no formatting.  E.g. currency in CSV is just a number.  
    Translate
      lila_meyer
      lila_meyer
      Gainsight Employee ⭐️⭐️⭐️
      Dec 18, 2017 6:35 PM UTC
      Switching post to a public category for additional customer comment and visibility. 
      Translate
      Lila Krutel, Dir. Global Education Services
      mary_ecklund
      mary_ecklund
      Contributor ⭐️
      Feb 13, 2018 1:14 PM UTC
      Then both of the exports should look the same... they do not. It is very difficult to work with 2 reports that are supposed to be the same yet are formatted differently. If you look at the sample you can see. 
      Translate
        michael_sweeney
        michael_sweeneyAuthor
        Helper ⭐️
        Feb 13, 2018 3:08 PM UTC
        Is there anything on the roadmap concerning the formatting of these exports?
        Translate
        lane_h
        lane_h
        Helper ⭐️
        Jun 11, 2020 8:49 PM UTC

        I’m running into this as well. Even when I convert the field to a number in Excel, it is still not recognized as a number. Maybe it’s an excel thing, but this is very frustrating as I have to go back and enter each number as a number manually.

        Translate
        Director of CX and Scale Programs
          sai_ram
          sai_ram
          Expert ⭐️⭐️
          Jun 16, 2020 6:19 AM UTC

          @lane_h our product team will get back to you on this. 

          Translate
          rahul_prayakarao
          rahul_prayakarao
          Helper ⭐️⭐️
          Jun 30, 2020 6:26 AM UTC

          @lane_h @michael_sweeney with the reporting revamp (which is in progress) we will not be supporting .csv formats anymore. All the exports will be in Excel format only. This should resolve your parity issues.

           

          Translate
            jeremy_johnston
            jeremy_johnston
            Helper ⭐️
            Jul 6, 2020 2:24 PM UTC

            @lane_h @michael_sweeney with the reporting revamp (which is in progress) we will not be supporting .csv formats anymore. All the exports will be in Excel format only. This should resolve your parity issues.

             


            Where can I find more information about the Reporting Revamp?  I’m interested in learning what the specifics entail.  Thanks!

            Translate
            -JJ
              dan_ahrens
              dan_ahrens
              Expert ⭐️⭐️⭐️
              Sep 24, 2020 3:33 AM UTC

              Hi @jeremy_johnston - we are redesigning our reports and dashboards capabilities to provide improved usability and more powerful features. We’re aligning with many of the building capabilities in Data Designer (like field navigator and visualization tools), as well as more controls over the final appearance (legend, colors, layout, etc). 

               

              Dashboards will provide more granular controls over the size of each report or widget added to the dashboard, responsive design for all size screens/devices, as well as the ability to embed other content besides Gainsight reports, like text boxes (for headers or explanations of the dashboard) or even live content from other sites (like embedding a Tableau component within a Gainsight dashboard). 

               

              Looking like this will be coming in the November release or shortly after. 

              Translate
              VP of Customer Success at Forcepoint
                Terms & ConditionsAccessibility statement