locked
Export Related Lists to Excel RRS feed

Answers

  • Hi Kelly,

    As far as I know, from the current SharePoint function, we can’t export the list along with the related list to excel. Because, the excel is not the relation database or data source. So, when you export the list, the relationship will miss.

    In fact, SharePoint list is a form of database table. So, SharePoint list can keep the relationship.

    In excel, you can create multiple data sheet, so, you can store your different list in different data sheet in one excel file. Some data you can choose from the other data sheet to display.

    More reference:

    http://blogs.c5insight.com/Home/entryid/438/Use-Power-Pivot-to-Merge-Related-SharePoint-List-Data

    Thanks,

    Victoria

    Forum Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Victoria Xia
    TechNet Community Support

    • Marked as answer by JasonGuo Tuesday, August 19, 2014 12:37 PM
    Tuesday, August 12, 2014 8:18 AM