All Collections
How To
Exporting NikaTime data
Exporting NikaTime data

A guide to exporting NikaTime's data into a CSV file, selecting the fields to include and custom formats

NikaTime avatar
Written by NikaTime
Updated over a week ago

You can export all the data available in your Report Center to CSV files. The Export button is located at the top right corner in all Overview and Management pages.

What data can I export?

The exported data is determined by the report page you're in, and defaulted to the date range and active filters. The Team Overview, Time Off Overview, and user Overview produce a file with raw logs, one per row. The Projects Overview exports one row per project, with aggregated data.

The timeframe is limited to one year, but you can go back indefinitely and export each year separately.

You can export a list of all team members or projects under Team Members and Project Management respectively.

How to customize the data format

After clicking the Export button, you can select the columns that are included in the CSV file. Just click the Add Column button to display the available fields and select from the list. You can change the order by dragging the columns. For example, this would help you create a CSV that uses the Project Ref ID instead of the project name, so you can import NikaTime's data into your accounting software.

The export dialog also allows for changing the date range and date format. 

Did this answer your question?