Exporting Raw Data (Export Data)

Overview

The Export Data screen lets you download your raw survey and session data as an Excel (.xlsx) file. You will find it under Reports > Export Data.

There are two export options. They contain the same underlying data, just laid out differently – choose whichever suits your analysis:

• Export Data by Survey – one row per client/episode, with each session’s score spread across columns (Session 1, Session 2, and so on).
• Export Data by Session – one row per individual survey/session, in a long “stacked” layout.

How to export

1. Go to Reports > Export Data.
2. Under the export you want, click Request Data Export. The panel shows In progress… while the file is prepared.
3. When it is ready, click Download to save the .xlsx file.

Larger datasets take longer to generate. If the download is not ready immediately, wait a short while and click Download again.

A note on dates and times (UTC)

All date and time values in the exported files are shown in UTC (Coordinated Universal Time), not your local time zone.

Everywhere you view data inside OpenFIT, times are automatically converted to your local time zone. The exported files are the one exception – they contain the raw UTC values, so administration times can appear several hours ahead of your local time.

For example, a session administered at 9:00 AM US Pacific time is stored and exported as 4:00 PM UTC.

In the By Session export the time column is labelled “(UTC)”. The By Survey export shows the same UTC values without the label.

Converting exported times to your local time in Excel

To shift the UTC times to your local zone, subtract your offset from UTC. Excel stores time as a fraction of a day, so seven hours is 7/24. Using US Pacific as an example:

• During daylight saving (roughly March–November): subtract 7 hours, e.g. =A2 - 7/24
• During standard time (roughly November–March): subtract 8 hours, e.g. =A2 - 8/24

For other regions, use your own offset from UTC in place of 7 or 8.

Two things to keep in mind:

• A single formula assumes one time of year. If an export spans a daylight-saving changeover, rows on either side of the change will be an hour apart.
• If the time column comes through as text (more likely in the By Session export, because it includes the “+00:00” offset), convert it to a proper date/time first – for example using Excel’s Text to Columns – before the formula will calculate.