How to: Export a Discussion topic List item (SharePoint 2007) to excel or PDF ?

Here is  some tricky way to achieve this GOAL

When you reply to a discussion it changes to Flat view and redirected to flat.aspx page.

So to export discussion topic in excel you have to manually change the URL from flat.aspx to allitems.aspx.

I.e. to enable export to spreadsheet option URL should be http://siteURL/Lists/discussionname/allitems.aspx

Else to export from “Flat view” tries following steps.

·         Open Excel

·         Click on DATA tab

·         Select from Web option

·         Then in URL provide the URL with http://siteURL/Lists/discussionname/flat.aspx

·         This will open a page with Allitems.aspx in pop up and then you can select (arrows) to insert required data to excel.

·         And from Excel you can easily export to PDF

Feel free to reach me in case of any queries / issues related to above post.