# Asana export to google sheets

**URL:** <https://forum.asana.com/t/asana-export-to-google-sheets/1107057>\
**Category:** Ask the Community\
**Tags:** export, agentic-work-management, projects\
**Created:** [4 November 2025 21:35 UTC](https://forum.asana.com/t/asana-export-to-google-sheets/1107057 "2025-11-04T21:35:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Harshaw\_Paruchuri](https://luna1.co/8d76cd.png) [@Harshaw\_Paruchuri](https://forum.asana.com/u/Harshaw_Paruchuri)\
**Post date:** [4 November 2025 21:35 UTC](https://forum.asana.com/t/asana-export-to-google-sheets/1107057/1 "2025-11-04T21:35:44Z")

</div>

Hi All,

I have exported my project tasks in to google sheets and trying to differentiate tasks, sub tasks and milestones. any ideas on how to do that ?

Thanks

H

---

<div class="post-metadata">

**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\
**Post date:** [5 November 2025 05:00 UTC](https://forum.asana.com/t/asana-export-to-google-sheets/1107057/2 "2025-11-05T05:00:01Z")

</div>

Welcome, @Harshaw_Paruchuri,

If you did Sync to Google Sheets, then:

- The column “Parent task” indicates a task if empty and a subtask if it has a value.
- Milestones are not shown, but custom fields are, so if you could represent milestones that way (a rule could even help), then the live update would keep that in sync too.

Thanks,

Larry

---

<div class="post-metadata">

**Author:** ![Harshaw\_Paruchuri](https://luna1.co/8d76cd.png) [@Harshaw\_Paruchuri](https://forum.asana.com/u/Harshaw_Paruchuri)\
**Post date:** [5 November 2025 07:59 UTC](https://forum.asana.com/t/asana-export-to-google-sheets/1107057/3 "2025-11-05T07:59:45Z")

</div>

thank you!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/system/32/276370_2.png) [@system](https://forum.asana.com/u/system)\
**Post date:** [5 December 2025 07:59 UTC](https://forum.asana.com/t/asana-export-to-google-sheets/1107057/4 "2025-12-05T07:59:53Z")

</div>

Closed on 5 December 2025 07:59 UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
