How do I export AEM reports in Excel?

Question

I'd like to to export AEM reports, page activity or component activity reports, in an excel file.

Is this feature is available in AEM or do I have to write custom for this?

Answer 1

The closest you will get is a CSV selector that can convert report data to CSV but even that has limitations (pagination, filters may be ignored depending on the report).

This, AFAIK, is not an OOTB function. There are old posts and blogs out there to show how this can be done on bpth client side (using JS) or server side using CSV writers.

If you are going down the route of writing a custom solution (most likely outcoume), have a look at the CSV text library that is used in acs-commons user CSV import/export utility, that makes the job really easy and is already a part of AEM.

Hope this helps.