Export Show View to Excel

Is there a way to export data from a ShowView to Excel for further analysis? I have tried copying and pasting, and even when I do that, after formatting data to remove the dates, the data is not recognized by Excel and all formulas return 0 value.

The forum is not allowing me to upload the Excel file for some reason, but the example is below.

Hi Eric,

When copying data to use in Excel it will be pasted in one column as a text file, so you will need to use the Convert Text to Columns wizard in Excel:

Once converted you should be able to perform other analysis.

1 Like