Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info
Read in English
Read in English
Twitter LinkedIn Facebook Email
  • Article
  • 06/07/2011
  • 2 minutes to read

In this article

 

 

 

 

 

Using SharePoint List Data in PowerPivot

 

SQL Server Technical Article

Writer: Uday S. Unni

Technical Reviewers: John Hancock, Kasper de Jonge, Maxim Lukiyanov

Published: June 2011

Applies to: SQL Server 2008 R2

Summary: One of the many features of Microsoft SQL Server PowerPivot is the range of data sources that can be used to import data. Anything, from Microsoft SQL Server relational databases, Oracle databases, and Microsoft Access databases, to text documents, can be used as data sources in PowerPivot. In this paper, I explain one of the new and upcoming data sources that people are excited about – SharePoint list data in the form of Atom feeds. This white paper goes on to explain the different ways you can import SharePoint list data into PowerPivot, what types of lists are supported, various components that need to be installed to use this feature, and where to get those components.

  • Using SharePoint List Data in PowerPivot White Paper from Microsoft Download Center
  • Send Feedback on the white paper
  • Previous Version Docs
  • Blog
  • Contribute
  • Privacy & Cookies
  • Terms of Use
  • Trademarks
  • © Microsoft 2022

In this article

  • Previous Version Docs
  • Blog
  • Contribute
  • Privacy & Cookies
  • Terms of Use
  • Trademarks
  • © Microsoft 2022