Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
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?
You can use built-in functionality to export excel table to SharePoint List.
More information here:https://support.office.com/en-us/article/export-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159-97282d256dab
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.
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 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.
Required, but never shown