Exporting CMS Reports to CSV
When Exporting CMS reports to CSV, there is some formatting that may be lost. If you would like your CMS information transferred into CSV Format, here’s how.
Start by creating your list in CMS. Print your list to the screen. Then, click the Export Button.
For your Format, choose one of the Comma-separated values
(CSV) format. For your destination, choose Disk File. Click OK
Now, save your report somewhere that you will be able to find it. If you’d like to rename your report, you can do that in this window also. Then, click Save.
Now in Excel simply open that file by clicking on File | Open and finding the file.