Export to Excel from SharePoint

Export the SharePoint list items shown in the current view to Excel to work with the data in a spreadsheet.

  1. Select Export to Excel Lists Export To Excel Icon from the command bar of the SharePoint list.

    Note: Export to Excel is available only when list items are not selected.

    The classic SharePoint experience shows a ribbon above the list, not a command bar. Click the List tab on the ribbon, and then click Export to Excel.

    SharePoint Export to Excel button on ribbon highlighted
  2. Click OK > Open after the file download begins.

  3. Click Enable, if prompted and you trust the SharePoint site.

  4. 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.

    Import data dialog box from Excel 2016
  5. Click OK when you're done. The list should appear in Excel.

    Excel spreadsheet with imported list and Refresh All button highlighted.

Excel creates an Excel table with a data connection based on a web query file. Changes 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.

Additional resources

To export data from Excel to SharePoint, see this topic:

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×