Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word

7.1. Exporting a List from SharePoint to Excel

The last couple chapters have covered exporting lists from SharePoint to Outlook and Access. So it should not surprise you that you can export a SharePoint list to Excel. In fact, if you have been checking out the options in SharePoint's list and document menus, you probably already have a good idea of how to start.

To show that document libraries act very much like lists, let's start with the Purchase Orders library. You previously used this library to learn how you could use library metadata in other Microsoft Office applications. You even created a custom view to sum the Purchase Amount column by department to produce a "report" within SharePoint showing how much each department spent during ...