The Excel format will retain many styles as well as how your tasks are grouped in the view. This includes any custom status or dropdown colors. Your view's name and column calculations are also included in the export!
You can also export Form views as CSV files.
What you'll need
On any plan, you can export five List views and five Table views.
Unlimited exports are available on Business Plans and above.
Guests can't export List or Table views.
Export List and Table views
Find the List or Table view you want to export.
Click the ellipsis ... menu in the upper-right corner to open your view settings.
Click Export view.
Choose What To Export:
Visible columns: Only export information in the columns that are visible in your view.
Task names only: Export a simple list of the task names from the List.
All columns: Export all data for the tasks in your view, regardless of which columns you're viewing.
Choose your File Format.
If CSV is selected, you will see a Date Format export option:
Normal: Day, date, time, timezone offset.
ISO (International Standard): Year, month, day, (T) time.
POSIX: The number of milliseconds that have elapsed since January 1, 1970.
If CSV is selected, you will also see a Time Format export option:
Normal: Displays time using h to represent hours and m to represent minutes. For example, 10 hours and five minutes would appear as 10h 5m.
hh:mm: Displays hours followed by minutes, separated by a colon. For example, 10 hours and five minutes would appear as 10:05.
Select Time in Status preferences if applicable.
Include subtasks in your export
To include subtasks in your export, click the Subtasks option in the upper-right corner of your List or Table view:
In List view, select As separate tasks from the dropdown menu.
In Table view, toggle on Showing Subtasks.
Export Time in Status information
Workspaces that use the Time in Status ClickApp have an additional option available when exporting from List and Table views.
Time in Status options will vary depending on your export preferences:
When exporting Visible columns, be sure to add the Time in Status column to your List or Table view before exporting.
Exporting All columns will automatically include Time in Status information.
Time in Status export options include:
Current only: The export will include Time in Status information for the current status of each task.
Total by status: The export will include Time in Status information for every status of each task. Each status is included as a separate column in the exported file.