cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

I have one Sharepoint Lists, I want import data from Excel, how to do?

Andrew_Lu1981
Copper Contributor

‎May 28 2023 07:28 PM

‎May 28 2023 07:28 PM

I have one Sharepoint Lists, I want import data from Excel, how to do?

I have one Sharepoint Lists, I want import data from Excel, how to do?

Labels:
1,114 Views
0 Likes
1 Reply
Reply
1 Reply
jcgonzalezmartin

‎May 28 2023 10:42 PM

‎May 28 2023 10:42 PM

Re: I have one Sharepoint Lists, I want import data from Excel, how to do?

Hi,
Different options that come to my mind:
(1) Edit the list with Quick Edit mode, copy data from Excel an paste it into the list
(2) Save the Excel file as CSV, process the content with PowerShell and use PnP PowerShell to upload data into the list: https://www.sharepointdiary.com/2014/08/sharepoint-online-add-new-list-item-using-csom-powershell.ht...
(3) Process the Excel file with a Power Automate Flow that read the Excel file and upload the data into the list: https://www.youtube.com/watch?v=F2leKcMPAtw
0 Likes
Reply