Skip to main content
SharePoint

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

6
  • Thanks, but... What if we need to have the whole data available 24x7? Commented Apr 26, 2017 at 20:37
  • Perhaps I've misunderstood the requirements? With indexes and views, users should have access to browse through all items. But you need to actually download all the current files at any time of day? What, specifically, do you mean by download? But other options include using excel/powerpivot to connect to the list, or SSRS to create a report. You can also go the coding route and access the data via REST or CSOM. Commented Apr 26, 2017 at 20:43
  • There's an excel report which needs to be fed by all the items on a list. Actually, I'm downloading all the items available through Datasheet View, and exporting it to a different Excel file. My default view (All Items) does not allow me to download all the items because is filtered to avoid limit threshold. Would you be so kind to guide me on how to access the data via REST or CSOM? Commented Apr 26, 2017 at 20:50
  • Let's try an easier way first. If you have excel 2016, try the following from excel: data tab --> get data--> from other sources --> sharepoint list. Commented Apr 26, 2017 at 21:10
  • Unfortunately, my Office version is 2013. But, I've seen that I can download PowerQuery for Office 2013 and install it to connect to the SharePoint list. Is this Power Query add-in licensed? I was able to accomplish what I was looking for with this add-in. Thanks @Mike2500 Commented Apr 26, 2017 at 21:32