Asana workload report: rebuild it in Google Sheets
Asana's Workload view is Advanced and up, with no documented export. Build an Asana workload report in Google Sheets: open tasks and hours per person per week.
·7 min read
Key takeaways
Asana's project and portfolio Workload needs Advanced or higher, and universal workload is Enterprise and Enterprise+ only.
None of Asana's workload help pages mention an export, and the view keeps no record of past weeks.
A workload report needs 4 task columns: assignee, due date, completed and estimated time.
Estimated time needs Advanced, so on Starter count tasks per person instead, or weight them with a number custom field.
One COUNTIFS on assignee and the week's dates gives open tasks per person per week, and SUMIFS on estimated time gives hours.
Monday planning. 2 designers say they have too much on, and only one of them does. You want open tasks per person for the next 4 weeks, with hours where you have them, on one page the account leads can open. That page is an Asana workload report, and Asana's own Workload view only covers part of it.
The view is good for moving work around inside Asana. It's harder to share, keep or send. This post covers what the view shows, which plan it needs, and how to rebuild the same picture in Google Sheets™ from 4 task columns. Plan gates come from Asana's help center and pricing page, as of 21 October 2026.
The short answer
Asana's Workload shows each person's load across a project or portfolio, on Advanced and up. Universal workload, across the whole organization, is Enterprise and Enterprise+ only. None of Asana's workload help pages mention an export. For a workload report you can share, filter or archive, rebuild it in a spreadsheet from assignee, due date and estimated time.
Asana's Workload view and its plans
Workload lays people out against time. A person gets a row, and the row fills with the tasks assigned to them across the dates they're due.
It's good for the person balancing the week. A lead spots an overloaded week on screen and stays in Asana to deal with it.
Workload type
Asana plans
Project and portfolio workload
Advanced, Enterprise, Enterprise+, plus legacy Business and Legacy Enterprise
Universal workload, across the organization
Enterprise and Enterprise+ only
Advanced costs $24.99 per user per month billed annually, or $30.49 billed monthly. Enterprise and Enterprise+ have no list price. Starter and the free Personal plan don't get Workload at all.
The limits of the Workload view
No export. None of Asana's workload help pages mention one. The view stays on screen, and the screenshot is what travels.
Seats. An account lead without an Asana seat can't open it. A client asking whether anyone works on their project can't open it either.
No record of last month. The view shows the schedule as it stands today. To see how load moved since last month, someone has to keep a copy somewhere else.
One assignee per task. Asana allows a single assignee. A task 2 people share counts against one of them, and followers don't count at all. That limit follows the data into any spreadsheet too.
The 4 columns a workload report needs
Everything Workload shows comes from a handful of task fields. Put those fields in a sheet and you can rebuild the picture yourself.
Column
What it does in the report
Assignee
Who the load belongs to. One person per task in Asana
Due date
Which week the load lands in
Completed
Drops finished work from the count
Estimated time
Turns task counts into hours, where your team fills it in
Add the project and the section, and you can slice the same grid by client or by stage.
Estimated time only exists where Asana time tracking is on, which means Advanced and up. On Starter, count tasks instead. Or weight them with a number custom field your team already keeps, like points. Custom fields need Starter or higher.
Getting the tasks into a sheet
Any route that lands one row per task works. The CSV export from the project's dropdown menu is the quickest start. It's a snapshot, so this week's report goes stale by next Monday. Asana's own Google Sheets sync needs Advanced and stops at 500 rows.
A sync add-on keeps the tab current. Asana to Sheets, our Asana to Google Sheets add-on, brings in tasks with assignee, dates, section and custom fields. It writes a task in 3 projects once, so no one's load counts 3 times. A filtered sync can leave completed tasks out, which means every row in the tab is open work.
Subtasks matter more here than in most reports. The real work often sits in a subtask with its own assignee, under a parent owned by a manager. Subtasks come across with their parent task's name next to them. Large subtask trees take longer, because Asana hands subtasks over one parent at a time. Asana subtasks in Google Sheets covers the gaps the other methods leave.
Keep the synced tab's columns in their places. Resizing and hiding are fine. Build the report on a second tab.
Build the report by person and week
Say the synced tab has the name Tasks and holds open work only. The assignee sits in column C, the due date in column D and the estimated time in column F. Swap the letters for your own layout.
Open a new tab. Put the Monday of each week across row 1 from C1. Keep B1 for an Overdue column.
Put each person's name down column A from A2. Add one row with an empty name for unassigned work.
In B2, count overdue work with =COUNTIFS(Tasks!$C:$C, $A2, Tasks!$D:$D, "<"&$C$1).
In C2, count each week with =COUNTIFS(Tasks!$C:$C, $A2, Tasks!$D:$D, ">="&C$1, Tasks!$D:$D, "<"&C$1+7).
Fill it right and down.
That's the task-count version. A pivot table gives the same grid without formulas. Put the assignee in rows and the due date in columns, then count task names in values. On raw dates it makes one column per day, so past a fortnight the formula grid is easier to read.
For hours, change COUNTIFS to SUMIFS and put Tasks!$F:$F first. Check how the estimate column reads before you trust the totals. If it shows minutes, divide by 60.
Add a Capacity column with the hours each person can take in a week, say 30 for a full-timer and 12 for someone on 2 days. A conditional format that turns a cell red when it passes that person's capacity gives you the overload view in one glance.
Count 2 gaps on their own. Tasks with no due date have no week to land in, so add a column with =COUNTIFS(Tasks!$C:$C, $A2, Tasks!$D:$D, ""). And watch the unassigned row. If it holds 40 tasks, fix triage before you hire anyone.
If due dates land a day early or late, the cause is usually time zones or the sheet's locale. Asana dates wrong in Google Sheets has the fixes.
Workload view against a Sheets workload report
Asana Workload
Google Sheets report
Asana plan
Advanced and up. Universal on Enterprise and Enterprise+
Any plan. Hours need Advanced, counts work everywhere
Export
None documented
It's already a spreadsheet
History
Today's schedule only
Paste a weekly snapshot into an Archive tab
Readers without Asana seats
Can't open it
Can open a shared file
Overdue and undated work
Read off the view
Counted in their own columns
Use both. The view is where a lead rebalances the week. The sheet is where you report the week, keep it and compare it with last month.
Frequently asked questions
Can you export Asana's Workload view?
Not according to Asana's help center. None of its workload pages mention an export. The underlying data reaches a spreadsheet through the task fields instead: assignee, due date, completed and estimated time.
Which Asana plan has workload?
Project and portfolio workload are on Advanced, Enterprise and Enterprise+, plus the legacy Business and Legacy Enterprise plans. Universal workload, across the whole organization, is on Enterprise and Enterprise+ only.
Can I build a workload report on Asana Starter?
Yes, with task counts in place of hours. Estimated time needs Advanced, but assignee and due date exist on every plan. A number custom field such as points works as a weight, and custom fields start on Starter.
Why does one person's workload look too low?
Asana allows one assignee per task, so shared work counts against a single person. Check subtasks too. If the work sits in subtasks and your report only counts parent tasks, the people doing it disappear.
How current is the Google Sheets version?
That depends on how the rows arrive. A CSV is current on the day you export it. Asana to Sheets refreshes every 3 hours on its Pro plan, and in seconds with live sync on Business.
Your next step
Build the task-count grid first, for one team and 4 weeks, and show it at the next planning meeting. Once the counts look right, add hours from your time data. The Asana time tracking report post covers the logged-time side.
Asana is a trademark of Asana, Inc. Google Sheets and Google Workspace are trademarks of Google LLC. Asana to Sheets has no affiliation with either, and neither endorses it.
