We wanted to have created column value in the excel sheet for our survey responses. We modified the existing view to include the created column and then selected the option of Export to SpreadSheet. But it was not including the created column.
So the solution for this was to
Select All Responses View than
Site Actions – Edit Page – Modify the shared web part – Edit the current view – Than selecting the created column and copying the url of that page
http://servername:12345/_layouts/viewedit.aspx?List=%7B545889CC%2D1BE0%2D463D%2DBAA2%2D6DBEC360BA68%7D&View=%7B107DCB6B%2D83D8%2D439C%2D8996%2DF1B7782C8062%7D&Source=http%3A%2F%2Fd%2D1246%3A12345%2FLists%2FDemoSurvey%2FAllItems%2Easpx%3FPageView%3DShared
Get the id of the view
%7B107DCB6B%2D83D8%2D439C%2D8996%2DF1B7782C8062%7D
Which is
107DCB6B-83D8-439C-8996-F1B7782C8062
%7B is equal to {
%7D is equal to }
%2D is equal to –
Go back to survey, click on Action – Export to spreadsheet – Save the query to your machine and make the following changes in the query
WEB1
http://d-1246:12345/_vti_bin/owssvr.dll?
XMLDATA=1
&List={545889CC-1BE0-463D-BAA2-6DBEC360BA68}
&View={ED178AE0-E856-47FD-AB02-E1566F30E400}
&RowLimit=0&RootFolder=%2fLists%2fDemoSurvey
Selection={545889CC-1BE0-463D-BAA2-6DBEC360BA68}-{ED178AE0-E856-47FD-AB02-E1566F30E400}
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=http://d-1246:12345/_vti_bin
SharePointListView={ED178AE0-E856-47FD-AB02-E1566F30E400}
SharePointListName={545889CC-1BE0-463D-BAA2-6DBEC360BA68}
RootFolder=/Lists/DemoSurvey
Replace the above value with the value of your view i.e. 107DCB6B-83D8-439C-8996-F1B7782C8062.
Now when you will open this query it will show all the columns specified by you in the view.
Another option could be to use Data View web part for it and adding the required column to it through sharepoint designer. And than right clicking on it and selecting Export to Microsoft Excel from the context menu of the IE.
Bye