How to append SP List with excel

Question

Hi All..I new with SP list andI 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&nbsp;

jcgonzalezmartin · Answer

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

pytbyt · Answer

Hi jcgonzalezmartin&nbsp;,how can i build it (develop it) ?

peanut · Answer

Hi&nbsp;PytByt&nbsp;!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 &gt; New Data Source &gt; From online services &gt; SharePoint listThe 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_siteClick 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&nbsp; anything else, here I am!&nbsp;&nbsp;

pytbyt · Answer

Hi&nbsp;peanut&nbsp;,&nbsp;Thanks for the reply,&nbsp;But i don't have the Ms. Access. Also is not an option for my organization.&nbsp;Is there any other way around to achieve this?Thanks,pytbyt

Forum Discussion

How to append SP List with excel

Share

Resources