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

I don’t think ROUND is enough. Can you provide the full function to convert seconds into minutes in the format mm:ss?

Hi Giampiero,

Welcome to the community.
Just divide your seconds by 86400 (the number of seconds in a day, e.g. =A1/86400) and apply a mm:ss format in Excel.

image

Here’s a full guide I found on the internet that worked for me.

Good luck

1 Like

Hi,

This doesn’t seem to solve the issue in my case. The decimals seem to get messed up with the export or creating seperate columns. What should show 44s, shows the number 4418783930510310 in my case. The decimals are gone. Any advice on how to proceed?

Scherm­afbeelding 2023-03-14 om 15.28.08

Same problem here. Tried the solutions above and didn’t work