Expand my Community achievements bar.

Workspace Copy/Paste to Excel Issue

Avatar

Level 2

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.

6 Replies

Avatar

Community Advisor

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!


Avatar

Level 2

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)

BrendanLo1_0-1727279194492.png

Excel (paste result)

BrendanLo1_2-1727279573940.png

 

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

 

Avatar

Community Advisor

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

Cheers from Switzerland!


Avatar

Level 5

Hey @BrendanLo1 

 

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

 

workspace.jpg

 

 

This might definitely help you!

 

Thanks

Avatar

Level 1

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.

 

Adobe Analytics Excel.png

Avatar

Level 4

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.