Welcome to the Asana Community Forum
Once exported as csv and then converted to xlsx format or uploaded as google spreadsheet you should have a better overview.
If you need more and advanced export features you can take a look at tools such as Bridge24, Asana2Go or others.
Here is a nice post by Larry about this functionality via Asana2go How to export tasks/subtasks as a text file? - #8 by lpb