This is almost more of an Excel question than a SharePoint one, but I want to be able to pull specific data out of a SharePoint list into excel dynamically.

Specifically, I don't want to export a list into excel and then try to metabolize it. I'm curious if it's possible to make excel retrieve data from a field or fields in the list. Does SharePoint even allow you to pull list data out like that, or can it only be exported manually?

  • If you're not against coding you could also create a short console application that could query the SP list using CAML to return the specific information you want and generate a CSV file from it. This would be more of a one-time-use thing though rather than a data connection as Eric suggested. – Arin Zandbergen Dec 21 '16 at 18:00

You can try creating a filtered view in your SharePoint list that narrows down the result set for you, then connect to this view in Excel to pull the data for whatever you need.

| improve this answer | |
  • Adding to this, you can also save the Excel sheet and refresh the data from within the sheet so that you don't have to manually export each time. It will maintain the link to the data for you. – Nate Dec 21 '16 at 16:34
  • That works! Thank you for the information its most helpful! – Daniel Miller Dec 21 '16 at 18:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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