Forum Discussion

Chris Gullicksen's avatar
Chris Gullicksen
Iron Contributor
Mar 29, 2017
Solved

Exporting lists with Appending Multiple lines of text columns.

Hello,

 

 

I have a list with version history and one multiline text column that appends the text. The problem is that when we export the SharePoint list to Excel we only get the current version of each item so past versions of appended text column are lost (or stuck in the list). 

 

This got me thinking about ways to at least help the users out by making a workflow or calculated column that lets them know what multiline fields in each items even contain data in any version of the item. Does anyone have any tricks or tips related to finding out what appending multiline text fields contain data or perhaps ways of exporting with version history?

2013
Lists
sharepoint server
  • Chris Gullicksen's avatar
    Chris Gullicksen
    Mar 30, 2017

    I found this online and it is what i needed. Thank you all  for your help with this. :)

     

    Site: http://stackoverflow.com/questions/10561661/sharepoint-list-version-history-export-to-excel

     

    Quote/Answer from site:

    While I haven't found a clean way of doing this, I have a partial workaround.

    1. Use the Export to Excel option in the List section of the ribbon
    2. Save the owssvr.iqy file and open with notepad
    3. Copy just the URL from the file and paste it back into your browser, adding "&IncludeVersions=TRUE"
    4. Save the XML file and open in Excel (or your favorite XML viewer), selecting the "As an XML table" open option.
    5. You'll have to delete the first few columns and rows as they contain the schema data but other than that you should have all the version history (I suggest you add the Version column to the view)

     

2 Replies

  • Chris Gullicksen's avatar
    Chris Gullicksen
    Iron Contributor
    Mar 30, 2017

    I found this online and it is what i needed. Thank you all  for your help with this. :)

     

    Site: http://stackoverflow.com/questions/10561661/sharepoint-list-version-history-export-to-excel

     

    Quote/Answer from site:

    While I haven't found a clean way of doing this, I have a partial workaround.

    1. Use the Export to Excel option in the List section of the ribbon
    2. Save the owssvr.iqy file and open with notepad
    3. Copy just the URL from the file and paste it back into your browser, adding "&IncludeVersions=TRUE"
    4. Save the XML file and open in Excel (or your favorite XML viewer), selecting the "As an XML table" open option.
    5. You'll have to delete the first few columns and rows as they contain the schema data but other than that you should have all the version history (I suggest you add the Version column to the view)

     

Resources