How to append SP List with excel

[PytByt]

Hi All..

I new with SP list and

I need to know is there any way to append my SP list using Excel?
Or,
Is there a way that i can upload an excel document into my SP document folder and get its content then store it in my SP list so my list will appending?

Thank you,

pytbyt

[#2]

Unfortunately SharePoint does not provide that feature, so if you need to do this you have to build it (Develope it)

[#3]

Hi @Juan Carlos González Martín ,

how can i build it (develop it) ?

[#4]

Hi @PytByt !

I recommend MS Access. It is the easiest way there is!

Open Access (it will prompt you to save your database, so save it anywhere you like).

Click (in the menu) External Data > New Data Source > From online services > SharePoint list

The window will pop up where it asks you to provide the address of your sharepoint site. You should type something like this:

https://blablablabla.sharepoint.com/sites/Name_of_the_site

Click Next and the window will show all the lists on your Sharepoint site. Click on the checkbox of the list you need. And click ok.

On your left-hand side you will see your list from which you can remove/add/edit data.

I strongly recommend learning Access.

If you need  anything else, here I am!

[#5]

Hi @peanut , 

Thanks for the reply, 

But i don't have the Ms. Access. Also is not an option for my organization.

Is there any other way around to achieve this?

Thanks,

pytbyt