ClickUp's export excludes closed tasks and subtasks by default, and API timestamps arrive as millisecond integers that Excel cannot read directly.
There are two practical ways to get ClickUp data into Excel: the list-view export built into ClickUp and the ClickUp API via Power Query. Both have the same default blind spot: closed tasks and subtasks are hidden unless you explicitly turn them on. Miss that toggle and your export looks fine but represents maybe half the actual work. Here is every method, with the limits ClickUp's own docs skip.
Method 1: List view export (CSV or Excel)
Switch to the List view for the list, folder, or space you want to export. Before you export, open the view settings and enable Show Closed if you need completed tasks and Show Subtasks if you need subtasks, as both are hidden by default. Once the view looks right, click the Export button in the top-right and choose CSV or Excel format.
The catch: the export reflects exactly what is visible in the view at the moment you click. Closed tasks and subtasks are excluded by default, and skipping those toggles is the most common reason exported task counts look wrong. Some export options (such as exporting from higher-level views that span multiple lists) are also gated behind paid plans, so free-plan users may see fewer options than the documentation describes. Free-plan users who cannot access the .xlsx export can still export as CSV, which Excel opens directly.
Workspace-level export: if you need to export task data from across the entire workspace rather than a single list, go to the workspace avatar in the upper-left corner, choose Settings, then Imports / Exports, and click Export Items. Select the locations to include and start the export. This produces a CSV covering all selected spaces and lists, not just the current view.
Method 2: ClickUp API via Power Query
In desktop Excel (Windows or Mac), open Data, then Get Data, then From Web to build a Power Query connection to the ClickUp API. Authenticate with a personal API token and query the tasks endpoint for your list or space. Power Query can parse the JSON and expand task fields into rows.
The catch: three gotchas hit most first-timers. First, closed tasks are excluded from API responses unless you add include_closed=true to the request. Second, subtasks are excluded unless you add subtasks=true. Third, all date and time fields (created, updated, due date, date done) return as Unix millisecond integers, not formatted dates. A value like 1719446400000 needs converting: in Excel the formula is =(A1/86400000)+25569, then format the cell as a date. Power Query is Windows and Mac desktop only; it is not available in Excel on the web.
Method 3: Brooked for Excel (includes closed tasks and subtasks)
Brooked for Excel is an add-in that connects to ClickUp, pulls tasks from any list or space, and delivers them as a clean flat table. It includes closed tasks and subtasks without any toggle to remember, and it converts timestamps to readable date values automatically. It runs inside Excel's ribbon on Windows desktop, Mac, and Excel on the web, where Power Query is not available. An AI analyst lets you ask questions like "what is the average cycle time per assignee" without writing any formulas manually.
Honest framing: Excel support is in beta. Manual imports and the AI analyst work today; scheduled refresh is rolling out through the beta. The Google Sheets version of the same connector is fully live, so the ClickUp plumbing itself is mature.
Setting up the ClickUp connection
Open Brooked in the Excel ribbon, choose ClickUp as the source, and authenticate with your ClickUp account. Select the workspace, space, folder, or list you want to pull, choose whether to include subtasks and closed tasks, and import into the active worksheet. Dates arrive as formatted Excel values, not millisecond integers.
Brooked AI, ClickUpMethod comparison
| Method | Cost | Works on | Refresh | Best for |
|---|---|---|---|---|
| List view export (CSV/Excel) | Free; some plan limits | Any Excel | Manual re-export | Open task snapshots from one list |
| ClickUp API via Power Query | Free (dev time required) | Windows & Mac desktop Excel | Manual refresh | Developers who need paginated pulls |
| Brooked for Excel | Free during beta | Desktop, Mac & web Excel | Scheduled (rolling out in beta) | Closed tasks, subtasks, any Excel platform |
What operations and product teams build with this
- Cycle time analysis: days from task creation to closed status, per assignee and list
- Workload report: open tasks by assignee across all lists in a space, updated weekly
- Sprint retrospective data: all completed and incomplete tasks from the past two weeks including subtasks
- Status distribution: count of tasks per status across the entire workspace, for leadership snapshots
- Time estimate vs actual tracking: estimated hours versus logged time for billing and capacity planning
Troubleshooting common issues
Related Articles
Frequently asked questions
How do I export ClickUp tasks to Excel?
Switch to the List view for the list or space you want to export, then click the Export button in the top-right area of the view. ClickUp offers CSV and Excel (.xlsx) format options. The export includes the tasks visible in the current view, so filter and sort before exporting to control what appears in the file.
Why are closed tasks missing from my ClickUp export?
The list-view export includes only the tasks currently showing in the view. By default, ClickUp hides closed tasks from the list view. To include them, turn on the 'Show Closed' toggle in the view options before exporting. In the API, add the include_closed=true parameter to the request.
Does the ClickUp export include subtasks?
By default, subtasks are also hidden from the list view and excluded from the export. Enable 'Show Subtasks' in the view settings before exporting to include them. In the API, subtasks are excluded unless you explicitly pass the subtasks=true parameter.
Why do ClickUp timestamps look like '1719446400000' in Excel?
ClickUp's API returns dates and times as Unix timestamps in milliseconds, not as formatted dates. To convert a millisecond timestamp to an Excel date, divide by 86,400,000 and add 25569 (the Excel epoch offset): =(A1/86400000)+25569, then format the cell as a date. The UI export formats dates as readable strings, so this only affects API-based imports.
Does ClickUp have a native Excel add-in?
No. ClickUp does not publish an official Excel add-in on Microsoft AppSource as of mid-2026. The export path is through the list view UI or the ClickUp API. For live connected data you need the API or a third-party connector.
Does the ClickUp export work on Windows, Mac, and Excel on the web?
The exported .xlsx or CSV file opens in any Excel on any platform, so the UI export works on Windows, Mac, and Excel on the web. The ClickUp API via Power Query works in desktop Excel on Windows and Mac but is not fully supported in Excel on the web. Connector add-ins like Brooked work across all three platforms.
How do I export all tasks from ClickUp across the whole workspace?
The list-view export covers only the list or space you are currently viewing. To export task data from the entire workspace, click your workspace avatar in the upper-left corner, choose Settings, then Imports / Exports, and click Export Items. Use the Select locations dropdown to pick the spaces and lists to include, then click Start Export. ClickUp prepares a CSV covering all selected locations.
Get live ClickUp data in Excel, closed tasks and subtasks included.
Brooked for Excel is in beta and free to try. Using Google Sheets instead? Read the Sheets version of this guide.
See Brooked for Excel →
