Opening a SharePoint List in a Spreadsheet

Browse to the List folder that you want to export and click on Actions-->Export to Spreadsheet

Click on Open in the File Download dialog box

Agree to the Security Prompt by clicking on Enable

Excel imports all of your lists into the spreadsheet which provides greater flexibility for sorting and filtering the results than that’s possible in SharePoint.