Query a list with Excel

1. In the ribbon, click the List tab, and then in the Datasheet group, click Show Task Pane.
2. In the Task Pane, click Query List with Excel.

Microsoft Excel exports the Datasheet view as a Web query file.

If Excel is running when you click Chart with Excel, you are given the option to import the data in the Web query file into an existing worksheet, a new worksheet or a new workbook. Otherwise, Excel opens and imports the data to a new workbook. The imported data is displayed as a list in a worksheet and links the data with the information in SharePoint Foundation 2010.

Update worksheet with changes made in Datasheet view

After you make changes to data in SharePoint Foundation 2010, you can update the worksheet in Excel by using the refresh external data feature. For more information about queries, see Excel Help.