How To Copy Paste From Excel To a SharePoint List

This tutorial will show you how to copy and paste from an Excel Spreadsheet to a SharePoint Online List. Specifically, this tutorial will show you how you can copy paste from excel to a SharePoint list using the quick edit function. Using the quick edit function, you can copy and paste items from excel to your SharePoint list effortlessly to save time on data entry. Quick edit is also sometimes referred to as the SharePoint datasheet view which lets you operate on your data in a tabular format.

#Sharepoint #SharePointOnline #microsoft365

-MORE ABOUT ME-

LETS BE FRIENDSI

GOT A VIDEO IDEA? FILL OUT THIS FORM:

📧 PRODUCTS THAT I USE TO CREATE MY YOUTUBE VIDEOS:

SOFTWARE THAT I USE TO CREATE MY YOUTUBE VIDEOS & CONTENT:

OTHER SERVICES THAT I USE:

Note that I may earn a small commission at no additional cost to you from purchases made using these links.

[LuiIacobellis]

OTHER SHAREPOINT NEWS TUTORIALS:
How To Add a News Web Part To a SharePoint Online Site:
How To Delete a Post in a SharePoint Online News Web Part:
WATCH NEXT:
How To Connect a SharePoint List To Excel:
How To Add Email Notifications To A SharePoint List:
How To Add A Calendar To A SharePoint Online Site:
How To Create A Status Column In A SharePoint List:

[michaelshelnutt]

When I control V, it is putting ALL the table data in that first field instead of spreading out the data to the appropriate fields.

[marcdoliveira]

Outstanding and right to the point. Thank you.

[nnylsnosrap]

Thank you Lui! I'm so glad not to be reverting back to Internet Explorer to accomplish this. I could not even sign onto sharepoint from IE any more!

When I first tried pasting in the edit in gridview mode, all the rows from the spreadsheet ended up in the first cell (same old problem). But since you showed that this works and in your sample some data was already in the list, i tried adding a 1st record in the list and then when i did the paste in the 2nd row cell it worked like a charm. Thank you!

Thinking maybe my issue was that I only have one column in my list (its a lookup)

[EpicDreamer_]

Thanks Lui! I’ve been struggling with huge excel file to be imported into SP list, hope your advice will help me in solving my problem!

[RoxanneRyan-whwc]

Hi Lui and thanks for your video! When I paste, I'm getting the following error: "The format of the clipboard data is not recognized." Have you had any experience with this, by chance?

[brad_mcallister]

Nice, in edge works as desired thank you

[myravillanueva]

So awesome. Can multiple users do this task on the same SP at the same time?

[vLife]

Valuable! Subbed. What's the best way to deal with cells that have carriage returns? Getting some format error because of it.

[krisvenema]

Is there a way to paste and keep formatting (bold, italic, etc) without having to do one cell at a time? If I paste an entire column the formatting is removed.

[pamelac]

I’ve tried this multiple times and my excel data will not cleanly paste into MS list. Not sure what I’m doing wrong but still trying!

[akio]

How about to just paste values for one column?

[tanvimathur]

Can we add a column from excel that contain hyperlinks to Microsoft list?

[jomarosetiu]

Totally off-topic, but do you have an idea how to copy data from an Excel spreadsheet into an MS Access database that is published in Sharepoint?

[MrDarrensparks]

Hi When I paste into the first cell it pastes everything into the 1st cell without populating any other columns or lines. Any ideas?

[carlosriedel]

After pasting, when trying to save, it gives me the following error: The user does not exist or is not unique

[kadavesukesh]

Hi Lui, this copy-paste trick only works in Internet explorer. It doesn't work in any other browser. Is there any solution?

[insurancebotunitel]

How to copy a text with apostrophe in it? when I tried it, the character was turned into &#39.

[MichaelParrott]

Who knew copy-pasting could be so difficult lol

[legendgod]

How can you paste value from Excel into multiple choice column?