-(1).png){kind=logo}
How can I Export Views: Tables and Charts to Excel and PPT?
In This Article:
Export All Tables to Excel
You can export the tables and lists across all your views (including duplicate views) to excel, with 1 tab per view. Just click the Export button (the down arrow icon at the top right) and click Tables (xlsx)
Here's 4 examples:
1a: If your AV2 dashboard looks like this for Q8: Choice Crosstab
Chart:
Table:
1b: Then your Table Export to Excel will look like this for Q8: Choice Crosstab
2a: If your AV2 dashboard looks like this for Q10: Matrix Default
Chart:
Table:
2b: Then your Table Export to Excel will look like this for Q10: Matrix Default
3a: If your AV2 dashboard looks like this for Q11: Matrix Crosstab for Statement: Lunch
Chart:
Table:
3b: Then your Table Export to Excel will look like this for Q11: Matrix Crosstab for Statement: Lunch
4a: If your AV2 dashboard looks like this for Q14: Text Wordcloud and Full Answers List
4b: Then your List Export to Excel will look like this for Q14: Text List, with response id's in column A (in case you want to flag specific responses) and full answers in alphabetical order in column B.
Easy, right?
Export All Charts to PPT or PDF
You can also export the charts in all your views to powerpoint. Just click the Export button (the down arrow icon at the top right) and click Charts (ppt)
Yes, the charts are editable in powerpoint, with data sitting behind them (right click chart, click edit data). They're not images.
Yes, wordclouds are exported to the ppt/pdf as an image.
But not the full answer list. You can instead export the full answer list to excel by using Export All Tables to Excel. Example:
But why would you ever want to export anything, when everything you need (charted crosstabs, charted time series, even charted text questions) are all right here in your new AV2 Dashboard?
Nevertheless, in the next article, we'll show you how to Export Responses.