How to export and import SharePoint list items to excel

by

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

Table of Contents show

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.

Export to Excel SharePoint Online

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.

export and import SharePoint list items to excel

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.

Export and import SharePoint list items to excel

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

export SharePoint list items to excel

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

import SharePoint list items to excel

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

import SharePoint list items to excel

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

How to import SharePoint list items to excel

You may like following SharePoint list tutorials:

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

>