locked
Export version data from sharepoint to Excel RRS feed

  • Question

  • Hi,

    I'm exporting data from Sharepoint to Excel, but "Version"information is not extrated and I need this to control the docs I've posted on Sharepoint portal. Can I do that in someway? It's possible? 

    Tuesday, April 3, 2018 5:13 PM

Answers

All replies

  • Hi Davi,

    Have you come across these below articles , it may help you for exacting the documents versions

    How to include/retain the document version with “Export to Excel” (Spreadsheet)
    https://blogs.technet.microsoft.com/fesiro/2012/12/01/how-to-includeretain-the-document-version-with-export-to-excel-spreadsheet/

    How to get Document Version with “Export to Excel” from SharePoint
    http://itgroove.net/mmman/2014/01/19/how-to-get-document-version-with-export-to-excel-from-sharepoint/

    Similar thread

    export version history of sharepoint 2013 list items to microsoft excel  


    Best Regrads, Ahmed Madany MCTS @twitter http://twitter.com/ahmed_madany @Blog http://ahmedmadany.wordpress.com @LinkedIn http://eg.linkedin.com/pub/ahmed-madany/35/80/2b6


    • Edited by Ahmed Madany Tuesday, April 3, 2018 5:24 PM
    • Proposed as answer by Sara Fan Wednesday, April 4, 2018 3:28 AM
    • Marked as answer by Davi Mathielo Friday, April 6, 2018 12:00 PM
    Tuesday, April 3, 2018 5:23 PM
  • Hi Davi Mathielo,

    If the reply is helpful to you, you could mark the reply as answer. Thanks for your understanding.

    Best regards,

    Sara Fan


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    • Marked as answer by Davi Mathielo Friday, April 6, 2018 12:00 PM
    • Unmarked as answer by Davi Mathielo Friday, April 6, 2018 12:00 PM
    Wednesday, April 4, 2018 3:29 AM
  • Hi

    One last thing, it's possible to use the VBA (first article) to export another data from Sharepoint? I'm thinking to export the document ID and the version toguether to compare with the exported data based on database. If it's possible, how can I know the colum name to use on VBA?

    Wednesday, April 4, 2018 6:45 PM
  • Hi Davi Mathielo,

    If you want to know more about the VBA, I would recommend you post it in our dedicated forum for VB development, there will be more support engineers and experts on this field assisting you on this VB specific issue.

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=vbgeneral  

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Best regards,

    Sara Fan


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, April 6, 2018 9:56 AM
  • Ok, thank you!
    Friday, April 6, 2018 12:01 PM