Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

xlsx-Export for Workspace

Avatar

Level 3

21-03-2018

Hello,

I searched the forum for similar topics but only found threads which were from at least 4 years ago and also without solution. As I have to export reports on regular basis, it would be more than helpful if the reports could be exported in xlsx-format. I think that many users would appreciate this feature, as Excel is still a standard tool.

Kind regards,

Patrick

17 Comments

Avatar

Level 2

30-11-2018

Thank you for your reply Brandon - and for the tip about downloading an individual table! This is very useful.

One thing: I noticed that the csv does not contain a first row with the column headers (Metric names). Could this be added?

Strangly the table I exported contains a dimension breakdown (Referrer --> Entry Page) and the csv does contain one row for the broken down referrer where all metric headers are shown. And under that a row shows with the name of the breakdown dimension (Entry page) is shown --> see screenshot:

1633941_pastedImage_0.png

Looking forward to the changes you mention

Avatar

Employee

30-11-2018

The missing metrics at the top seems odd (they should be there) - please submit an issue with Customer Care and we'll look into it.  I think the breakdown dimension is correct, but we can look into that as well.  Thanks again for the feedback.

Avatar

Level 2

03-12-2018

Hi Brandon

I found out that I double-clicked on the wrong cell (one row too low). Should have double-clicked the empty cell to the left of the metrics to select everything. so all is fine with this now!

Avatar

Moderator

17-12-2018

We are going to make an update to CSV downloads (and Copy/Paste from Workspace) to remove the thousands separator. We will continue to respect the decimal separator as defined in Components > Report Settings. In addition, the UI will continue to show the thousands separator.

Avatar

Moderator

19-04-2019

The CSV updates were delivered as part of the Apr MR. We are going to mark this as Delivered. If there are still open needs that require downloading to XLSX, please file a new idea with those details listed.

Avatar

Level 3

17-05-2021

Hi Patrick, not sure if this is still relevant, but the company I work for (Daexus) released an Adobe Analytics web data connector for Tableau. It's free and ultra-secure and supports scheduled refreshes like you mentioned but that feature is available in the paid version.

You can find more information on our website and I'm more than happy to answer any questions you might have!