How can I upload data into an existing SharePoint List using Excel

Question

Hello, I would like to understand how could I upload data using an Excel into SharePoint List?
If there is a way, how would it work? Would it overwrite the data already existing on SharePoint List?

SharePoint allows me to do that only I'm going to create a new list

I appreciate your collaboration, thanks in advance

Answer 1

doesn't work

why isn't there an import utilit

Answer 2

Dear respected gustavo.motta923,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, it seems that you want to import data from an Excel sheet into a SharePoint list that already contains data in it. Basically, add to the SharePoint Existing list that's already in SharePoint without overwriting the existing. The easy way is you go to Edit in grid view on your list you can paste in data from an Excel spreadsheet.

In the list, click "Edit in grid view" in the ribbon.

![](https://learn-attachment.microsoft.com/api/attachments/ccf871a2-39ed-4831-9940-34a66d418039?platform=QnA

Answer 3

This did not work for me. All data was pasted into the first cell...

Answer 4

Same. Have you figured out how to correctly do it yet?

Edit: Click the circle on the left of the row, to highlight the whole row, then paste your data. You have to do it line by line, but it worked that way. Hope this helps!

Answer 5

I know this isn't the ask, but it is the more elegant and easy solution.

Use Microsoft Access

It natively connects to SharePoint lists.

I usually use this method to append or update entries on the SharePoint List.

Do a search for: append to SharePoint list using Microsoft access

Another option is Power Automate I like this option because it can run by itself especially if you use the cloud version.

Do a search for: append to SharePoint list using power automate