Task lists can be exported in open CSV format or Excel format for further processing in Excel. Importing tasks is possible in CSV format.
Exporting Tasks - all columns/fields
- Open the project from which you want to export the tasks
- Open the three-dot menu
-
Now select
Export Tasks as CSVorExport Tasks as ExcelSubsequently, all tasks of the project with all columns are exported and downloaded in CSV format or Excel format.
Further Use of the CSV File
The downloaded CSV file cannot be easily opened in Excel. It should be loaded into Excel via a CSV import, as described below:
- Open Excel (not the file)
- Select the
Datatab - Under Get & Transform Data, choose
From Text/CSV - In the Import Data window, select the downloaded CSV file and confirm with
Open - In the next window, under File Origin, select the format
65001: Unicode (UTF-8) - Confirm loading the file with the
Loadbutton
Exporting Tasks - only visible columns/fields
- Open the project from which you want to export the tasks
- Navigate to the download button
- Choose one of the options:
In this case, only the exact column selection that is displayed in the current view is exported.
Exporting Tasks - sorting and grouping of the view
When exporting to Excel, the order of the saved view is retained.
- Open the view you want to export
- Open the three-dot menu next to the search bar
- Select
Export>Export to Excel
The Excel file contains the tasks in the sort order of the view. If the view is grouped by folder, the tasks are also grouped by folder in the file. The name of the view appears in the header of the file.
Note: Not every combination of grouping and sorting is carried over.
Comments
0 comments
Please sign in to leave a comment.