How to Import Excel Data to an Existing SharePoint List (Step-by-Step)

To import Excel data to an existing SharePoint list, copy the cells from Excel (Ctrl+C), open the SharePoint list in Quick Edit mode (click "Edit" in the command bar to enable grid/datasheet view), navigate to the first empty row using keyboard cursor keys, and paste with Ctrl+V. SharePoint will validate each field - data types must match between Excel and the SharePoint list columns (e.g., dates, numbers). Fix any validation errors shown by warning icons, then click "Stop" to exit Quick Edit and save. This method works in SharePoint Online and SharePoint On-Premises using modern browsers. For large imports (thousands of rows), use Power Automate or the SharePoint REST API for more reliable bulk data transfer.

Why Is There No Native "Import from Excel" Button in SharePoint?

SharePoint Online includes an "Export to Excel" button in every list view, but there is no reciprocal "Import from Excel" button for adding data to an existing list. This is a common pain point for SharePoint users - particularly those migrating data or managing lists maintained in Excel.

There are several ways to get around this limitation:

This guide focuses on the Quick Edit copy-paste method - the fastest approach for most users with smaller data sets.

We have been working with a great deal of SharePoint customers lately and there’s one major query they ask for: “How do I import excel list items to an existing SharePoint List?”

For SharePoint Online users we have an easy method available now which lets you create a list in SharePoint by importing an existing Excel Spreadsheet.
Allow me to explain how easy is will be for you to import an excel spreadsheet to a new SharePoint List. Especially with our customers, they have been asking for a solution to upload their sales contacts, companies, opportunities and activities list, which they used to do it manually earlier.

So, how do we do this? Why should we create a custom import button, or depending on Microsoft Access, to import data? I do agree the fact that if you have thousands of records, you have no choice but to go for the custom buttons. Otherwise, keep reading…

Specifically, for our non-profit customers, they’re always in need of transferring Excel data to a SharePoint List. You may have noticed there’s an “Export to Excel” feature, as shown below, but there isn’t a “Import from Excel” button. We can only hope that Microsoft comes up with a solution soon!

The only way for us to tackle this issue is to simply copy/paste Excel items into the SharePoint List. But wait. Didn’t we try it earlier? Yes, we didn’t succeed because we were using Google Chrome, Safari or Mozilla FireFox we browsers to do this action. I will be providing a step-by-step guide along with screenshots using Microsoft SharePoint Online instance. If you’re using a SharePoint On-Prem, don’t worry, it works for it too.

How Do You Import Excel Data to an Existing SharePoint List?

Before you start - prerequisites:

• You must have Edit or higher permissions on the SharePoint list
• Column names and data types in Excel must match the SharePoint list columns
• Date fields must be in a format SharePoint recognizes (e.g., MM/DD/YYYY)
• You need a modern browser (Microsoft Edge, Chrome, or Firefox) - the original Internet Explorer method is no longer required in SharePoint Online

Steps:

• Open your Excel spreadsheet and select the cells you want to transfer to the SharePoint list. Press Ctrl+C to copy.
• Ensure field types match: date fields must match the SharePoint list's date column format; number fields must not contain text. Mismatches will cause validation errors.
• Navigate to your SharePoint list. Click the Edit button in the command bar (or in older SharePoint versions, the Quick Edit button). This opens the list in grid/datasheet view.
• Using your keyboard cursor keys (arrow keys), navigate to the first empty cell in the row below the last existing list item. Do not use the mouse to click - use keyboard navigation for the paste to work correctly.
• Press Ctrl+V to paste. If your browser shows a clipboard access permission prompt, click Allow.
• SharePoint validates each pasted row. Items with data type mismatches display a warning icon. Review and fix any errors before proceeding.
• Once all data is valid, click the Stop button (or click outside the grid) to exit Quick Edit mode. SharePoint saves the data automatically.

Note: In SharePoint Online (modern experience), click "Edit" in the list toolbar. The list will switch to an inline grid editing mode.

1. Open your Microsoft Excel spreadsheet, copy the cells that you wish to transfer to the desired SharePoint List.
2. Make sure the field type matches with the cells in the List.

For example, the date fields much match with the List Field Type, else it will throw an error.

3. Login to your SharePoint Online Instance using Internet Explorer and navigate to the desired List where you want to paste the Excel data. If you see the image below, the list has already some items. Please note that you should have sufficient permissions in order to edit the List. Get in touch with your SharePoint Administrator to verify.
4. Click on quick edit button as you see on the above image. This will open the list in a “datasheet” view. Navigate to the bottom of the list and select the empty cell where you wish to paste the values.

N.B. Use keyboard cursors to do the same, else it won’t work!

5. Press Ctrl-V to paste the values from your Excel Spreadsheet.
6. Click on Allow access button when you see the below popup on screen.
7. The Excel data gets pasted to the bottom of your List. Now, SharePoint validates the data and if the values do not match the data type, it shows a warning icon next to the items. It won’t allow you to save the records unless you have fixed it.
8. Once done, click on “Stop” button to complete the Excel Copying Process.
9. Voila! You just got your data pasted on your List! Amazing, isn’t it?

What Are Alternative Methods to Import Excel Data to SharePoint?

Method 2: Power Automate (Recommended for Recurring Imports)

For organizations that regularly need to push Excel data into SharePoint lists, Microsoft Power Automate provides a more scalable solution. A flow can be triggered manually or on a schedule to read rows from an Excel file stored in OneDrive or SharePoint and add them to a SharePoint list.

Key steps:

• Store the Excel file in SharePoint or OneDrive for Business.
• In Power Automate, create a new flow with the trigger "Manually trigger a flow" or a recurrence trigger.
• Add the action "List rows present in a table" (Excel connector) to read data.
• Add "Create item" (SharePoint connector) to write each row to the list.

Method 3: Create a New List from Excel (If Starting Fresh)

If you are starting with a new list - not importing to an existing one - SharePoint Online allows you to create a new list directly from an Excel spreadsheet via Site Contents > New > List > From Excel. This automatically creates columns matching the Excel table headers.

Method 4: SharePoint REST API or Microsoft Graph API (Large Scale)

For bulk imports of thousands of rows or automated integrations, the SharePoint REST API or Microsoft Graph API provides programmatic access. This requires developer resources but is the most reliable method for large data sets.