Easiest way to export task to excel

[Niels_Oomen]

Hi,

I know there is an option: Export to CSV, but that is not easy. You need to wait for an email and then you can download the CSV. Is there another way to export the tasks of a project in a simple way to Excel?

Thanks in advance.

Regards,
Niels

[lpb]

@Niels_Oomen, You might find Asana2Go easier (disclaimer: I’m the creator); you can export from Asana without even a file and import to Excel with just a paste:

Custom CSV Exports

Hi @Robert_Starr, Asana2Go (disclaimer: I’m the creator) has two CSV export built-in options and you can customize your own by duplicating and editing, though it requires a little technical skill: See also the help in Asana2Go about CSV exports; you don’t need to create a file even. Larry

Thanks,

Larry

[Stephen_Li]

Hi @Niels_Oomen ,

I believe if your project is small enough, using the export to CSV option immediately downloads it. For larger projects, I don’t know of another way to do this short of building (or using, if it exists) some kind of integration to Office.

[Bryan_TeamKickstart]

I second this. Asana2Go is an excellent tool!

[Niels_Oomen]

@lpb

Asana2Go

Hi @lpb. I will have a look. Is it correct that it only works with Google Chrome?

[Niels_Oomen]

@lpb Is there a way to have to have Customer fields to an individual collumn?

Thanks.

[lpb]

@Niels_Oomen,

Asana2Go works in Chrome, MS Edge, Opera, and Brave.

@Niels_Oomen

Is there a way to have to have Customer fields to an individual collumn?

The Table - Interactive format will show one column with the values of every custom field on the task.

To have a single column, you’d need to create a custom report which requires knowledge at the level of someone who maintains a website (or can fake it by learning from example).

In this post, the very last link is an intro video to Asana2Go. The last 2+ minutes demonstrate starting with an existing format and making a change to it. That’s what you would do, and use {{lookup custom_fields_simple 'MY CUSTOM FIELD NAME'}}

How Well Do You Know Asana2Go?

As part of this special Integrations Edition of Forum Leader Tips, I’m covering an integration I should know better than anybody else—because I created it! Asana2Go is a free*, 5-star-rated Chrome (and MS Edge, Opera, and Brave) extension that enables you to copy, print, and export flexibly from Asana. It works with all free/paid Asana plans, requires no extra login/authentication, and does not modify/write anything in your Asana. Asana2Go has a diverse set of features, including some that Asa…

Thanks,

Larry

[Niels_Oomen]

Hi @lpb thanks for the feedback. I will have a look into that.

[Shun_Sakurai]

@Niels_Oomen
Just to mention, Asana also syncs with Google Sheets.

[lpb]

Great point, @Shun_Sakurai. And I think that same mechanism may work with Excel (it used to, at least; there is an old Forum post saying that, as I recall).