This SharePoint Online tutorial explains, how to export and import SharePoint list items to excel. The example we will do in SharePoint Online.
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.
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”.
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
- 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
In this SharePoint tutorial, we learned, how to export and import SharePoint list items to excel.
Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).