How do you export a full list of projects in a workspace?

English Forum Tips and Tricks
1

Hi,

Does anyone know if there’s a way to export all the project names in the workspace? I’m trying to get them into Google Sheets.

I know you can do this if you put each project in your dashboard, but then my dashboard becomes unwieldy.

Let me know if you guys know of anything.

Thanks,

Chris

2

Hi Chris,
Not an uncommon question! We’ve discussed this in the thread here Project List Export - #3 by Alexis.

I’m going to take the liberty of adding your post to the existing thread, so we can consolidate information and continue all conversation on the subject there.

Thanks!
Alexis

3

@Chris_Stadler Did you manage to find a solution to this in the referenced thread that works for you?

4

You’ve seen this already, @Joseph_Simons, but I wanted to update this thread with the answer.

Larry

2 Likes
5

Thank you.

1 Like
6

Is there a way around the “visible to me” limitation? I exported the list of users from the Admin console and can see the teams and projects they are a member of. I’d like report on the Teams including # of Projects (and how active those projects are). But some of the projects I can see exist in the CSV export from Asana, but not through this api (presumably because they are Private and/or I’m not a Member of/Invited To them.

7

My solution: have a developer set up a script in Google Sheets to pull active projects from Asana through its API. It’s probably not a practical answer for everyone. Good luck!

2 Likes
8

That works. Thanks Chris.

9

@Julia_Forbes,

Service Accounts (what you’re asking for) and Full-Org Exports are Enterprise features:

Otherwise, you need a user with access, as is discussed here:

Larry