0

It would be greatly appreciated if someone can point me in the right direction on how to export all list data from a site to an excel file. Below is what the desired output should be. I've looked online and can't seem to find a good solution for this. I'm looking into a web part but any advice would be appreciated.

enter image description here

*Edit - Site Owners are going to be using this to generate the reports on their own.

Improve this question
3
  • Why don't you use "export to excel" option directly.
    – SPLearner
    Sep 24, 2015 at 17:31
  • That isn't exactly what he wants, he is wanting to do that across everything in the site which may be labor intensive to do and update.
    – Eric Alexander
    Sep 24, 2015 at 17:51
  • @user2314241 that only works for one list. I need it to pull items from all lists within a site.
    – Nina G
    Sep 25, 2015 at 2:20

1 Answer 1

Reset to default
0

Why don't you use "export to excel" option directly.

click on the list title on the ribbon you can find "export to excel"

Improve this answer
3
  • That only works for one list. I'm referring to exporting all items from all lists in a site to excel with the format that I displayed.
    – Nina G
    Sep 24, 2015 at 18:03
  • In that case you have to go for powershell or jquery to call the lists and than pull data to excel.
    – SPLearner
    Sep 24, 2015 at 18:33
  • Sorry, and I should have mentioned it in my original post but Site Owners will be using this script to generate the report on their own. PS will not be an option. Thanks for the response tho.
    – Nina G
    Sep 25, 2015 at 2:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.