This will open the list in a “datasheet” view.

Click on quick edit button as you see on the above image.

Get in touch with your SharePoint Administrator to verify. Please note that you should have sufficient permissions in order to edit the List. If you see the image below, the list has already some items.

Login to your SharePoint Online Instance using Internet Explorer and navigate to the desired List where you want to paste the Excel data.

Make sure the field type matches with the cells in the List.įor example, the date fields much match with the List Field Type, else it will throw an error.

Open your Microsoft Excel spreadsheet, copy the cells that you wish to transfer to the desired SharePoint List.If you’re using a SharePoint On-Prem, don’t worry, it works for it too. I will be providing a step-by-step guide along with screenshots using Microsoft SharePoint Online instance.

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. The only way for us to tackle this issue is to simply copy/paste Excel items into the SharePoint List.

We can only hope that Microsoft comes up with a solution soon! You may have noticed there’s an “Export to Excel” feature, as shown below, but there isn’t a “Import from Excel” button. Specifically, for our non-profit customers, they’re always in need of transferring Excel data to a SharePoint List. 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. 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. 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?”įor SharePoint Online users we have an easy method available now which lets you create a list in SharePoint by importing an existing Excel Spreadsheet.Īllow me to explain how easy is will be for you to import an excel spreadsheet to a new SharePoint List.

Paste list into excel