The simplest method would be to navigate to the Project Center page in PWA,
select a View that contains the fields you want to analyze for all projects,
and then click the Export to Excel link in the lower right corner of the
data grid. Hope this helps.