0

Is it possible to export data from excel to exisiting sharepoint list i do not want to create new one ,copy paste datasheetview is not working as expected and taking time do we have any options?

  • I've built universal solution for this. It can be activated by feature for any list in site collection.<br> Here is video description (in Russian lang): youtube.com/watch?v=pn_jTnM_eUU<br> Please contact me if you are interested. My e-mail: t602xp@gmail.com, kind regards, Yuriy. – Yuriy Sednev Sep 13 at 15:32
1

You can use built-in functionality to export excel table to SharePoint List. enter image description here

More information here:https://support.office.com/en-us/article/export-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159-97282d256dab

Update:

For export table to existing SharePoint list, you can use a flow to do the work. Here is a sample flow works in my end. You can have a try. enter image description here

  • But it will create new list can we write in existing one – kumar Sep 16 at 4:22
  • 1
    @kumar I have add a sample flow. Have a try. – jerry_MSFT Sep 16 at 6:42
  • Thank you i will give a try – kumar Sep 17 at 11:01
0

make sure the sp format and excel format are the same (fields /columns) in order to do the below:

go to excel, copy paste information

go to Sharepoint list, click List, then quick edit

paste the copied information in the table

  • i have done this checks and able to paste data till 20 or 30 rows if i am doing paste more than 500 it does not work i have 51 columns to update – kumar Sep 13 at 9:56
0

I would create a quick ms flow for this... there is plenty of EXCEL connectors and Sharepoint connectors.. should only take 5 mins... if you need me to write one for you let me know.

  • if you can it will be great – kumar Sep 13 at 11:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.