Export to Excel from SharePoint

Export to Excel from SharePoint

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

  1. From the command bar of the SharePoint list, select Export to Excel Lists Export To Excel Icon .

    Important: 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. Select the List tab on the ribbon, and then select Export to Excel.

    SharePoint Export to Excel button on ribbon highlighted

    Depending on your browser, you can save and open, or open the file directly.

    Note: If you save the file, the default file name for the first copy is query.iqy, and is downloaded to the default download folder for your browser. To change the name and location, use your browser's Save as.

  2. If needed, select OK > Open after the file download begins.

  3. If prompted and you trust the SharePoint site, in Excel's security page, select Enable.

  4. In Excel's Import Data dialog, 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. When done, select OK. The list should appear in Excel.

    Excel spreadsheet with imported list and Refresh All button highlighted.

Excel creates an Excel table with a one-way data connection based on a web query file. To bring a fresh copy of the SharePoint list to Excel, select Refresh All on the Data tab. Changes made to the Excel table will not be sent to the SharePoint list.

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:

A subscription to make the most of your time

Need more help?

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

Was this information helpful?