How to Export Sharepoint list to Excel

If someone cannot view a list in "Datasheet Mode" (for advanced queries on the list), it might be worth downloading the list to Excel and use its query capabilities.

NOTE: the downloaded spreadsheet is not connected to the original list so any updates here will not reflect there.

Step-by-step guide

1. In Sharepoint, open the list you want to export and, from the top menu, select "List":
   
   
   
2. From the options that will be shown, select "Export to Excel":
   
   
   
3. This will bring a dialog box at the bottom of the screen. Just press "Save":
   (Please note the strange name it will give to your file (in this case "owssvr.iqy")
   
   
   
4. Open Excel and create a blank Spreadsheet:
   
   
   
5. Once opened, click on the "Data" tab. This will bring the Data options. Among them, select the "Existing Connections":
   
   
   
6. That will open a dialog box. Click on "Browse for More ..." (bottom-left corner):
   
   
   
7. That will open another dialog box for you to select the strangely named file downloaded earlier (in my case it was downloaded to the "Download" folder):
   
   
   
8. Select the file and click on "Open". That will bring you a last dialog box. Leave it as is and click "OK":
   
   
   
9. That should bring you your list inside Excel.

Related articles

• Page:
  Unable to log into Sharepoint
• Page:
  SharePoint Error - Use a Supported Version
• Page:
  Sharepoint - Manage Access
• Page:
  How to Export Sharepoint list to Excel
• Page:
  How do I update the personal information listed in SharePoint?