How Can We Help?

Import data to SharePoint lists from Excel

You are here:
< All Topics

In this article, we will show you how to import Excel list items to an existing SharePoint list. There are three (3) ways to import Excel to SharePoint list and they are as follow:

  • Quick Edit
  • Import Spreadsheet
  • Direct Export from Excel

How to import through Quick Edit

In the quick edit option in the list of a SharePoint, you can input the data from the Excel spreadsheet directly to the existing list or the list you just created. You need to create columns similar to the columns of the spreadsheet.

Computer program - Screenshot
  1. Open Microsoft Excel , copy the cells that you wish to transfer to the desired SharePoint List.
Computer program - Line
  1. Make sure the field type matches with the cells in the list.
  2. Log in to the required SharePoint site and create a list (or select an existing list). You will need to create columns in the same order as in your spreadsheet.
Web page - Web browser
  1. To add a column, click Add column and choose among the option to create a suitable column.
Design - Product
  1. After creating the column, click Edit in grid view option.

Note: Some SharePoint sites may show this as Quick edit.

Nextcloud - Jira
  1. The list columns are open to receive the data. Copy the row from the excel and paste it in the list row.
Product design - Screenshot
  1. The simple copy-paste process will bring the whole data to the SharePoint list.
Product design - Product

How to import through Import Spreadsheet option

Another method involves using the ‘Import spreadsheet’ web part option where you can directly import the Excel sheet to the site. Here’s how:

  1. Click Settings (gear icon) on the site page.
Markdown - Email
  1. Select Add an app.
Email - Microsoft Corporation
  1. On the app list, choose Import Spreadsheet.
SharePoint - Microsoft Teams
  1. On the next screen, give your new app/list a name, then choose an Excel file. Click Import.
Product design - Product
  1. The Excel file will open up where you need to select the range of cells that you want to import. Select them and click Import.
  2. The table will be copied to the SharePoint site list. The table will have proper columns and rows as it was saved in the Excel.

Note: This process works only with Internet Explorer. If you are using any other web browser, it will give you an error message that says, “This feature requires a browser that supports ActiveX controls.”

How to import through Direct Export from Excel

Lastly you can directly export the table to SharePoint list without any external assistance. Here’s how:

  1. In Excel spreadsheet, select the data range and Format it as a Table.
Kenting National Park - Computer program
  1. While the table is highlighted, go to the Export option and select Export table to SharePoint list.
Computer program - Zeugma Mosaic Museum
  1. In the Address field, input the link of the site of the SharePoint list. Provide a Name and description to the sheet and click Next.
Data - Column
  1. On the next screen, you will see all the columns with corresponding recognized column types (Currency, Date, etc.). Just click Finish.
Screenshot - Line
  1. A message will appear that showing that the table was successfully published and also provide the link to where you can view the table as the SharePoint list.

Sources:
How to Import Excel List Items to an Existing SharePoint List
How to Import Excel to SharePoint List?
3 ways to import Excel to SharePoint

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous How to stop syncing document libraries in OneDrive
Next Microsoft Bookings
Table of Contents