0

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.
13
  • 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, 2015 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? Oct 20, 2015 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, 2015 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, 2015 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, 2015 at 16:03

1 Answer 1

1

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.

Your Answer

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

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