How To Export A List From Sharepoint Online Or On-Premises

Today, I am writing about “How to export a list from SharePoint Online or On-Premises.” Thus, we will be exporting a SharePoint list to our computer, which we don’t do daily, but it’s a good practice to do for those lists which are very important. For example, we have a few lists which we need to migrate from one SharePoint site to other, and instead of using any other tool, we can use this by exporting and importing the same to the other site. As we know, using the list, export feature is a very simple and easy way to manually get all the content in your lists and move them.

Also certain columns “Created”, “Created by”, “Modified”, and “Modified by” will not retain the previous information, it will be updated automatically, once the list is moved as these columns are by default for the list.

Today, I am showing steps on how to export a list from SharePoint Online or On-Premises with the screenshots.

Hence, login to SharePoint site and open any one of the lists, which you would like.
Now, at the top of the page, click LIST to enlarge the ribbon.
Once we click on the List, in the connect & export section, click Export to Excel.

From the yellow bar at the bottom, click Open or Save to your local system. This will be applicable for IE. I am working with MOZILLA, so it will be, as shown below.

If we go to open the exported list, it will prompt Excel security. Cick Enable and wait till it opens.

Now, we can see the external contacts list will open and I will see two additional columns, Item Type and Path. Don’t be confused by these as they’re just providing additional information about the items.