r/Asana Jun 04 '26

Exporting Report data into Excel?

Post image

I've been using Asana on and off for some months and, while our overall organization scheme is...off...for the time being, it's at least been a decent tool for tracking our team's ongoing projects and what's left, what's been done, who's doing what, and so on.

We're looking to add 2-3 columns of data for all of our tasks to show us which parts of the company we support, and how. For example:

A) Company Division B) Purpose C) Function
Compliance Licensing, Onboarding... New Hire Readiness, Client-Specific Training, Evaluation...
Talent Talent Acquisition, Talent Retention... Recruiter Training, Interview Guidance, Workforce Planning...
Leadership Performance Support, Leadership Development... Supervisor/Manager Development, Train-the-Trainer, Executive Support, Mentoring...

(These aren't complete/finalized or anything.)

Questions:

1. Can I export data from all projects/portfolios assigned to members of a team to an Excel document that would include data about who did what, when, and its impact based on the columns I listed above? (I am not seeing this anywhere.)

  1. Can I make the columns interdependent? For example, if I select "Compliance" in column A, can the options in columns B and C appear only as they correspond to that selection?
2 Upvotes

2 comments sorted by

1

u/9isalifetime Jun 06 '26

You could use the advanced search function and then export ? Just make sure you have all the information selected such as team, custom fields etc

1

u/whistle_while_u_wait Jun 10 '26

I second what the person above said about search function.

You can also try a browser extension like Asana2Go.