Forum Discussion
How to append SP List with excel
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 c...
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!
