Windows – sharepoint cannot export all fields to spreadsheet

Option 2 (CQWP) is the way to go, but it will take a little bit of customizing.

After you point the CQWP at your list, you need to change the "Library Type" to be "Wiki Page Library" or your data won't show up properly. It defaults to "Pages Library" which doesn't work for Wiki's.

As far as adding your custom field, you need to edit the CAML code for the web part and edit the field data. Here is a tutorial page with a section on how to do that (the section title is "Modify the CQWP to Include Additional Data"): www.heathersolomon.com/blog/articles/CustomItemStyle.aspx

Also, here is the technical details from MSDN on customizing the CQWP: msdn.microsoft.com/en-us/library/aa981241.aspx

When SharePoint gets the request you need to make sure that the request it thinks it is getting is the actual URL it is publishing. So for example if your proxy server is accepting the request as https://foobar.com/ then it will need to send that same URL to SharePoint . This is the only way that AAM will know how to serve back the correct URL as SharePoint sends back the same URL that was requested as long as that URL is configured in AAM.