To accurately understand the time and resources spent on each project, you can view and export the data related to each of your projects. This can help make informed decisions about resource allocation, project timelines, and budgeting.
Project overview
The overview page includes data on project hours and provides various views related to assigned employees. You will be able to see both the total hours recorded and the total hours divided by employee.
- On your sidebar, navigate to Projects
- Choose the desired project
- Open the Overview tab

You can showcase the entire project's progress, including its overall evolution, or filter the progress based on different time frames.
Export projects data
- On your sidebar, go to Projects
- Click on the three dots icon above the projects table
- Select Export projects
- In Export projects data, choose the Export type (see Types of exports below)
- In the side panel Export data from, set up the export:
- Choose export format: XLSX or CSV. For time exports, you can also select Include employees without time tracked and Show duration in decimal hours
-
Set filters: choose the Dates for time exports, and click on Add filter to select specific project
Customize export columns: choose the data field for each column, rename it in Export label, drag columns to change their order, or remove the ones you don't need
- Click on Export
The file is generated in the background, so you can keep working. When it is ready, you will receive an email and the file will be saved in My documents of the person who exported it.
You can follow your exports in Recent exports. If an export fails, it shows as Failed and you can relaunch it from there.
There is no limit on the number of rows. Users without an employee profile receive the file attached to the email only if it is smaller than about 18 MB. Larger files can be downloaded from Recent exports.
Types of exports
-
Total time:
All the hours spent on the selected projects. -
Total time by date:
The time tracked on each project, grouped by day. -
Clock-in/out times:
The clock-ins and clock-outs of employees in the selected dates, with the hours split by project. -
Total time by employee:
The total hours each employee worked on each project, so you can see who worked on the project and for how long.
-
Expenses:
The expenses linked to the project, their status and a link to each expense. -
Tasks:
All the tasks of each project, with task names, assigned employees, deadlines and status.
-
Phases:
One row per phase, with:- Project: name, code and status
- Phase: name, status and code
- Start and end dates, billable, description and tracked hours
- Estimated hours, if your company uses budgets
- Financial columns, only for users who can see costs: estimated cost, fee, labor cost, fixed cost, expenses, budget used, current and estimated profit, current and estimated margin, and alert
If the budget is set for the whole project instead of per phase, the estimated cost, fee and estimated profit and margin columns are empty.
Export project data with One
If your company has One and Projects, you can also ask One for a projects export in the chat. There is no button: write what you need, for example: Export the phases of project Website redesign for last quarter.
- If something is missing, such as the project, the amounts or the period, One asks before exporting.
- One uses your usual permissions, so you only get the data you can already see in Projects.