Join Mark Abdelnour for an in-depth discussion in this video Copy and paste from Excel to a list , part of SharePoint Tips and Tricks.
- [Voiceover] This tip definitely highlights the integration benefits between Office applications, like Microsoft Excel, and SharePoint 2013. I have data in Excel that I want to use in a list in SharePoint. Now, there are ways to import Excel spreadsheets, but what if we needed to do a simple copy-paste operation? Let's take a look here in the Marketing Q&A list. You'll see that there's already two entries of questions that have been asked, and you'll also notice here, an Excel application is open with a file, and in it, are several other questions that have yet to be integrated into this list.
Now, as I mentioned earlier, we could import the spreadsheet into this list, but instead, there is definitely a faster way. I can select the content, here within the Excel file, as I've done here, right mouse click and select Copy, and now with this content copied to the clipboard, I'm just going to go ahead and minimize it. Now, here within the list, I can't just simply paste, but what I can do is go right up here to the Office ribbon bar, and click on the List tab.
Here, I'll click on Quick Edit. This turns our list into something that looks more like a spreadsheet. From here, we simply click in the first empty cell where we want the content to be pasted. So, with that cell selected, and you can tell that it's selected by this blue outline that goes around the field, I'm just going to simply press Control V on my keyboard. Control V is just a paste operation using your keyboard. Now you can see that all the data has been pasted right into the list.
So, as you just saw, you can save yourself a lot of time copy-pasting content from Office applications into a SharePoint list, but there is one fairly important note to consider. This copy-paste operation will only work in scenarios where the data in Excel matches to the columns or metadata contained in the list. For example, you couldn't copy-paste a text cell from Excel into a number field in the SharePoint list. This will produce errors in SharePoint and require fixing for each of those problematic fields.