To learn how to import data into PowerPivot for Excel, see the following topics.
Import Data from a Database
Import Data from a File
Import Data from Analysis Services or PowerPivot
Import Data from a Reporting Services Report
Import Data from a Data Feed
Copy and Paste Data to PowerPivot
Add Data by Using Excel Linked Tables