How to append SP List with excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1109209%22%20slang%3D%22en-US%22%3EHow%20to%20append%20SP%20List%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109209%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All..%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20new%20with%20SP%20list%20and%3C%2FP%3E%3CP%3EI%20need%20to%20know%20is%20there%20any%20way%20to%20append%20my%20SP%20list%20using%20Excel%3F%3CBR%20%2F%3EOr%2C%3CBR%20%2F%3EIs%20there%20a%20way%20that%20i%20can%20upload%20an%20excel%20document%20into%20my%20SP%20document%20folder%20and%20get%20its%20content%20then%20store%20it%20in%20my%20SP%20list%20so%20my%20list%20will%20appending%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%2C%3C%2FP%3E%3CP%3Epytbyt%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1109209%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1109322%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20append%20SP%20List%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109322%22%20slang%3D%22en-US%22%3EUnfortunately%20SharePoint%20does%20not%20provide%20that%20feature%2C%20so%20if%20you%20need%20to%20do%20this%20you%20have%20to%20build%20it%20(Develope%20it)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1109336%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20append%20SP%20List%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109336%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ehow%20can%20i%20build%20it%20(develop%20it)%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1109367%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20append%20SP%20List%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109367%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F518842%22%20target%3D%22_blank%22%3E%40PytByt%3C%2FA%3E%26nbsp%3B!%3C%2FP%3E%3CP%3EI%20recommend%20MS%20Access.%20It%20is%20the%20easiest%20way%20there%20is!%3C%2FP%3E%3CP%3EOpen%20Access%20(it%20will%20prompt%20you%20to%20save%20your%20database%2C%20so%20save%20it%20anywhere%20you%20like).%3C%2FP%3E%3CP%3EClick%20(in%20the%20menu)%20External%20Data%20%26gt%3B%20New%20Data%20Source%20%26gt%3B%20From%20online%20services%20%26gt%3B%20SharePoint%20list%3C%2FP%3E%3CP%3EThe%20window%20will%20pop%20up%20where%20it%20asks%20you%20to%20provide%20the%20address%20of%20your%20sharepoint%20site.%20You%20should%20type%20something%20like%20this%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fblablablabla.sharepoint.com%2Fsites%2FName_of_the_site%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblablablabla.sharepoint.com%2Fsites%2FName_of_the_site%3C%2FA%3E%3C%2FP%3E%3CP%3EClick%20Next%20and%20the%20window%20will%20show%20all%20the%20lists%20on%20your%20Sharepoint%20site.%20Click%20on%20the%20checkbox%20of%20the%20list%20you%20need.%20And%20click%20ok.%3C%2FP%3E%3CP%3EOn%20your%20left-hand%20side%20you%20will%20see%20your%20list%20from%20which%20you%20can%20remove%2Fadd%2Fedit%20data.%3C%2FP%3E%3CP%3EI%20strongly%20recommend%20learning%20Access.%3C%2FP%3E%3CP%3EIf%20you%20need%26nbsp%3B%20anything%20else%2C%20here%20I%20am!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1109371%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20append%20SP%20List%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109371%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F258034%22%20target%3D%22_blank%22%3E%40peanut%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20the%20reply%2C%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20i%20don't%20have%20the%20Ms.%20Access.%20Also%20is%20not%20an%20option%20for%20my%20organization.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20other%20way%20around%20to%20achieve%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3C%2FP%3E%3CP%3Epytbyt%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

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

Hi @Juan Carlos González Martín ,

how can i build it (develop it) ?

Highlighted

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!

 

 

Highlighted

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