Export a SharePoint library/list to Excel


Export a SharePoint library/list to Excel

To work with library and list entries in Excel, you can export them.

Export a list to Excel

  1. Go into the list and select Export > Export to Excel.
  2. Open the file in your Downloads folder.
  3. Select Enable to view the data.
Export a SharePoint list to an Excel file

Export a library to Excel

  1. Go into the library and select the ellipses (...) above the library > Export to Excel.
  2. Open the file in your Downloads folder.
  3. Select Enable to view the data.
Export a SharePoint library to an Excel file

Save the exported file as an Excel file

  1. Open the file in your Downloads folder.
  2. Select Enable to view the data.
  3. Select the Files tab > Save As > provide a new title > Save.
Save the exported file as an Excel file