And then if I exported a standard report, I also delete any metrics I won’t be using in my report. So I delete all of the data at the top of the report, which is usually broken down by day. The first thing I do when I export a report is to get rid of all the extraneous data I don’t need. So here’s how you can change your report to show the mm:ss format:ġ. Yucky, huh? Who wants to figure out how long 288 seconds is? (Math geeks need not apply.) But once you’ve done it a few times it’s easy to remember.īut when you export the report to Excel by clicking the Export tab at the top of the window and selecting CSV for Excel and open it in Excel, it looks like this: And transforming this data back to its native formatting takes some fancy footwork in Excel. As soon as you export the data you lose that beautiful, intuitive formatting and end up with something that makes no sense whatsoever. So when you export to Excel you’d think that formatting would follow. It follows an easy mm:ss format, with m representing minutes and s representing seconds.
Many of the reports in Google Analytics show you either time on site or time on page, depending on the report. Solution: Run a simple formula in Excel to convert, then apply number formatting as follows.
Problem: I want to show Time on Site the way Google Analytics does, but it shows up in Excel as number of seconds when I export.
