A client has asked about the ability for them to export UGC comments and ratings into a spreadsheet from Tridion.

After checking the docs and investigation in and around the Control Room dashboard and UGC nodes in Shortcuts and under Publications I can't see anyway to do this within the GUI.

Is that correct - this export functionality is not available (unless we write something for them)?

2 Answers 2


My understanding is that Excel supports oData natively. I think that you just need to provide the oData endpoint for UGC in order to get the UGC data like comments and ratings (item stats) into Excel.

  • 2
    +1 - probably play around with it in LinqPad first, then provide the correct queries (URLs) to the editors, and presto - all your comments are belong to us.
    – Nuno Linhares
    Commented Jan 22, 2014 at 17:41

Comments are stored in application data, which means you can simply get to all comments by reading the right application data for each of the items (Component or Page).

The application ID for UGC comments is ugc:ComponentAndPage, the data will be stored as an XML document.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.