This article explains how to export the Work Plan Grid view to Excel. You must first select Export. Then, you may select the format you want it to export.
Exporting Work Plan Grid view
When exporting, it will export the visible work items on the page. This allows you to collapse / expand and filter out the work items you don't want in your export.