Export CMS custom report to Excel

[ArturP]

Does anybody know how to export CMS custom report to Excel?

 

[Gizzzmo]

Export it to text file in your centrevu application and open your excel. Click in excel on the DATA menu and select import external data. Then select the txt file and select the proper seperators. Done!

 

[ArturP]

Thank You for help.

 

[SF0751]

I use the following steps for all of my CMS report exports to Excel:

CMS: Select Edit - Export Table Data. Choose Export to Clipboard, and make sure tht Export Null Values as Zero and Include Labels and Headers are checked.

Excel: Open a blank worksheet and select PASTE from the Edit menu (or just use the CTRL/V shortcut key.

Susan
"'I wish life was not so short,' he thought. 'Languages take such a time, and so do all the things one wants to know about.'"
- J. R. R. Tolkien, The Lost Road

 

[mwarren]

You could also - Select Edit - Export to file and put .xls at the end of the filename for the file extension.

No need to copy and paste then.

Mark