How To Export Excel To SharePoint List

Exporting Excel data to a SharePoint list can be done easily by following these simple steps. Whether you’re creating a new list or adding more data to an existing one, this step-by-step guide will help you streamline your data management process and enhance productivity.

Option 1 involves creating a new SharePoint list. Start by selecting the desired data in Excel and formatting it as a table. Then, choose the “Export Excel table to SharePoint List” option from the ribbon, while still selecting the data table. In the pop-up window, enter the URL of the SharePoint site and provide a list name. Completing the export process is as simple as clicking “Next” and then “Finish”.

Option 2 allows you to add more data or records to an existing SharePoint list. Open the SharePoint list and click on the “edit” button. Select the last row of the list where you want to add the data, and then copy the values from Excel that you want to import. Paste the data on the selected row in the SharePoint list and click on the “stop” button to stop editing. Refresh the list to verify the successful import.

It’s important to note that while changes made in SharePoint can be pulled down to Excel, the reverse is not possible. Additionally, the order of columns cannot be modified or excluded from the export process.

By leveraging these steps, you can effortlessly export Excel data to a SharePoint list. Take advantage of this seamless integration to simplify your data management and boost efficiency.

Option 1 – Creating a New SharePoint List

The first option for exporting Excel data to a SharePoint list is to create a brand new list. This method is ideal when you have an Excel sheet with the desired data and want to start fresh with a new SharePoint list. Here is a step-by-step guide on how to accomplish this.

  1. Select the data from your Excel sheet that you want to export to SharePoint.
  2. Click on the “Format as a Table” option to convert your selected data into a table format.
  3. With the data table still selected, navigate to the ribbon and choose the “Export Excel table to SharePoint List” option.
  4. In the pop-up window, enter the URL of your SharePoint site and provide a name for your new list.
  5. Click on “Next” and then “Finish” to complete the export process.

By following these steps, your Excel data will be exported and transformed into a new list within SharePoint. This allows you to easily manage and manipulate your data in a collaborative and organized environment.

Excel Data SharePoint List
Data 1 Record 1
Data 2 Record 2
Data 3 Record 3

As you can see in the above example, the Excel data has been successfully exported to a SharePoint list. The table provides a clear visual representation of the data, making it easy to analyze and work with.

Option 1 Recap: Creating a New SharePoint List

1. Select the data you want to export from Excel.

2. Format the selected data as a table.

3. Use the “Export Excel table to SharePoint List” option in the ribbon.

4. Enter the SharePoint site URL and choose a name for the new list.

5. Complete the export process by clicking “Next” and “Finish”.

By following these steps, you can seamlessly export your Excel data to a SharePoint list and take advantage of the collaborative features and data management capabilities that SharePoint offers.

Option 2 – Adding Data to an Existing SharePoint List

Another option for exporting Excel data to a SharePoint list is to add new records to an existing list. This method is useful when you have an already established SharePoint list and you want to update it with new data from an Excel sheet.

To begin, open the link to the SharePoint list where you want to add the data. Next, click on the “edit” button to enter the editing mode. Choose the last row in the list where you want to insert the new records.

With the desired row selected, go back to your Excel sheet and highlight all the values you wish to copy. Once selected, paste the data onto the chosen row in the SharePoint list. After pasting, click on the “stop” button to exit the editing mode.

Finally, refresh the SharePoint list to verify if the new data was successfully imported. This method allows you to easily update an existing SharePoint list with the latest information from your Excel sheet.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.