How to Export SharePoint Online List to Excel

In this SharePoint Online tutorial, we will explain how to export SharePoint Online List to Excel. Also, We will discuss below topics such as:

• Export SharePoint Online List to Excel
• Export Selected items Of a SharePoint List to an Excel Spreadsheet
• Export SharePoint Online List to CSV File

Also, Read: How to Copy a SharePoint List

Export SharePoint Online List to Excel

Here, We have created a SharePoint Online list (Mercy Health Donors). This list has various columns with different data types such as:

• Donor ID = This is the Title Column renamed to Donor ID
• Donor Name = single line of text
• Donor Email Address = Single line of text
• Donor Country Code = Single line of Text
• Donor Phone Number = Number Column
• Donor Birthday = Date and Time Column
• Donated Branch = Choice Column
• Donated Amount = Currency Column
• Payment Mode = Choice Column

• On the SharePoint Online list (Mercy Health Donors), Expand Export on the command bar -> Select Export to Excel.

NOTE:

The Export option will only available when items in the SharePoint list are not selected.

• The exported file will get downloaded to your local system with the default file name of the query. iqy. Click on the Open file link as below.

• By opening the file, it will display the Dialogue box of the Microsoft Excel Security Notice -> Click on Enable.

• Next, it will display the Excel Import Data dialogue box,
  • Select how you want to view this data in your workbook: There are four options:
    • Table
    • PivotTable Report
    • PivotChart
    • Only Create Connection
  • As per my requirement, I have chosen the Table option.
  • Where do you want to put the data?: Click on the New workbook.
• Finally, Click on OK.

• The selected SharePoint Online list (Mercy Health Donors) will appear in the Excel sheet as shown below figure:

• After getting exported to the Excel sheet -> Click Refresh.
• It will trickle changes from the SharePoint list down to Excel automatically.

This is how to Export A List From SharePoint Online To Excel Spreadsheet.

Check out: SharePoint Online Document Library Permissions [Detailed Tutorial]

Export Selected Items of a SharePoint Online List to an Excel

Next, we will see how to Export Selected Items of a SharePoint Online List to an Excel.

• The Export option is not available for the selected list items of SharePoint, we can do it in other methods by creating a new list view.
• Create a new view of selected items (Ex: we are creating a new view of the items regarding the Donated Amount of 250$).
• Filter the list (Ex: Filter by Donated Amount) -> Click column header [Donated Amount] -> Filter by -> Click Apply.

• It will display the filtered group list -> Click the List view icon -> choose ‘Save View As’ (Filtered by Donated Amount).

• The filtered view appears as shown in the below figure:

• Next, Export selected items of a SharePoint list to an Excel Spreadsheet (Click Export -> Select Export to Excel).
• The Exported SharePoint list will be shown below figure:

This is how to Export Selected Items Of A SharePoint Online List to an Excel Spreadsheet.

Read: SharePoint Online Site Date Format [With Examples]

Export SharePoint Online List To CSV File

Likewise, we will go through how to Export SharePoint Online List To CSV File (Comma Separated Value).

• Open the SharePoint Online list -> Click Export on the command bar -> Select Export to CSV (Comma Separated Value).

NOTE:

The maximum number of rows you can export to a CSV file is 30,000.
CSV file can be opened in Notepad or Excel.

• CSV file will get downloaded to your local system with the default file name of Excel.

• Click Open file to display a file in the Excel workbook as shown below:

• Click on the File, on the upper left-hand side of the Excel Spreadsheet.

• select Save AS to save the file in .csv format on your computer. 

This is how to Export SharePoint Online List To CSV File (Comma Separated Value).

Furthermore, you may like some more SharePoint Online tutorials:

• Indexed Column in SharePoint Online List
• SharePoint Online List Title Column [Detailed Guide]
• How to Delete a Column in SharePoint Online List
• SharePoint Online List Vs Excel
• SharePoint Online List Templates [With Real Examples]
• SharePoint Online Modern List Features

Conclusion

From this SharePoint Online tutorial, we have learned the following topics such as:

• Export A List From SharePoint Online To Excel Spreadsheet
• Export Selected Items Of A SharePoint Online List to an Excel Spreadsheet
• Export SharePoint Online List To CSV File