Workspace Copy/Paste to Excel Issue

[BrendanLo1]

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.

[bjoern__koth]

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

[BrendanLo1]

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]

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

[Pankaj_Sabharwal]

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]

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]

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.