How to Export and Import Excel to SharePoint list?

20 October 2023

In the realm of efficient data management, the seamless integration between Microsoft Excel and SharePoint Lists has become paramount for organizations seeking to optimize their workflows. This article provides a step-by-step guide on how to import and export Excel to SharePoint Lists, offering valuable insights for decision-makers aiming to enhance their data-driven processes.

Option 1: Creating a New SharePoint List

When you need to establish a completely new SharePoint list and already have an Excel sheet with the desired master data format, follow these straightforward steps:

1. Open your Excel sheet and select the data you wish to copy. Click on the “Format as Table” option.
   
2. While the data table is selected, navigate to the ribbon, choose the “Export” option, and select “Export Excel table to SharePoint List.”
   
3. A pop-up will appear. Specify the URL of the target site, provide your list name, and click on “Next.”
   
4. All columns will be displayed with corresponding recognized column types (Currency, Date, etc.). Click “Finish.”
   
5. Receive a success message/pop-up, indicating that your list has been published to the provided SharePoint site.
   
6. Your published list will now be accessible in the SharePoint.
   

Option 2: Adding Data to an Existing SharePoint List

If you already have a SharePoint list and wish to append more data or move files below the existing list, follow these steps:

1. Open the link where you want to add your updated data in the SharePoint list and click on the “edit” button and add new items.
   
2. Highlight all the values in Excel that you want to copy into your SharePoint list.
   
3. Paste the data onto the selected row in your SharePoint list.
   

By following these steps, you can efficiently create a new SharePoint list or update an existing one, depending on your specific requirements.

These steps provide a general guideline for importing Excel data into a SharePoint List. Depending on the version of SharePoint you’re using, the steps might vary slightly. You can refer to the SharePoint documentation or user interface for more specific details tailored to your SharePoint version.

At Star Knowledge, our team comprises experienced SharePoint consultants ready to assist you with a range of SharePoint-related challenges and more. Whether you need solutions for SharePoint issues or have other inquiries, connect with us to harness the full benefits of SharePoint tailored to your specific use case.