How do I export activities to CSV?
You can export activities to a CSV file from the Activity Center. You can either export all the activities that are part of the projects currently on display, or only those that are visible (their project or parent activity have been expanded).
Exporting all activities
To export activities included with the projects currently on display in the Activity Center, follow these steps:
- Open Activity Center.
- Use Filters to filter out the activities you want exported.
- Use Columns to customize Activity Center.
- Click More actions (
).
- Select Export to CSV.
- Select Activities on the export wizard menu.
- Click Export.
- Export will commence and the resulting CSV file will be downloaded to your downloads folder.
Indented view option
To export activities with their hierarchy shown using indentation, use the "Show hierarchy indents for activities" option.
Important
Up to four levels of nesting is currently supported.
Exporting expanded activities only
To export only expanded (visible) activities on display in the Activity Center, follow these steps:
- Open Activity Center.
- Use Filters to filter out the activities you want exported.
- Use Columns to customize Activity Center.
- Click More actions (
- Select Export to CSV.
- Select Activities (Expanded only) on the export wizard menu.
- Click Export.
- Export will commence and the resulting CSV file will be downloaded to your downloads folder.
The exported file has some project-related fields, i.e. Project ID and Project name, to help identify the activities exported.
The Duration field is exported as two fields: Duration Days (contains the duration value in full days) and Duration Hours (contains the remainder in hours). Example: Duration = 1d 4h, the export result: Duration Days = 1 and Duration Hours = 4.
CSV file name
The exported file has the following name format:
activities_YYYYMMDDHHMM.csv,
where
YYYY = year
MM = month
DD = day
HH = hours
MM = minutes
MM = month
DD = day
HH = hours
MM = minutes