Forum Discussion
Upload data from several excel to one SPO list
Hello. I need to upload data from several excel files to the one SPO list. Could someone advice hove to do this correctly and if this possibility exists?
You have some options here to achieve this:
(1) Write a PS Scripts that reads your Excel files and upload the data to a SPO list
(2) Upload the Excel files in SPO and use Flow to access the content in the files to store them in the SPO list
(1) Write a PS Scripts that reads your Excel files and upload the data to a SPO list
(2) Upload the Excel files in SPO and use Flow to access the content in the files to store them in the SPO list
- you could also use 'quick edit' to copy & paste the data from excel directly into your lists. See https://sharepointmaven.com/3-ways-import-excel-sharepoint/ for some other options.
