5

I have to upload data of excel columns to SharePoint list and the excel has got 8 to 9 sheets. I tried copy paste every thing but is quite hectic. Then I tried using Import Excel Sheet app but then its throws an error saying :

"Unexpected Error has occurred".

Any suggestions with which I can do this with ease?

enter image description here

Improve this question
4
  • are you using google chrome!
    – cjs
    CommentedAug 1, 2017 at 11:19
  • Nope. I am using Internet Explorer.
    – Anand
    CommentedAug 1, 2017 at 14:17
  • Hi @Anand I have a very thorough and tested solution for exactly what you're looking for on a related question. Answer: Import/Copy/Paste Data from Excel into Existing SharePoint List.
    – Chiramisu
    CommentedNov 14, 2017 at 18:06
  • Which version of Office? Excel 2013 can able to upload to SharePoint 2013, but may not be compatible with SPO.
    – Underverse
    CommentedNov 4, 2018 at 5:19

1 Answer 1

Reset to default
2

Try this powershell script. You need to change some parameter.

http://www.c-sharpcorner.com/blogs/load-csv-file-value-into-sharepoint-list-using-powershell-script

Improve this answer

    Start asking to get answers

    Find the answer to your question by asking.

    Ask question

    Explore related questions

    See similar questions with these tags.