Export Asana projects to CSV for custom reporting
Editor’s note: We’ve made some updates since this post was published. You can now export member data as a CSV and use our CSV importer to import spreadsheets into Asana.
Are you an Excel whiz who loves nothing more than manipulating data? Now, you can export data you capture in Asana to a spreadsheet.
Custom reporting is something a number of teams — from sales and marketing to customer support — depend on to track progress and increase efficiencies. Every Asana project is a searchable database and while Asana search lets you create custom reports and see a custom list of tasks, we know some teams want to do more. So, you can now export any project from Asana to a CSV file where you can customize this data in whatever way your team finds most useful.
To export a project, simply click on the drop-down arrow in the Project Actions menu and select ‘Export > CSV.’
Your project will be turned into a spreadsheet that contains all the following information: Task ID, Creation Date, Completion Date, Last Modified Date, Name, Assignee, Due Date, Tags, Notes, Project Name, and Parent Task (for subtasks).
Once you’ve exported the project to a CSV, you can create customized reports, pivot tables, charts, graphs, and tables that you can share with your team and/or external parties.
When to export a project to a CSV
Here are just a few of ways you can get more out of Asana with this feature. Let us know if your team discovers more ways to make use of project data in a spreadsheet.
For compliance and record-creation
If you work in finance or accounting, you’ll likely deal with auditors. Now, you can create an external record of all completed tasks that you can quickly share to show your compliance and maintain an external record of your work.
For reporting
If you’re a data-driven marketer, work in customer support or sales, you’ll now be able to
use the data you export from Asana to create graphs, pivot tables, and aggregates in Excel. Share this information with your team, contractors, and drop into presentations.
For tracking productivity
For managers, this features provides an opportunity to do more deep dive analysis of individual productivity. The creation, completion, and last modified date and assignee fields are particularly useful to quickly demonstrate success, show momentum, and highlight major milestones.
Here’s an example of a graph you can create to quickly view tasks completed by team member, in a given time period:
How do you plan to use this feature? Please share in the comments.
To learn how to create customized reports in Asana, check out the Guide.
