How to Export a Sharepoint List to Excel

by Kenrick Callwood

Microsoft SharePoint makes creating and managing group projects simple and efficient. Because SharePoint is from Microsoft, it is easy to integrate other Microsoft tools such as Excel with the program. For example, it is possible to export a SharePoint list to Excel in just a few simple steps. This makes it easy to analyze the data in the list with the tools found in Excel. With SharePoint, everything is centralized and allows everyone to work with a single version of all the product files.

1

Open your SharePoint site.

2

Click on the name of the list you want to export on the "Quick Launch" screen. Click "VIew All Site Content" if the desired list is not shown.

3

Click "Actions" and choose "Export to Spreadsheet." Click "OK" if prompted to confirm the action.

4

Click "Open" in the download dialogue box.

5

Click "Enable" if prompted to allow data connections on your computer. Excel will automatically create a new workbook and populate the data in a table.

Items you will need

About the Author

Kenrick Callwood has been involved in Internet marketing since 2007 and his work has appeared in numerous online publications. His main areas of expertise are psychology, travel and Internet marketing. He holds a bachelor's degree in psychology from California Polytechnic University.