Microsoft® Windows® SharePoint® Services 3.0 Step by Step

Exporting a SharePoint List to an Excel 2007 Spreadsheet

You can export the contents of SharePoint lists, results of a survey, or document libraries to an Excel 2007 spreadsheet. The exported list or library is a Web query that stays updated with changes to the original list in your SharePoint site. The Excel 2007 spreadsheet maintains a connection to the SharePoint list and therefore becomes a linked object.

In this exercise, you will export a list from a SharePoint site to an Excel 2007 spreadsheet. You will add data to the spreadsheet and then synchronize the data in the spreadsheet with the contents of the list on the SharePoint site.

Note

OPEN the SharePoint site on which you have a list from which to export data to an Excel 2007 spreadsheet. ...