# Spreadsheets, meet ClickUp.

Hundreds of formulas, XLSX/CSV import, and real-time collaboration. Right alongside your tasks and projects.

Open Sheets Available on Business Plus, Enterprise, and Max.

## Q4 Launch Budget

|  | A | B | C | D | E |
| --- | --- | --- | --- | --- | --- |
| 1 | Line item | Owner | Budget | Actual | Variance |
| 2 | Paid social | Miya | $12,000 | $11,400 | -$600 |
| 3 | Launch event | Juan | $8,500 | $9,200 | +$700 |
| 4 | Video content | Celia | $4,000 | $3,650 | -$350 |
| 5 | Design | Marc | $3,500 | $3,500 | $0 |
| 6 | Total |  | $28,000 | $27,750 | -$250 |

## Why ClickUp Sheets

### Stop exporting the work just to do the math

Your Sheets live in the same Workspace as your tasks, docs, chat, and AI.

### Without ClickUp Sheets
- Export tasks to a spreadsheet tool, then rebuild them by hand
- Budgets live in a file nobody can find
- Reports mean copying numbers from one tool to another
- You find out about budget overruns too late

### With ClickUp Sheets
- Pull a List's tasks straight into a Sheet
- Find every Sheet in one place: the Sheets Hub
- Formulas add up the numbers for you
- Color rules show over-budget items right away

## More than a grid
Work with your project’s tasks, run calculations, or bring in an existing spreadsheet.

### See your tasks in a spreadsheet
Pull tasks from a ClickUp List into your Sheet, including owners and due dates. Add a column for costs, then hit Refresh whenever you need the latest task updates.

## Q4 Launch Budget

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Task | Owner | Status | Cost |
| 2 | Venue deposit |  | in progress | $6,200 |
| 3 | Launch video |  | in progress | $3,650 |
| 4 | Paid social |  | in progress | $11,400 |
| 5 | LP design |  | in progress | $3,500 |
| 6 | Total |  |  | $24,750 |

### Your favorite formulas are all here
With 400+ formulas, you can add up project costs, look up values across your data, or build something a little more ambitious.

|  | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Line item | Owner | Budget | Actual | Variance |  |
| 2 | Paid social | Miya | $12,000 | $11,400 | -$600 |  |
| 3 | Launch event | Juan | $8,500 | $9,200 | +$700 |  |
| 4 | Video content | Celia | $4,000 | $3,650 | -$350 |  |
| 5 | Design | Marc | $3,500 | $3,500 | $0 |  |
| 6 | Email nurture | Miya | $2,500 | $2,300 | -$200 |  |
| 7 | Webinar | Sara | $3,000 | $3,400 | +$400 |  |
| 8 | Swag | Oliver | $1,800 | $1,650 | -$150 |  |
| 9 | Analyst briefing | Juan | $2,200 | $2,200 | $0 |  |
| 10 | Total | $37,500 | $37,300 | -$200 |  |
| 11 | Miya's spend | $13,700 | | |  |

### Give your spreadsheet a new home
Import an XLSX or CSV file and keep working in ClickUp.

|  | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Region | Q1 | Q2 | Q3 | Q4 |
| 2 | Northeast | $42,100 | $44,600 | $47,800 | $51,200 |
| 3 | Southeast | $38,900 | $39,750 | $41,250 | $43,900 |
| 4 | Midwest | $33,400 | $35,100 | $36,800 | $38,250 |
| 5 | Great Lakes | $27,650 | $28,900 | $30,400 | $31,900 |
| 6 | Mid-Atlantic | $45,300 | $46,200 | $48,900 | $50,750 |
| 7 | Southwest | $31,200 | $33,650 | $34,900 | $37,100 |
| 8 | Mountain | $22,800 | $24,100 | $25,600 | $27,300 |
| 9 | Pacific NW | $36,700 | $38,200 | $40,150 | $42,600 |
| 10 | California | $61,400 | $63,900 | $67,250 | $70,800 |
| 11 | Gulf Coast | $29,640 | $30,800 | $33,900 | $35,450 |
| 12 | Plains | $18,900 | $19,700 | $21,300 | $22,100 |
| 13 | Alaska & HI | $9,800 | $10,250 | $11,100 | $11,900 |
| 14 | Total | $397,790 | $415,150 | $439,350 | $463,250 |

### Work in the same Sheet together
See where teammates are editing in real time. Open Edit history to review earlier changes.

## ClickUp Brain

### Ask your Sheet what the numbers mean
Open Brain² from your Sheet and ask any question about it, like which expenses are over budget or what's trending.

## Everything a spreadsheet nerd could ever want

### Hundreds of formulas
Use familiar formulas like SUMIF, VLOOKUP, and IF.

### XLSX and CSV import
Bring in an existing file. Export it anytime.

### Conditional formatting
Color the cells that need attention, so overruns flag themselves.

### Charts
Turn a range into a chart without leaving the Sheet.

### Multiple sheet tabs
Budget, capacity, and forecast in one Sheet, a tab apiece.

### Sheets Hub
Every Sheet in one place. Create, find, and favorite from the Sheets Hub.

## Which one do I need?

### Table view or Sheets?

- **Table view**: Your tasks, in rows and columns. Edit task fields in bulk. Best for managing the work.
- **Sheets**: A real spreadsheet. Cells, formulas, files, and task data pulled in when you need it. Best for doing the math on the work.

## Sheets is just the beginning
Sheets sits in the same workspace as your tasks, Docs, and Chat. Write the brief in a Doc, track delivery on a Dashboard, and settle the numbers in a sheet your whole team can open. Every tool below works alongside it.
