Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
Exporting Modified Time to Excel

Unanswered Exporting Modified Time to Excel

  • Monday, July 28, 2008 3:41 PM
     
     
    Sign In to Vote
    0
    I am exporting lists from SharePoint with the "Export to SpreadSheet" action. The list is based on survey results, and currently we have the people put in the date / time. I would like to make the date and time automatic. Is there a way to get the "Modified" or "Created" time into the Excel SpreadSheet? 

    Edit:

    No clue whats with the A's again...

    Excel / SharePoint 2003.
     

All Replies

  • Friday, July 25, 2008 8:02 PM
     
     
    Sign In to Vote
    0
    I am exporting a survey list of data from our SharePoint Server into Excel. It is important for me to know the time that each response was made. Currently I have it setup so the person making the entry selects the date (auto fills to "today's date") and time. The problem is people can be dishonest in this system, so it would be nice to just stamp the "modified" or "created" time directly on each entry in Excel. Is this possible? 

    -- SharePoint and Excel 2003.
    • Edited by YourPasswordIsA_ Friday, July 25, 2008 9:04 PM Adding
    • Moved by Mike Walsh FIN Saturday, July 26, 2008 10:39 AM Wrong Forum (Moved from SharePoint - Excel Services to SharePoint - Setup, Upgrade, Administration and Operation)
    • Merged by Lionel Chen - MSFT Wednesday, July 30, 2008 9:58 AM The same issue.
    •  
     
  • Friday, July 25, 2008 8:34 PM
     
     
    Sign In to Vote
    0
    Not sure were the A with the hat is coming from...
     
  • Saturday, July 26, 2008 10:39 AM
     
     
    Sign In to Vote
    0
    This is an Excel with SharePoint question.  NOT an Excel Services question.

    I suspect in fact that it's actually just an Excel question.

    However I'm giving you the benefit of the doubt and moving it to the SharePoint - Admin forum rather than deleting it.
     
  • Wednesday, July 30, 2008 9:42 AM
    Moderator
     
     
    Sign In to Vote
    0
    Hi,
     
    Yes, when you export a survey results to spreadsheet, the “Modified” and ”Created” column will  not display in the Excel workbook.
    I think you can try to do the following workaround to get the two columns into Excel.

    The use of various data views may help get some of the data into Excel. Follow these steps:

    1.     Open the Web site in Microsoft Office SharePoint Designer 2007.

    2.     Create a new blank page.

    3.     On the Insert menu, point to Database, and then click Data View.

    4.     Click the arrow next to your survey that is listed on the right, and then click Show Data.

    5.     Press and hold CTRL, and then click all the fields that you want in the data view, such as “Modified” and”Created”. Then, click Insert Data View.

    6.     Save the page.

    7.     On the File menu, click Preview in Browser.

    8.     Select all the text on the page, and then paste the data to an Excel worksheet.

    Hope it helps.

    Xue-Mei Chang
     
  • Wednesday, July 30, 2008 10:00 AM
     
     
    Sign In to Vote
    0
    TO export lists to Excel from SharePoint remember when use this option it depends on the View you have selected, so if your view shows the columns you want to see than you will see that column in Excel, so create  acustom view and include all the columns and than export to spreadhseet and i think that will do it for you.
    M. Hassan Raza http://mhrhap.spaces.live.com
     
  • Wednesday, July 30, 2008 2:58 PM
     
     
    Sign In to Vote
    0
    I cannot create a custom view for a survey. Unless there is a way to go to a simple list from a survey, then take that into excel.
     
  • Wednesday, July 30, 2008 3:06 PM
     
     
    Sign In to Vote
    0
    Xue-Mei Chang said:

    Hi,
     
    Yes, when you export a survey results to spreadsheet, the “Modified” and ”Created” column will  not display in the Excel workbook.
    I think you can try to do the following workaround to get the two columns into Excel.

    The use of various data views may help get some of the data into Excel. Follow these steps:

    1.     Open the Web site in Microsoft Office SharePoint Designer 2007.

    2.     Create a new blank page.

    3.     On the Insert menu, point to Database, and then click Data View.

    4.     Click the arrow next to your survey that is listed on the right, and then click Show Data.

    5.     Press and hold CTRL, and then click all the fields that you want in the data view, such as “Modified” and”Created”. Then, click Insert Data View.

    6.     Save the page.

    7.     On the File menu, click Preview in Browser.

    8.     Select all the text on the page, and then paste the data to an Excel worksheet.

    Hope it helps.

    Xue-Mei Chang



    Forgot to mention, I have no designing tools, just SharePoint and Excel. Government computers, SP Designer isnt approved.
     
  • Wednesday, February 11, 2009 3:34 AM
     
     
    Sign In to Vote
    0
    It's doable, although with some URL tweaking.  Just figured it out today.

    Grab the ID of the survey by going into "survey settings".  Up in the URL bar, you'll see something like "survedit.aspx?List=%7B6512D502%2D0DDF%2D4532%2DA592%2D9F89699482EF%7D".  Grab everything after the "=" sign.
     
    To create custom view of the survey....
     
    http://servername/sitename/_layouts/ViewNew.aspx?List=%7B6512D502%2D0DDF%2D4532%2DA592%2D9F89699482EF%7D  (of course, replace my %blahblah% with whatever you copied from the survey settings above)
     
    Create a new view, including the columns you want (created, modified, whatever).  Immediately after you create the view, the URL bar will have the GUID of the view.  COPY THAT DOWN!!!  It will look something like this:  {555993EC-E0C3-4716-9F67-5CEF723DBCEC}
     
    Now, go to your survey, and "export to spreadsheet".  Instead of opening, save the IQY file.  Edit the IQY file and replace the GUID for "VIEW" (i believe it's in two spots) with the one you just copied.  Save, and double click the IQY file to open in Excel07.  Voila!
     
  • Wednesday, July 06, 2011 8:56 PM
     
     
    Sign In to Vote
    0
    I sure hope someone is still monitoring this post.  I used Patrick Finnicum's solution for a WSS3 verision of SharePoint and it worked very well.  We've just recently upgraded to SharePoint 2010 and I tried to recreate this for the very same survey, but this time, when I created the new view, I did not get the GUID of the view in the URL bar.  I was able to select the view from the list of views for the survey, but I was not able to download it into Excel as that option was not available.  Is there a modification to this process that will work in SP2010?  Thanks in advance for your help.