ClickUp to Excel

The fastest way to export ClickUp tasks to Excel is to paste your personal API token below, pick a list, and download a clean .xlsx file -- no installation required. Your token is never stored.

In ClickUp: avatar menu → Settings → Apps → API Token. Your token is never stored.

Enter your token and select a list to continue.

How to export ClickUp to Excel

  1. Get your personal API token. In ClickUp, open the avatar menu (bottom-left) and go to Settings → Apps. Copy the token under API Token. It starts with pk_.
  2. Select a list. Use the browser above to drill from workspace → space → list, or switch to “Paste list ID” and enter the list ID directly.
  3. Convert and download. Click Convert, then Download .xlsx when the row count appears.

How to get your ClickUp API token

ClickUp personal API tokens are found under Settings → Apps → API Token. The token starts with pk_ and is tied to your account -- treat it like a password. To revoke access, regenerate the token from the same settings page. The Authorization header sends the token directly (no Bearer prefix).

Export ClickUp tasks to Excel -- what you get

Each row in the .xlsx file is one ClickUp task. Columns included:

  • Task ID and name
  • Status
  • Assignees (semicolon-separated)
  • Due date and created date (YYYY-MM-DD)
  • Priority
  • All custom fields, one column per field name

Subtasks and closed tasks are included by default. Pagination is handled automatically -- no row limit.

Frequently asked questions

Is my ClickUp API token stored?
No. The token travels from your browser to the ClickUp API through a stateless proxy (required because ClickUp does not send browser CORS headers) and is never logged or saved.
Does it export more than 100 tasks?
Yes. The converter automatically follows ClickUp's pagination and fetches all tasks regardless of list size.
Can I export multiple lists at once?
Not in a single download -- run the tool once per list and combine the sheets in Excel, or use Excel Power Query to merge them.
How do I find a ClickUp list ID?
Open the list in ClickUp and look at the URL -- it contains /li/LIST_ID. You can also right-click a list in the sidebar and choose Copy link, then extract the numeric ID from the URL.

Exporting a ClickUp list vs a Space or Folder

ClickUp organizes tasks in a hierarchy: Workspace → Space → Folder → List → Task. This tool exports one list at a time, which matches how ClickUp's API exposes tasks -- the core task endpoint takes a single list ID.

A list is the natural export unit for a single project or workflow. If your work spans multiple lists inside a Space or Folder, export each list separately and consolidate the results in Excel. The quickest way is to open all downloaded .xlsx files and use Move or Copy Sheet to pull each sheet into one workbook, or use Excel Power Query to append the tables.

The tool's browser navigation lets you drill from workspace to space to list interactively, so you do not need to know any list ID in advance. Use the Paste list ID shortcut if you already have the ID from the URL or another source.

ClickUp's built-in export vs this tool

ClickUp includes its own export. From any List or Table view, open the ... menu and choose Export to download a CSV or Excel file. ClickUp's help documentation also describes a workspace-level export available under Settings → Imports/Exports, which packages task data from selected Spaces, Folders, or Lists into a CSV file.

The key practical difference: ClickUp's view export reflects the columns and filters active in your current view -- if a column is hidden or a filter is applied, the export mirrors that. This tool bypasses view settings entirely: it fetches all tasks in the list (including subtasks and closed tasks) and writes every custom field as its own column, regardless of whether that field is visible in any view.

Neither approach is universally better. The built-in export is faster for a quick snapshot of what you see on screen. This tool is more useful when you need a complete, view-independent extract -- for example, to audit all custom field data or to reload the list into a data pipeline.

Large lists, rate limits, and custom field types

Rate limits. ClickUp's API applies a per-token rate limit. According to ClickUp's developer documentation, the default is 100 requests per minute on Free and Unlimited plans, with higher limits on Business Plus and Enterprise. Each page of tasks is one API request and returns up to 100 tasks -- so a list of 500 tasks requires 5 requests, well within the limit. The converter paginates automatically with no row cap, but very large lists (several thousand tasks or more) will take proportionally longer to fetch. If the API returns a rate-limit error, the converter will display an error message and you can retry.

Custom field types. Scalar fields -- text, number, date, URL, email, checkbox, and currency -- export as plain cell values. Fields that store structured data are flattened:

  • Multi-select and label fields: the selected values are joined with a semicolon (e.g. High; Urgent).
  • Relationship fields (linked tasks, people via custom field): exported as names or IDs where the API provides them, or as a JSON string for complex nested structures.
  • Computed fields (formula, automatic progress): exported as whatever value the API returns for that task; may be blank if the API does not include computed data in the task response.

If a custom field has no value set for a task, the corresponding column is blank for that row. Field column headers in the export match exactly the field names in your ClickUp workspace.

Export other tools to Excel