Google Analytics offers this feature and pretty much the way you wanted it.
In GA, in the Content Section, check the AdSense subsection … specifically the AdSense Pages report. It tells you page wise which content has generated how much revenues.
And yes, these reports are exportable in CSV format which open in Excel.
If I were you, I would put the posts and authors in one worksheet, the AdSense Pages report in another and do a vlookup in Excel for finding out the author-wise AdSense earnings.