How to export time metrics to Excel?

Hi,

Does anyone know how I can export a report with time metrics (like average time on page or average load time) to Csv/Excel? I tried it several times and it didn’t work. Instead of the time metrics I get long strings of numbers.

For example, when I export these time on page statistics:
1m 20s
52s
30s

I see the following numbers in Csv/Excel:
7.970.991.192.736.350
5.150.466.923.208.900
29.954.506.997.567.500

Does anyone know how I can convert these strings of numbers to time durations in a readable format, like 1:20 or 80 sec?

Thanks!

Hi @michzondag
time data is exported in seconds with high precision (13 decimal places).
Example report I exported:

and values in the exported CSV:

32.9800389483934
32.5360972122945
60.8228614685844
70.7837837837838

You can use ROUND() function in Excel to get more readable values rounded to integers.

Hope that helps,
Jarek