You can export table based data from dashboard widgets by clicking the download link on the widget



For drill down reports (Analytics->Reports) all tabular data can be exported using the same icon in the drill down report.