How do I extract a SharePoint 2013 list to Excel meeting this requirements?

  • I cannot use SharePoint Designer.
  • I do not want to use the export option as I want to be able to call this outside of SharePoint.
  • I have no experience with scripting.
  • 1
    What are you trying to do with the list afterward? How do you want your system/users to initiate the export (an external application, a provider hosted app, from the list's view pages?) I understand your limitations, but what you're trying to accomplish is unclear. – John-M Oct 20 '15 at 14:09
  • If you export from SharePoint you end up with an Excel file which has no relation with SharePoint. So what does "I want to be able to call this outside of SharePoint" mean? – Danny '365CSI' Engelman Oct 20 '15 at 15:00
  • Getting the list into excel outside of sharepoint is the goal. My hope was to configure an auto export of the list, however my companies system does not allow scripts to do that. My next thought was to just try to extract the data from outside of sharepoint into excel. We just want to create graphs from the information. The list will be used by people entering "timesheet" type of information. I appreciate the support! – MAH Oct 20 '15 at 15:57
  • @DannyEngelman nope you're wrong. When exported, it just exports a query file which executes a query to SharePoint to get the data. Running it when you have no access to the sharepoint site is useless. – Akhoy Oct 20 '15 at 15:57
  • @Akhoy you're technically right, but then you can just save the data itself (think copy/paste values or remove external connections) and it is completely detached -- so I'm unsure why the built in export functionality couldn't meet this need, just try sending them the exported excel sheet! – John-M Oct 20 '15 at 16:03

I used Access to connect directly to the list. Set up a daily export from Access to Excel. I believe this will work. Thanks to all who tried to help.

|improve this answer|||||

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.