How to export and import SharePoint list items to excel

This SharePoint Online tutorial explains, how to export and import SharePoint list items to excel. The example we will do in SharePoint Online.

Export and import SharePoint list items to excel

There are many ways to export and import SharePoint list items in our local drive. Here we will discuss one easy way to export and import the SharePoint list items.

Here we will use SharePoint Online List.

Export SharePoint list items to excel

Now, we will see how to export SharePoint list items to excel using the out of box feature.

Step 1: Log in to your SharePoint Online site -> Go to site contents -> Go to your list which you want to export.

Next, you can see, On top there is an option Export to Excel. Please click on that to export your list to SharePoint.

Step 2: Next you can see, your whole SharePoint Online list items exported successfully in Excel Sheet. Now you can able to apply the filter and calculation etc.

Note: You cannot synchronize an external list with versions prior to Excel 2013. If you attempt to do so, an error dialog appears stating, “Cannot connect to the list”.

Import Excel Data to SharePoint Online List

You can follow the below approach to import excel data to SharePoint Online list.

Step 1: Log in to your SharePoint Online Site -> Go to site contents -> Search Import Spreadsheet.

Step 2: Next provide the Name and Description and import the excel file from the Spreadsheet.

Step 3: Next it will ask your to choose the range type. You can select the Table range or Cell range.

Step 4: Here I selected Table range so the whole Excel sheet got auto-selected. Now you can click on Import.

Step 5: Now you can see your all excel sheet data exported successfully in a list.

You may like following SharePoint list tutorials:

• Show SharePoint List Data using jQuery Datatable
• Bind SharePoint list items to dropdownlist and cascading dropdown using JavaScript and jQuery
• How to get SharePoint list items using Rest API in Microsoft Power Automate
• SharePoint 2013: Export survey results to excel
• Export SharePoint groups to excel
• Export list names into CSV using PowerShell in SharePoint 2013/2016

In this SharePoint tutorial, we learned, how to export and import SharePoint list items to excel.