Workspace Copy/Paste to Excel Issue | Community
Skip to main content
BrendanLo1
BrendanLo1
Level 2
September 24, 2024
Question

Workspace Copy/Paste to Excel Issue

  • September 24, 2024
  • 3 replies
  • 1514 views

When I copy data from a Workspace table and try to paste it into Excel it is not pasting correctly. It seems to paste percentages instead of the raw number.

 

Is anyone else experiencing this issue? I know this was an issue a few weeks/months back, but seems to be back. It worked as expected this morning and do see any reported maintenance/issues documented in the system status portal.

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

    3 replies

    bjoern__koth
    Community Advisor and Adobe Champion
    bjoern__kothCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    September 25, 2024

    Hi @brendanlo1 


    can you describe how you proceed when you are copying data? Through the right-click context menu, through Ctrl+C, ...

    Also, which kind of data are you trying to copy+paste?

     

     

    I quickly tried with download as CSV file and that looked ok.


    Cheers

    Cheers from Switzerland!
    BrendanLo1
    BrendanLo1Author
    Level 2
    September 25, 2024

    Confirming that this is still an open issue.

     

    This is just a simple selection of cells from a Workspace table and using keyboard shortcuts to copy/paste. Again, this typically works as expected, but have experienced this issue a few weeks/months back, which was resolved after a few days. For some reason it seems to paste the percent to total opposed to raw value.


    Workspace (copy)

    Excel (paste result)

     

    Fully aware of other capabilities such as Report Builder and downloading a CSV. This is just a quick solution for a specific use case.

     

      bjoern__koth
      Community Advisor and Adobe Champion
      bjoern__kothCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      September 25, 2024

      In that case I would say double-check with support. Little the community can help you with (except confirming) 🙂

      Cheers from Switzerland!
      P
      Pankaj_Sabharwal
      Level 5
      September 27, 2024

      Hey @brendanlo1 

       

      Exporting the data as a CSV file can help avoid formatting issues like those experienced during copy-paste operations.

       

       

       

      This might definitely help you!

       

      Thanks

        IñakideBilbao
        IñakideBilbao
        Level 2
        September 27, 2024

        Hi, I have the same problem.

         

        I have always copied the data directly from an Adobe Analytics panel (ctrl+c) and paste it in Excel without any problem.

         

        However, now when I paste the data in Excel the dots "." and commas "," change from what I see in Excel. I mean, the dots become commas.

         

          SSampsa
          SSampsa
          Level 4
          October 11, 2024

          I could not duplicate this issue testing different number and type of reports. Possibly this issue relates to Adobe uses period as the thousand separator, while Excel seems to convert and interpret it as a decimal separator, at least in some cases. Making sure how Excel is setup could help with this.

          Terms & ConditionsAccessibility statement

          Loading footer...