Select Export to Excel from the command bar of the SharePoint list.
Important: Export to Excel is only available: when list items are not selected; and in specific browsers, Internet Explorer 10 and higher, and Microsoft Edge
When prompted, click OK > Open.
If prompted, click Enable, if you trust the SharePoint site
In the Import Data dialog box, select the How you want to view this data and Where do you want to put the data options.
Optionally, you can click Properties and set the connection properties.
Click OK when you're done. The list should appear in Excel.
Note: Does your screen look different? See Synchronize a SharePoint list with Excel.
Results in Excel
Excel creates an Excel Table with a data connection based on a web query file. Updates are not made automatically. To see further changes made to the SharePoint list in Excel, you must manually update by clicking Refresh All on the Data tab.
If your SharePoint list contains folders, the folder structure does not appear in the resulting Excel table. However, the Item Type and Path columns are added to the Excel table so you can filter and sort the data, based on its type and location or subfolder of the list.
For more information, see Export an Excel table to SharePoint.
Leave us a comment
Was this article helpful? If so, please let us know at the bottom of this page. If it wasn't helpful, let us know what was confusing or missing. We'll use your feedback to double-check the facts, add info, and update this article.